DP-300: Azure Database Administrator Associate
Your Background Advantage
With 14+ years of Oracle (RAC, Data Guard, ERP, SOA, BI, OAM, APEX) + AZ-104 + AZ-305, you already know database administration. DP-300 is about learning the Azure dialect of concepts you've mastered.
Start with the Oracle to Azure Mapping Guide to connect what you know to what you're learning.
Exam Domains
| Domain | Weight | Your Oracle Advantage |
|---|---|---|
| Plan and implement data platform resources | 20-25% | CDB/PDB -> MI, RAC -> Elastic Pools, ASM -> Managed Disks |
| Implement a secure environment | 15-20% | TDE -> TDE, VPD -> RLS, Oracle Audit -> Azure Auditing |
| Monitor, configure, and optimize | 20-25% | AWR -> Query Store, ASH -> DMVs, ADDM -> Intelligent Insights |
| Configure and manage automation | 15-20% | DBMS_SCHEDULER -> SQL Agent/Elastic Jobs, cron -> Functions |
| Plan and implement HADR | 20-25% | Data Guard -> Failover Groups, RMAN -> Automated Backups |
How to Use This Wiki
- Start with the DP-300 exam cram kit for a recall-first review plan for this week
- Use the Oracle to Azure mapping to ground everything in what you know
- Study each domain using the sidebar (concepts, architecture diagrams, tips)
- Review flashcards at the end of each topic for spaced repetition
- Take quizzes to test your knowledge and find gaps
- Do the labs - 16 hands-on labs in the dp-300-database-administrator repo
Study Resources
Official Microsoft
- Microsoft Learn: DP-300
- DP-300 Study Guide (Oct 2024)
- Azure SQL Documentation
- DP-300 Free Practice Assessment
Video Courses
- DP-300 Full Playlist - John Savill / Azure Academy - Comprehensive video walkthrough of all exam domains
- NTFAQGuy - Azure SQL Deep Dives - Technical deep-dives on Azure SQL, HA/DR, performance tuning
Microsoft Exam Readiness Zone (Official, 5-part series)
Short, exam-focused videos from Microsoft - one per DP-300 domain. Map directly to the wiki sections below.
Hands-On Labs
- 16 official Microsoft DP-300 labs (in this repo under
Instructions/Labs/) - 5 Advanced Labs built from real customer engagements: Advanced Labs
- AlwaysOn HA Setup - 7-step production guide with Bicep, scripts, and failover testing app
- SQL Security Assessment - 57-check audit tool (SQL DBSAT) across all platforms
- SQL Migration Lab - backup -> blob -> restore with validation
- Geo-Replication & Failover - cross-region DR with auto-failover groups
- Performance Troubleshooting - Query Store, DMVs, wait stats, plan forcing