Administering a SQL Database Infrastructure Training (55353)

Are your SQL Server systems secure, optimized, and ready for the demands of modern business? With over 70% of organizations relying on SQL databases to drive daily operations, the need for skilled database administrators is stronger than ever.

This instructor-led course on administering a SQL database infrastructure equips learners with practical skills to configure SQL Server security, implement backup strategies, manage access, monitor performance, and use PowerShell for automation. You'll also learn to maintain SQL Server databases, troubleshoot performance issues, and import and export data across production environments—including Microsoft Azure SQL.

This course prepares professionals to administer and maintain SQL Server infrastructure with a strong emphasis on security, availability, and automation.

Participants will learn to:

• Authenticate users and assign database roles
• Configure SQL Server auditing, agent security, and backup strategies
• Manage SQL Server using PowerShell and automation techniques
• Monitor SQL Server activity using Extended Events
• Troubleshoot performance issues and import/export data

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. The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases.

• 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.