This instructor-led course provides students who manage SQL Server and Azure SQL databases with the knowledge and skills necessary to manage a SQL Server database infrastructure. The material will also be useful to people who develop applications that deliver content from SQL Server databases. This material updates and replaces course 20764C.
The primary audience for this course is people who administer and maintain SQL Server databases. These people 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. The secondary audiences for this course are people who develop applications that deliver SQL Server database content.
Module 1: SQL Server Security
This module describes SQL Server security models, logins, users, partially contained databases, and cross-server authorization. Lessons
Lab 1: SQL Server Security
After completing this module, students will be able to:
Module 2: Assigning Server and Database Roles
This module explains how to use server- and database-level roles to manage user permissions.
Lessons
Lab 1: Assigning Server and Database Roles
Module 3: Authorization of users to access resources
This module explains how to authorize users to access server and database functions. It also describes how to manage permissions at different levels on an instance of SQL Server.
Lab 1: Authorizing users to access resources
Module 4: Data Protection with Encryption and Auditing This module describes the options available for auditing and how to manage audit functions. It also describes how to configure and implement data encryption. Lessons
Lab 1: Using auditing and encryption
Module 5: Recovery Models and Backup Strategies In this module, you will learn how to use the backup functions available for databases and transaction logs to create backup strategies.
Lab 1: Understanding SQL Server Recovery Models
Module 6: SQL Server Database Backup
In this module, you will learn how to apply various backup strategies.
Lab 1: Database Backup
Module 7: Restoring SQL Server Databases In this module, you will see how to restore the system and user databases and how to implement point-in-time recovery.
Lab 1: Restoring SQL Server Databases
Module 8: Automating SQL Server Administration This module describes how to use SQL Server Agent to automate jobs, how to configure security contexts for jobs, and how to deploy multi-server jobs.
Lab 1: Automating SQL Server Administration
Module 9: Security Configuration for SQL Server Agent This module explains how to configure SQL Server Agent to use a least privilege security environment and how to use credentials and proxy accounts to run jobs securely.
Lab 1: Configuring SQL Server Agent
Module 10: Monitoring SQL Server with Alerts and Notifications This module covers configuring database email, alerts, and notifications for an instance of SQL Server and configuring alerts for Microsoft Azure SQL Database.
Lab 1: Monitoring SQL Server with Alerts and Notifications
Module 11: Introduction to SQL Server Administration Using PowerShell This module explains how to use Windows PowerShell with Microsoft SQL Server and Azure SQL Database. It also describes how to improve efficiency and reliability by scripting tasks and jobs.
Lab 1: Using PowerShell to Manage SQL Server
Module 12: Tracking SQL Server Access with Extended Events This module explains how to monitor performance metrics for SQL Server and Azure SQL Database. It also describes troubleshooting strategies and usage scenarios for working with extended events.
Lab 1: Using SQL Server Extended Events
Module 13: SQL Server Monitoring This module explains how to monitor databases in order to proactively address potential problems. It also describes how to use the provided built-in tools to analyze instance and server activity.
Lab 1: Monitoring SQL Server
Module 14: Troubleshooting SQL Server This module explains how to resolve common problems that may arise when working with SQL Server systems. It also describes a methodology for resolving general database server problems.
Lab 1: Troubleshooting SQL Server
Module 15: Import and export of data This module explains how to use native SQL Server tools to import and export data to and from SQL Server and Azure SQL Databases.
Lab 1: Data Import and Export
English course
Labs: English