55316 Data Analyst

Administering a SQL Database

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 Modules

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. Backing Up SQL Server Databases
7. Restoring SQL Server 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