Fast Track: MCSA SQL 2016 Database Administration

Administering a SQL Database Infrastructure (MOC 20764)

Module 1: Authenticating and Authorizing Users
Module 2: Assigning Server and Database Roles
Module 3: Authorizing Users to Access Resources
Module 4: Protecting Data with Encryption and Auditing
Module 5: SQL Server Recovery Models
Module 6: Backup of SQL Server Databases
Module 7: Restoring SQL Server 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
Module 13: Monitoring SQL Server
Module 14: Troubleshooting SQL Server
Module 15: Importing and Exporting Data
Provisioning SQL Databases (MOC 20765)


Module 1: SQL Server 2016 Components
Module 2: Installing SQL Server 2016
Module 3: Upgrading SQL Server to SQL Server 2016
Module 4: Deploying SQL Server on Microsoft Azure
Module 5: Working with Databases
Module 6: Database Storage Options
Module 7: Performing Database Maintenance