What you'll learn

The DP-300 exam expects database administrators to effectively monitor Azure SQL workloads and apply performance and configuration optimizations, yet these skills are often the most difficult to practice consistently in real-world environments. In this course, Azure Database Administrator Associate (DP-300): Monitor, Configure, and Optimize Database Resources, you’ll gain the ability to monitor workloads, diagnose performance issues, and configure Azure SQL resources for optimal performance. First, you’ll explore how to establish performance baselines and monitor database activity using Azure SQL monitoring tools. Next, you’ll discover how to analyze and optimize query performance using Query Store, DMVs, execution plans, and Intelligent Insights. Finally, you’ll learn how to configure databases and servers for optimal performance using maintenance tasks, automatic tuning, scaling options, and intelligent query processing. When you’re finished with this course, you’ll have the skills and knowledge of Azure SQL performance monitoring and optimization needed to confidently manage production workloads and succeed on the DP-300 certification exam.