DP-300: Administering Microsoft Azure SQL Solutions

Course Description

Elevate your database administration skills with DP300: Administering Microsoft Azure SQL Solutions. In this comprehensive 4-day, instructor-led training, you’ll master how to administer Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure VMs, alongside hybrid and on-prem architectures. You’ll learn to implement security, automate tasks, optimize performance, and design high availability and disaster recovery strategies—preparing you for the Azure Database Administrator Associate role.

Target Audience

This course is ideal for:

• Database Administrators, Azure Data Professionals, and SQL Server Engineers managing cloud and hybrid database environments

• Data architects and developers who need to understand Azure SQL administration whether it’s PaaS or IaaS

Prerequisites:

• Experience with SQL Server management and T-SQL

• Familiarity with Azure fundamentals and resource deployment

• Understanding of cloud database platforms and administration tasks 

Course Outline 

Module 1: Prepare to Maintain Azure SQL Databases

• Understand the role of the Azure database administrator and compare SQL Server–based deployment options on Azure 

Module 2: Plan and Implement Data Platform Resources

• Deploy SQL Server on Azure VMs, Azure SQL Database, elastic pools, SQL Managed Instance, and Azure SQL Edge

Module 3: Implement a Secure Environment

• Configure authentication/authorization, protect data in-transit and at rest, and apply encryption best practices (TDE, Always Encrypted, firewall) 

Module 4: Implement Compliance Controls for Sensitive Data

• Set up data classification, auditing, Dynamic Data Masking, row-level security, Microsoft Defender for SQL, and Azure Purview 

Module 5: Monitor and Optimize Operational Resources

• Use Azure Monitor, Intelligent Insights, extended events, and baseline metrics to optimize resource utilization

Module 6: Optimize Query Performance

• Analyze execution plans, utilize Query Store, Intelligent Query Processing, and implement index/stats maintenance strategies 

Module 7: Automate Tasks for Azure SQL

• Automate deployment with ARM/Bicep, PowerShell, and Azure CLI; manage jobs and alerts via SQL Agent, Elastic Jobs, Automation Runbooks 

Module 8: Plan and Implement High Availability and Disaster Recovery (HADR)

• Design HADR architecture using Always On, geo-replication, backups, and DR strategies in both IaaS and PaaS environments

HandsOn Experience

Approximately 40–50% of the course is dedicated to practical scenario-based exercises. You’ll deploy and administer Azure SQL architectures, secure data, optimize query performance, automate tasks, and build high availability and disaster recovery solutions—ensuring hands-on mastery of Azure SQL administration.

Skills You’ll Gain

By completing DP300, you will be able to:

• Deploy and manage Azure SQL Database, SQL Managed Instance, and SQL Server on Azure VMs

• Secure and comply with data governance using encryption, auditing, and Defender

• Optimize SQL performance and monitor workloads using native Azure tools

• Automate database deployment and administration through IaC and scripting

• Architect resilient, highly available, and DR-capable Azure SQL solutions