Administering a SQL Database Infrastructure (M20764)
Learn to administer and maintain Microsoft SQL Server 2016 databases.
GK# 4396 Vendor# M20764
Learn to administer and maintain Microsoft SQL Server 2016 databases.
GK# 4396 Vendor# M20764
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. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases.
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.
Learn more about this topic. View the recorded webinar Overview of Microsoft SQL Server and High Availability Options
1. SQL Server Security
2. Assigning Server and Database Roles
3. Authorizing Users to Access Resources
4. Protecting Data with Encryption and Auditing
5. Recovery Models and Backup Strategies
6. Backup of SQL Server Databases
7. Restoring SQL Server 2016 Databases
8. Automating SQL Server Management
9. Configuring Security for SQL Server Agent
10. Monitoring SQL Server with Alerts and Notifications
11. Introduction to Managing SQL Server by using PowerShell
12. Tracing Access to SQL Server with Extended events
13. Monitoring SQL Server
14. Troubleshooting SQL Server
15. Importing and Exporting Data
Lab 1: Authenticating Users
Lab 2: Assigning Server and Database Roles
Lab 3: Authorizing Users to Access Resources
Lab 4: Using Auditing and Encryption
Lab 5: Understanding SQL Server Recovery Models
Lab 6: Backing Up Databases
Lab 7: Restoring SQL Server User Databases
Lab 8: Automating SQL Server Management
Lab 9: Configuring Security for SQL Server Agent
Lab 10: Monitoring SQL Server with Alerts and Notifications
Lab 11: Using PowerShell to Manage SQL Server
Lab 12: Extended Events
Lab 13: Monitoring SQL Server
Lab 14: Troubleshooting Common Issues
Lab 15: Importing and Exporting Data
The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals 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.
Redeeming your Microsoft Software Assurance Training Vouchers:
For more information on Microsoft SATVs, click here.
This course comes with 12 months access to the following benefits:
This course is available in the following formats:
Experience expert-led online training from the convenience of your home, office or anywhere with an internet connection.
Receive face-to-face instruction at one of our training center locations.