After following this course, the students will be able to:

This course is for individuals who administer and maintain SQL Server databases. They 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.

To participate in this course, the students will need:

Classical and Tailor iT made training

During this course the following topices will be covered:

Module 1: Authenticating and Authorizing Users

Module 2: Assigning Server and Database Roles

Module 3: Authorizing Users to Access Resources

Module 4: Protecting Data with Encryption and Auditing

Module 5: SQL Server Recovery Models

Module 6: Backup of 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

Module 13: Monitoring SQL Server

Module 14: Troubleshooting SQL Server

Module 15: Importing and Exporting Data