DP-300: Administering Microsoft Azure SQL Solutions
Course Overview
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
Ready to Get Started?
Join thousands of professionals who have advanced their careers with our training programs.
Join Scheduled Training
Find upcoming sessions for this course and register for instructor-led training with other professionals.
View ScheduleCustom Training Solution
Need training for your team? We'll create a customized program that fits your organization's specific needs.
Get Custom Quote