COURSE OVERVIEW

In this course, professionals who administer and maintain SQL Server databases and who develop applications that deliver content from SQL Server databases will gain the knowledge and skills to administer a SQL server database infrastructure.

This course incorporates material from the Official Microsoft Learning Product 20764: Administering a SQL Database Infrastructure and can assist you in preparing for the 70-764: Administering a SQL Database Infrastructure exam. 

GK Digital Learning is also available with digital Microsoft Official Courseware (dMOC).

  • Authenticate and authorize users.
  • Assign server and database roles.
  • Authorize users to access resources.
  • Protect data with encryption and auditing.
  • Recovery models and backup strategies.
  • Back up SQL Server databases.
  • Restore SQL Server databases.
  • Automate database management.
  • Configure security for the SQL Server agent.
  • Manage alerts and notifications.
  • Manage SQL Server using PowerShell.
  • Trace access to SQL Server.
  • Monitor a SQL Server infrastructure.
  • Troubleshoot a SQL Server infrastructure.
  • Import and export data.