20764: Administering a SQL Database Infrastructure

Logo SQL Server

Course 20764C: Administering a SQL Database Infrastructure

This course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases.

You will learn these contents:

  • Authenticate and authorize users.

  • Assign server and database roles.

  • Authorize users to access resources.

  • Protect data with encryption and auditing.

  • Describe recovery models and backup strategies.

  • Backup SQL Server databases.

  • 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 infrastructure.

  • Import and export data.

Conoce más detalles sobre este curso