We provide course about MS-55316: Administering a SQL Database in english. This instructor-led course equips participants with the knowledge and skills needed to administer SQL Server and Azure SQL database infrastructure.
Course description:
The training is especially useful for professionals who manage, maintain, or support SQL Server databases in enterprise environments. During this course, you will gain a deep operational understanding of how SQL Server works, how to secure and manage users and permissions, and how to protect and recover data.
Through hands-on exercises and real-world scenarios, you will also learn how to automate database administration tasks, monitor database systems, and troubleshoot common issues. This course combines theoretical concepts with practical tools you will use daily as a SQL Server database administrator.
Key takeaways:
After completing the course, participants will be able to:
• Authenticate and authorize users and database roles
• Secure SQL Server using encryption, auditing, and agent security
• Manage backups, restores, and recovery strategies
• Automate database administration tasks
• Monitor SQL Server performance, alerts, and notifications
• Use PowerShell for managing SQL Server
• Trace access and import/export data effectively
• Troubleshoot SQL Server infrastructure issues
Course outline:
Module 1 - SQL Server security:
• You start by learning how SQL Server handles authentication and authorization. This section explains how logins, users, and roles work together, and how to secure access to databases in enterprise environments.
Module 2 - Server and database roles:
• This topic focuses on managing server-level and database-level roles. You learn how to assign permissions correctly, follow the principle of least privilege, and avoid common security misconfigurations.
Module 3 - Encryption and auditing:
• You gain an understanding of how to protect sensitive data using encryption technologies and how auditing can be used to track access, changes, and compliance-related events in SQL Server.
Module 4 - Backup and recovery strategies:
• This section explains SQL Server recovery models and backup types in detail. You learn how to plan, implement, and test backup and restore strategies to ensure data availability and business continuity.
Module 5 - Automating SQL Server tasks:
• You learn how to automate recurring administrative tasks using SQL Server Agent. This includes creating jobs, schedules, alerts, and notifications to support stable and predictable database operations.
Module 6 - Monitoring and alerts:
• This topic focuses on monitoring SQL Server health and performance. You learn how to configure alerts, respond to performance issues, and proactively identify problems before they impact users.
Module 7 - PowerShell for SQL Server administration:
• You are introduced to using PowerShell to manage SQL Server environments. This section covers how scripting can simplify administration, improve consistency, and support automation at scale.
Module 8 - Extended events and tracing:
• You learn how to capture and analyze activity using Extended Events. This includes tracing performance issues, troubleshooting complex problems, and understanding workload behavior.
Module 9 - Performance monitoring and tuning:
• This section explains how to analyze performance metrics, identify bottlenecks, and apply tuning techniques to improve database performance and stability.
Module 10 - Troubleshooting SQL Server:
• You learn a structured approach to troubleshooting common SQL Server issues, including connectivity problems, performance degradation, and configuration errors.
Module 11 - Importing and exporting data:
• The course concludes with techniques for importing and exporting data between systems. You learn how to use built-in SQL Server tools to move data efficiently and safely.
Target audience:
This course is relevant for:
• Database Administrators
• Database Support Engineers
• Systems Engineers working with SQL Server
• IT professionals working with database infrastructure
• Developers who need to manage or support SQL Server Databases
Prerequisites:
Recommended but not mandatory:
• Basic knowledge of Microsoft Windows operating system fundamentals
• Working knowledge of Transact-SQL (e.g., equivalent to DP-080)
• Understanding of relational database concepts and design is beneficial
Language:
• English course material and english speaking instructor
Course material:
The course fee includes course documentation, exercises, and tutoring as specified