65316A - Administering a SQL Database Infrastructure (2025)
This 5-day instructor-led course provides training in how to administer and maintain SQL Server 2025, Azure SQL Database, and other cloud-based SQL Server databases. IT professionals who work in environments where databases play a key role in their jobwill fi nd the demonstrations and hands-on labs useful for learning to carry out important database administration tasks.
What's included?
-
15 Modules
-
15 Reviews
-
15 Labs
Audience
The primary audience for this course is individuals who administer and maintain SQL Server 2025 databases. Much of the material and labs will also apply to earlier versions. These individuals perform database administration and maintenance as their primary area of responsibility.
At course completion
After completing this instructor-led course, students will be able to:
• Authenticate and authorize users
• Assign server and database roles
• Authorize users to access resources
• Use encryption and auditing features to protect data
• Describe recovery models and backup strategies
• Backup and Restore SQL Server databases
• Automate database management
• Configure security for the SQL Server agent
• Manage alerts and notifications
• Managing SQL Server using PowerShell
• Trace access to SQL Server
• Monitor a SQL Server infrastructure
• Troubleshoot a SQL Server
Course Lessons