Course Syllabus

What you’ll learn

Module 1: SQL Server Management
This module introduces the SQL Server Agent, which you will use to create and execute management jobs. You will also learn the role of PowerShell for managing SQL Server.

Module 2: SQL Server Monitoring and Troubleshooting
This module covers built-in tools to monitor and troubleshoot activities and errors in SQL Server. You will learn how to monitor SQL Server with powerful extended events.

Module 3: SQL Server Maintenance
This module covers verifying backups, updating SQL Server, managing statistics, indexes, and performing integrity checks.