Administering a SQL Database

Course Number: 55316
Days: 5
Price: $2,895.00

 

Course Description

The 55316A five-day instructor-led course will provide training in how to administer and maintain SQL Server and Azure SQL databases. IT professionals who work in environments where databases play a key role in their job will find this material useful. By using demonstrations and hands-on lab exercises, students will learn to carry out these important tasks.

 

Prerequisites

Before attending this course students should be familiar with the basics of a database.

 

Course Topics

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 Databases
Module 8: Automating SQL Server Management
Module 9: Configuring Security for SQL Server Agent
Module 10: Monitoring SQL Server with 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