DP-300: Administering Microsoft Azure SQL Solutions
Prepare for the DP-300 certification exam. Learn to deploy, secure, monitor, automate, and protect Azure SQL solutions through AI-guided lessons and 15 hands-on labs in real Azure environments.
Exam Preparation Included
Practice with real exam-style questions for the DP-300 certification. AI-powered feedback helps you understand every answer.
About This Course
Master the skills needed to administer and manage SQL Server and Azure SQL databases as a Microsoft Azure Database Administrator. This comprehensive course prepares you for the DP-300 certification exam by covering all five exam domains through AI-guided teaching lessons and hands-on lab exercises.What You'll Learn: Plan and implement data platform resources deploy SQL Server on Azure VMs and provision Azure SQL Databases with proper networking. Implement a secure environment configure Microsoft Entra ID authentication, firewall rules, Microsoft Defender for SQL, and data classification. Monitor and optimize operational resources use monitoring tools to isolate performance problems, detect fragmentation, resolve blocking issues, and optimize queries. Configure and manage automation deploy databases using ARM templates, set up CPU alerts with Azure Monitor, and automate index maintenance with Azure Automation. Plan and implement high availability and disaster recovery configure geo-replication across regions and implement backup/restore to Azure Blob Storage.Prerequisites: Experience with SQL Server administration and T-SQL queries. Basic understanding of Azure cloud concepts and the Azure portal. Familiarity with database concepts (indexes, normalization, query plans).Course Format: This AI-led course alternates between teaching lessons (guided by an AI instructor) and hands-on lab exercises (real Azure environments). Each exam domain has a dedicated teaching lesson followed by practical labs that reinforce the concepts.
Course Curriculum
13 Lessons
Plan and Implement Data Platform Resources
Learn how to plan and deploy SQL Server on Azure Virtual Machines and Azure SQL Database. Understand deployment options, networking configurations, and when to choose IaaS vs PaaS for your database workloads.
Provisioning Azure SQL Resources
Hands-on exercises for provisioning SQL Server on an Azure VM and creating an Azure SQL Database with Virtual Network endpoints.
Implement a Secure Environment for Database Services
Learn how to secure Azure SQL databases using Microsoft Entra ID authentication, firewall rules, Microsoft Defender for SQL, and data classification to protect sensitive information.
Securing Azure SQL Solutions
Hands-on exercises for configuring Microsoft Entra ID access, database firewall rules, and enabling Microsoft Defender with data classification.
Monitor and Optimize Operational Resources
Learn how to monitor Azure SQL performance, identify and resolve fragmentation, blocking issues, and database design problems, and optimize query performance using execution plans and DMVs.
Performance Monitoring and Query Optimization
Hands-on exercises for monitoring performance, detecting fragmentation, resolving blocking issues, identifying database design problems, and optimizing poorly performing queries.
Configure and Manage Automation of Tasks
Learn how to automate Azure SQL database deployments with ARM templates, set up monitoring alerts, and create automation runbooks for routine maintenance tasks.
Automating Database Tasks
Hands-on exercises for deploying Azure SQL databases using ARM templates, creating CPU alerts with Azure Monitor, and building automation runbooks for index maintenance.
Plan and Implement High Availability and Disaster Recovery
Learn how to implement geo-replication for cross-region high availability, configure failover strategies, and use backup/restore to Azure Blob Storage for disaster recovery scenarios.
High Availability and Disaster Recovery
Hands-on exercises for configuring geo-replication across Azure regions with manual failover and implementing SQL Server backup/restore to Azure Blob Storage.
Diagnose Slow Queries with GitHub Copilot in SSMS
Use GitHub Copilot inside SSMS 22 to diagnose a slow-running stored procedure, understand what the execution plan is doing, and apply a Copilot-recommended index to restore performance. Uses the ContosoOps sample workload (Technicians, WorkOrders ~2M rows).
Design a Secure Semantic Search Application on Azure SQL Database
Design case study — you're the data architect for a retail company adding semantic search over 8M product descriptions. Make 5 architectural decisions around embedding model, service tier, authentication, vector-index type, and security posture. Then validate your design with 4 multiple-choice checks. No infrastructure is provisioned.
Convert an Oracle Schema to Azure Database for PostgreSQL
Migrate a live Oracle schema to Azure Database for PostgreSQL flexible server using the VS Code PostgreSQL extension's Migrations preview view, backed by a Microsoft Foundry chat model in agent mode. You provision the PostgreSQL target and Foundry model, then run the schema conversion end-to-end.