20764: Administering a SQL Database Infrastructure

27/3/2023

This forty hours instructor-led 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.

Audience(s):  IT Professionals
Technology: SQL Server 2016
Duration:  40 hours

Module 1: SQL Server Security

Module 2: Assigning Server and Database Roles

Module 3: Authorizing Users to Access Resources

Module 4: Protecting Data with Encryption and Auditing

Module 5: Recovery Models and Backup Strategies

Module 6: Backing Up SQL Server Databases

Module 7: Restoring SQL Server 2016 Databases

Module 8: Automating SQL Server Management

Module 9: Configuring Security for SQL Server Agentwith Alerts and Notifications

Module 11: Introduction to Managing SQL Server by using PowerShell

Module 12: Tracing Access to SQL Server with Extended events

Module 13: Monitoring SQL Server

Module 14: Troubleshooting SQL Server

Module 15: Importing and Exporting Data

See Complete Content

More Information