Course Description

The course "DML Server Administration" is designed to provide students with a comprehensive understanding of Microsoft SQL Server administration. The course is suitable for IT professionals who are responsible for managing and maintaining SQL Server databases, as well as for those who are looking to expand their knowledge of SQL Server administration. The course covers a range of topics related to SQL Server administration, including installation and configuration of SQL Server, database design and creation, backup and restore, security management, and performance tuning. Students will also learn about advanced features such as high availability, disaster recovery, and cloud integration. The course is divided into several modules, each focusing on a specific aspect of SQL Server administration. The first module covers the basics of SQL Server installation and configuration, including system requirements, installation options, and post-installation tasks. Students will also learn about server-level and database-level configuration options, and how to configure SQL Server instances for optimal performance and security. The second module covers database design and creation, including data modeling, normalization, and database schema design. Students will learn how to create and manage database objects such as tables, views, indexes, and stored procedures, and how to optimize database performance. The third module focuses on backup and restore, including backup strategies, recovery models, and disaster recovery planning. Students will learn how to back up and restore databases and how to perform point-in-time recovery and partial restores. The fourth module covers security management, including user authentication, database roles, and encryption. Students will learn how to configure security policies, how to manage users and permissions, and how to implement data encryption. The fifth module covers performance tuning, including query optimization, indexing strategies, and monitoring and troubleshooting techniques. Students will learn how to use SQL Server Profiler and other diagnostic tools to identify performance issues and how to optimize query performance. The final module covers advanced features such as high availability, disaster recovery, and cloud integration. Students will learn how to configure database mirroring, log shipping, and replication, and how to integrate SQL Server with cloud services such as Azure and AWS. By the end of the course, students will have a solid understanding of SQL Server administration and will be able to configure, manage, and maintain SQL Server databases with confidence. Author: (Alison)