55316A Administering a SQL Database Infrastructure

55316A is the updated version of the retired legacy Microsoft Official Curriculum (MOC) Course 20764A - Administering a SQL Database Infrastructure.

The 55316A 5-day instructor-led course will provide training in how to administer and maintain SQL Server, Azure SQL Database and other cloud-based SQL Server databases.  New content has been added to help administrators use new AI and ML features in SQL Server. Students will run T-SQL, Python and R queries on SQL Server databases and have the option of doing exercises to install and configure SQL Server Machine Learning Services.

IT professionals who work in environments where databases play a key role in their job will find the demonstrations and labs useful. By using hands-on exercises, students will learn to carry out important database administration tasks.

What's included?

  • 15 Chapters
  • 15 Reviews
  • 15 Labs


The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.

At Course Completion

After completing this instructor-led course, students will be able to:
• Authenticate and authorize users
• Assign server and database roles
• Authorize users to access resources
• Use encryption and auditing features to protect data
• Describe recovery models and backup strategies
• Backup and Restore SQL Server databases
• Automate database management
• Configure security for the SQL Server agent
• Manage alerts and notifications
• Managing SQL Server using PowerShell
• Trace access to SQL Server
• Monitor a SQL Server infrastructure
• Troubleshoot a SQL Server

Course Lessons

Guaranteed Security using one of the most advanced encrypted systems on the market.
The information in this page is being processed and encrypted securely using industry-leading encryption and fraud prevention tools.