Administering a SQL Database Infrastructure

(no reviews)

Level: Certificate

Visit Website Call Now

Entry Requirement

Basic knowledge of the Microsoft Windows operating system and its core functionality. Working knowledge of Transact-SQL. Working knowledge of relational databases. Some experience with database design.

Course Content

SQL Server Security
Assigning Server and Database Roles
Authorizing Users to Access Resources
Protecting Data with Encryption and Auditing
Recovery Models and Backup Strategies
Recovery Models and Backup Strategies
Restoring SQL Server 2016 Databases
Automating SQL Server Management
Configuring Security for SQL Server Agent
Monitoring SQL Server with Alerts and Notifications
Introduction to Managing SQL Server by using PowerShell
Tracing Access to SQL Server with Extended events
Monitoring SQL Server
Troubleshooting SQL Server
Importing and Exporting Data

Inquire Now

Share your thoughts

If you’ve follow this course, share your thoughts with other students.