55316B Administering a SQL Database Infrastructure 2025
This five-day instructor-led course provides students who manage SQL Server 2025 and Azure SQL databases with the knowledge and skills needed to administer a SQL Server 2025 database infrastructure. The material is also useful to individuals who develop applications that deliver content from SQL Server databases. In addition to SQL Server 2025 and Azure SQL Database, students will learn about SQL Server Management Studio 22 (SSMS 22).
Note: This course updates the content in course 55316A.
What's included?
-
15 Modules
-
15 Reviews
-
15 Labs
Audience
The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals 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.
At Course Completion
After completing this instructor-led course, students will be able to:
* Authenticate and authorize users using Windows and SQL Server authentication modes, server and database roles, and granular permission management in SQL Server 2025 and Azure SQL Database
* Protect data using SQL Server Audit, temporal tables, Transparent Data Encryption, Always Encrypted, and Dynamic Data Masking in SQL Server 2025 and Azure SQL Database
* Design and implement comprehensive backup strategies and perform full,differential, transaction log, and advanced restore operations including point-in-time recovery in SQL Server 2025
* Automate database management using SQL Server Agent jobs, schedules, multi-server management, alerts, notifications, Database Mail, and PowerShell with the SqlServer module
* Monitor, trace, and troubleshoot SQL Server 2025 infrastructure using Dynamic Management Views, Extended Events, Performance Monitor, Management Data Warehouse reports, and structured troubleshooting methodology
* Transfer data using bcp, BULK INSERT, SSIS, and data-tier application packages
* Protect data using SQL Server Audit, temporal tables, Transparent Data Encryption, Always Encrypted, and Dynamic Data Masking in SQL Server 2025 and Azure SQL Database
* Design and implement comprehensive backup strategies and perform full,differential, transaction log, and advanced restore operations including point-in-time recovery in SQL Server 2025
* Automate database management using SQL Server Agent jobs, schedules, multi-server management, alerts, notifications, Database Mail, and PowerShell with the SqlServer module
* Monitor, trace, and troubleshoot SQL Server 2025 infrastructure using Dynamic Management Views, Extended Events, Performance Monitor, Management Data Warehouse reports, and structured troubleshooting methodology
* Transfer data using bcp, BULK INSERT, SSIS, and data-tier application packages
Course Lessons
Guaranteed Security using one of the most advanced encrypted systems on the market.
The information in this page is being processed and encrypted securely using industry-leading encryption and fraud prevention tools.