Live Online
Individual
Price on request
- 32 hours of live, trainer-led sessions
- 11 hands-on labs
- Ace Skills course completion certificate
IntermediateDP-300: Azure Database Administrator
Run fast, secure and highly available SQL databases on Azure and prepare for the DP-300 Azure Database Administrator exam.
- 32 hours of live, hands-on sessions
- Azure SQL Database, Managed Instance and SQL Server on VMs
- Query Store and performance tuning labs
- High availability and disaster recovery built and tested
- Mapped to the five DP-300 skill areas
Aligned to Microsoft exam DP-300
- Duration
- 4 Days | 32 Hrs
- Next batch
- Batches on request
- Delivery
- Live Online · Onsite · Corporate
- Level
- Intermediate
- Exam
- DP-300
- Language
- English
Why learn DP-300 with Ace Skills
Your DBA skills, translated
Each topic starts from what you already do on SQL Server and shows what changes, what stays and what Azure now handles for you.
Real performance problems
You diagnose blocking, regressions and missing indexes on a busy workload using Query Store and DMVs.
Failover you have practised
Failover groups and availability groups are built and failed over in class, so DR plans are tested rather than assumed.
Security by layers
Entra authentication, private endpoints, TDE, Always Encrypted and auditing are applied to the same database step by step.
Course overview
Database administrators moving to Azure find that much of their expertise still applies, but the decisions change: which deployment option to use, how service tiers affect performance, how high availability is delivered and what is now automated by the platform. This four-day course helps experienced DBAs make those decisions with confidence.
Day one covers planning and deploying data platform resources — comparing Azure SQL Database, Managed Instance and SQL Server on Azure VMs, choosing service tiers and migrating databases. Day two secures the environment with Microsoft Entra authentication, firewall rules, private endpoints, encryption, auditing and data classification.
Day three focuses on performance: monitoring with Query Store, dynamic management views and database watcher, identifying blocking and inefficient queries, and tuning indexes and configuration. Automation is covered alongside, with SQL Agent, elastic jobs and automated maintenance. Day four is dedicated to high availability and disaster recovery — backups, geo-replication, failover groups and Always On availability groups — followed by exam preparation.
Labs use realistic workloads, so you diagnose genuine performance problems and fail over real databases rather than following click-by-click demonstrations.
The course is aligned to the DP-300 exam. Microsoft updates exam outlines periodically, so check the current skills measured on Microsoft Learn before booking.
Key features
- Labs across all three Azure SQL deployment options
- Database migration with Azure Database Migration Service
- Query Store, DMVs and index tuning exercises
- Security hardening with Entra authentication and encryption
- Failover groups and availability group labs
- Automation with elastic jobs and SQL Agent
- 30 days of post-training doubt support
Who should attend
- SQL Server database administrators
- Data platform engineers supporting Azure SQL
- Developers who manage production databases
- Infrastructure engineers responsible for database migrations
Prerequisites
- Experience administering SQL Server
- Working knowledge of T-SQL
- Basic Azure knowledge (AZ-900 or DP-900 level)
Curriculum
4 Days · 32 Hours · 12 Modules · 11 Labs
Azure SQL options
- Azure SQL Database, Managed Instance and SQL Server on VMs
- Purchasing models: DTU and vCore
- Service tiers, serverless and Hyperscale
- Elastic pools
- Lab: Deploy Azure SQL Database and Managed Instance options · 45 min
Deployment and configuration
- Deploying with templates and scripts
- SQL Server on Azure VMs: storage and IaaS agent
- Database configuration settings
- Azure Arc-enabled SQL Server overview
- Lab: Deploy and configure SQL Server on an Azure VM · 40 min
Migration
- Assessing readiness for migration
- Online vs offline migration
- Azure Database Migration Service
- Post-migration validation
- Lab: Migrate an on-premises database to Azure SQL · 55 min
Authentication and authorisation
- Microsoft Entra authentication
- Logins, users and contained users
- Database roles and least privilege
- Managed identities for applications
- Lab: Configure Entra-only authentication and roles · 45 min
Network security
- Server and database firewall rules
- Private endpoints
- Connection policies
- Lab: Restrict access with a private endpoint · 30 min
Data protection and compliance
- Transparent data encryption
- Always Encrypted
- Dynamic data masking and row-level security
- Auditing, ledger and data classification
- Microsoft Defender for SQL
- Lab: Apply Always Encrypted, masking and auditing · 55 min
Monitoring
- Database watcher and Azure Monitor
- Dynamic management views
- Extended events
- Baselining
- Lab: Set up monitoring and capture a baseline · 35 min
Query performance
- Query Store and plan regressions
- Blocking and deadlocks
- Index design and maintenance
- Intelligent query processing and automatic tuning
- Lab: Find and fix a regressed query with Query Store · 60 min
Automation
- SQL Agent jobs
- Elastic jobs
- Azure Automation and alerts
- Maintenance tasks
- Lab: Automate index maintenance with elastic jobs · 40 min
Backup and restore
- Automated backups and retention
- Point-in-time and long-term retention restore
- Backup to URL for SQL on VMs
- Lab: Perform a point-in-time restore · 30 min
High availability and DR
- Built-in availability and zone redundancy
- Active geo-replication
- Auto-failover groups
- Always On availability groups on Azure VMs
- Failover cluster instances
- Lab: Configure and test an auto-failover group · 50 min
Exam readiness
- Exam structure and case studies
- Practice questions with review
Skills you will gain
- Azure SQL Database
- Azure SQL Managed Instance
- SQL Server on Azure VMs
- Database migration
- Microsoft Entra authentication
- TDE & Always Encrypted
- Auditing
- Query Store
- Index tuning
- Elastic jobs
- Geo-replication
- Failover groups
- Always On availability groups
Tools & technologies
- Azure portal
- SQL Server Management Studio
- Azure Data Studio
- Azure Database Migration Service
- Azure CLI
- PowerShell
Certification exam
| Exam name | Microsoft Certified: Azure Database Administrator Associate |
|---|---|
| Exam code | DP-300 |
| Duration | 100 minutes |
| Passing score | 700 / 1000 (scaled) |
| Voucher included | No — book directly with the vendor |
| Question format | Multiple choice, Multiple response, Drag and drop, Case study |
| Delivery | Online proctored or Test centre |
| Validity & renewal | 1 year (free online renewal assessment) |
Skill areas measured
- Plan and implement data platform resources
- Implement a secure environment
- Monitor, configure, and optimize database resources
- Configure and manage automation of tasks
- Plan and configure a high availability and disaster recovery (HA/DR) environment
Exam details are pending verification. Vendors change exams; confirm on the official vendor page before booking. Official exam page (opens in a new tab)
Schedule & Pricing
Onsite
At your office or our centre
Pricing depends on location, group size and dates.
- Delivered at your premises or an Ace centre
- Same curriculum and labs as live online
- Dates planned around your team
Corporate / Team
Private batch for your organisation
A private batch with content adapted to your environment and goals.
- Customised curriculum
- Private batch, online or onsite
- Progress and assessment reports
- GST invoice and PO-based billing
No public batches scheduled — Talk to an Advisor for a private batch.
Projects & labs you will build
- Day 3 · 60 min
Find and fix a regressed query with Query Store
- Day 4 · 50 min
Configure and test an auto-failover group
Your certificate
Certificate of Completion — Ace Skills Consulting
Awarded on completing the course. It records the course title and training hours, and you can share it on your LinkedIn profile.
The Microsoft certification itself is awarded by Microsoft when you pass exam DP-300.
Frequently asked questions
Do I need SQL Server experience?
Yes. The course is designed for working DBAs and assumes you are comfortable with T-SQL and routine administration.
Does the course cover Managed Instance and SQL on VMs?
Yes. All three Azure SQL deployment options are covered, with labs on each.
How do I book the DP-300 exam?
You schedule it through Microsoft Learn, either online-proctored or at a test centre.
What happens if Microsoft updates the DP-300 exam?
We map the curriculum to the current published skills outline and revise it when Microsoft changes the exam. Always check the latest outline on Microsoft Learn before booking.
Do you run weekend batches?
Yes. Weekend batches cover the same 32 hours across consecutive Saturdays and Sundays, with timings in IST that also suit learners in the Gulf.
Can you run a private batch for our team?
Yes. We run private online or onsite batches for corporate teams, and we can weight the labs towards your database migration plans. Request a corporate quote with your team size and preferred dates.
Related courses
MicrosoftPopularPL-300: Power BI Data Analyst
- 3 Days | 24 Hrs
- Live Online · Onsite · Corporate
Price on request
View Course
MicrosoftSC-200: Security Operations Analyst
- 4 Days | 32 Hrs
- Live Online · Onsite · Corporate
Price on request
View Course
MicrosoftDP-600: Fabric Analytics Engineer
- 4 Days | 32 Hrs
- Live Online · Onsite · Corporate
Price on request
View Course
MicrosoftSC-300: Identity and Access Administrator
- 4 Days | 32 Hrs
- Live Online · Onsite · Corporate
Price on request
View Course
Explore more
Microsoft, Azure, Microsoft 365, Power BI and Microsoft Entra are trademarks of the Microsoft group of companies.
Train your team on DP-300
Private batches online or at your office in India and the GCC, with a curriculum adapted to your environment.