55353B Administering a SQL Database Infrastructure with SQL Server 2025
This course teaches students how to administer a modern SQL Server 2025 database infrastructure. Students learn how to configure security, manage permissions, protect data, design backup and recovery strategies, automate routine administration, monitor server health, troubleshoot infrastructure issues, and perform common data movement tasks.
The course keeps a structure close to the earlier Administering a SQL Database Infrastructure course while adding updated SQL Server 2025 coverage, Azure SQL Database administration and monitoring, SSMS 22 usage, Visual Studio Code usage, and PowerShell-based management.
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 course, students will be able to: * Install and configure SQL Server 2025 database instances
* Manage SQL Server services, instance settings, and core infrastructure components
* Configure authentication, logins, users, roles, and permissions
* Implement role-based security for databases and server-level administration
* Create and manage backup strategies using full, differential, and transaction log backups
* Restore databases and transaction logs to recover from failures or data loss
* Configure and support high-availability and disaster recovery solutions
* Monitor SQL Server performance using DMVs, Extended Events, Query Store, Activity Monitor, and Performance Monitor
* Secure databases using Transparent Data Encryption, Always Encrypted, and SQL Server Audit
* Automate common administration tasks using SQL Server Agent and PowerShell
* Manage and monitor Azure SQL Database using SQL Server tools and PowerShell.
* Manage SQL Server services, instance settings, and core infrastructure components
* Configure authentication, logins, users, roles, and permissions
* Implement role-based security for databases and server-level administration
* Create and manage backup strategies using full, differential, and transaction log backups
* Restore databases and transaction logs to recover from failures or data loss
* Configure and support high-availability and disaster recovery solutions
* Monitor SQL Server performance using DMVs, Extended Events, Query Store, Activity Monitor, and Performance Monitor
* Secure databases using Transparent Data Encryption, Always Encrypted, and SQL Server Audit
* Automate common administration tasks using SQL Server Agent and PowerShell
* Manage and monitor Azure SQL Database using SQL Server tools and PowerShell.
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.