Course Name : Administering a SQL Database Infrastructure – 20764

Duration : 5 Days

Course Index:

Module 1: SQL Server Security

Module 2: Assigning Server and Database Roles

Module 3: Authorizing Users to Access Resources

Module 4: Protecting Data with Encryption and Auditing

Module 5: Recovery Models and Backup Strategies

Module 6: Backing Up SQL Server Databases

Module 7: Restoring SQL Server 2016 Databases

Module 8: Automating SQL Server Management

Module 9: Configuring Security for SQL Server Agent

Module 10: Monitoring SQL Server with Alerts and
Notifications

Module 11: Introduction to Managing SQL Server by using
PowerShell

Module 12: Tracing Access to SQL Server with Extended events

Module 13: Monitoring SQL Server

Module 14: Troubleshooting SQL Server

Module 15: Importing and Exporting Data