Azure Database Administrator Bootcamp (DP-300, DP-900)
This 5 day Azure Database Administrator bootcamp takes you from data fundamentals to production database administration. You will learn the Azure Data Fundamentals (DP-900) and Administering Microsoft Azure SQL Solutions (DP-300) content in a structured, instructor-led live camp, covering the real-world work of an Azure Database Administrator across cloud, on-premises, and hybrid SQL environments. Both exams are administered while you attend.
Training Overview
MCA Microsoft Azure Database Administrator Training & Certification Boot Camp – 5 Days (2 Courses, 2 Exams, 2 Certs)
Everything You Need To Succeed
Training Schedule and Cost
Course Description
Azure Database Administrator (DP-300) Bootcamp Overview
This Azure Database Administrator bootcamp is an accelerated, instructor-led path to becoming a Microsoft Certified: Azure Database Administrator Associate. Over five hands-on days you will learn to deploy, secure, monitor, and optimize Azure SQL and SQL Server databases across cloud, on-premises, and hybrid environments. You will sit the DP-300 exam on site before you leave, and this combo camp also includes the DP-900 Azure Data Fundamentals certification.
Who This DP-300 Course Is For
This Azure Database Administrator training is built for database administrators and data professionals who manage Azure SQL and SQL Server databases. Whether you want to validate your skills with the Azure SQL certification or you are preparing to earn the Azure Database Administrator Associate credential, this bootcamp is for you.
What You'll Learn in This DP-300 Training
The DP-300 course follows the same skill areas Microsoft measures on the exam, so every topic maps to real database administration work:
- Plan and implement data platform resources: deploy and configure Azure SQL Database, Managed Instance, and SQL Server on Azure VMs.
- Implement a secure environment: authentication, authorization, and data protection for your databases.
- Monitor, configure, and optimize database resources: performance monitoring and query tuning for optimum performance.
- Configure and manage automation of tasks: automate routine administration with T-SQL and platform tools.
- Plan and configure high availability and disaster recovery: backup, recovery, and HA/DR for Azure SQL and SQL Server.
The included DP-900 Azure Data Fundamentals track covers core data concepts, relational and non-relational data on Azure, and analytics workloads, giving you a solid foundation before the administrator material.
DP-300 Prerequisites
You should come in comfortable working with relational databases and SQL. You do not need prior Azure experience: because this combo starts with the DP-900 fundamentals, the Azure SQL and administration skills are taught from the ground up with hands-on labs throughout the week.
Why Choose This Azure Database Administrator Certification Camp
Skip months of self-study and get certified fast. This all-inclusive Azure Database Administrator certification camp is led by Microsoft Certified Trainers using official Microsoft courseware, with real hands-on labs every day, and your exams are administered on site while you attend.
- 5-day combo format: earn two Microsoft certifications (DP-300 and DP-900) in a single week.
- 95% first-attempt pass rate, with a free retake voucher per exam if you do not pass.
- Two Microsoft exam vouchers and two official Microsoft courses included.
- Hands-on labs, practice exams, and 90 days of extended lab access after the camp.
- Taught by Microsoft Certified Trainers, live online or in person in Sarasota, Florida.
Topics Covered
This module explores the role of a database administrator in the world of Azure. It also provides some foundational information relevant to the overall content. This includes a review of the various SQL Server-based options (SQL Server in a VM, Managed Instances, and Azure SQL Database.) Students will learn why compatibility level is a crucial concept when working with SQL databases in Azure. Students are also introduced to other database platforms available on Azure in addition to those based on SQL Server, in particular PostgreSQL and MySQLLessons
- Azure Data Platform Roles
- Azure Database Platforms and Options
- SQL Server Compatibility Levels
- Azure Preview Features
Lab : Using the Azure Portal and SQL Server Management Studio
- Provision a SQL Server on an Azure Virtual Machine
- Connect to SQL Server and Restore a Backup
After completing this module, students will:
- Understand the role of Azure Database Administrator as it fits in with other data platform roles
- Be able to describe the key differences between the SQL Server-based database op
- Be able to describe the difference between versions and compatibility levels
- Know how to enable and disable preview features
Lessons
- Deploying SQL Server using IaaS
- Deploying SQL Server using PaaS
- Deploying Open Source Database Solutions on Azure
Lab : Deploying Azure SQL Database
- Deploy a VM using an ARM template
- Configure resources needed prior to creating a database
- Deploy an Azure SQL Database
- Register the Azure SQL Database instance in Azure Data Studio and validate connectivity
- Deploy PostgreSQL or MySQL using a client tool to validate connectivity
Lessons
- Configure Database Authentication
- Configure Database Authorization
- Implement Security for Data at Rest
- Implement Security for Data in Transit
- Implement Compliance Controls for Sensitive Data
Lab : Implement a Secure Environment
- Configure a server-based firewall rule using the Azure Portal
- Authorize Access to Azure SQL Database with Azure Active Directory
- Enable Advanced Data Security and Data Classification
- Manage access to database objects
Lessons
- Baselines and Performance Monitoring
- Major Causes of Performance Issues
- Configuring Resources for Optimal Performance
- User Database Configuration
- Performance-related Maintenance Tasks
Lab : Monitor and Optimize Resources
- Isolate CPU Problems
- Use Query Store observe blocking problems
- Detect and correct fragmentation issues
Lessons
- Understanding SQL Server Query Plans
- Explore Performance-based Database Design
- Evaluate Performance Improvements
Lab : Query Performance Troubleshooting
- Identify issues with database design AdventureWorks2017
- Isolate problem areas in poorly performing queries in AdventureWorks2017
- Use Query Store to detect and handle regression in AdventureWorks2017
- Use query hints to impact performance in AdventureWorks2017
Lessons
- Setting up Automatic Deployment
- Defining Scheduled Tasks
- Configuring Extended Events
- Managing Azure PaaS resources Using Automated Methods
Lab : Automating Tasks
- Deploy an Azure template from a Quickstart template on GitHub
- Configure notifications based on performance metrics
- Deploy an Azure Automation Runbook (or elastic job) to rebuild indexes on an Azure SQL Database
Lessons
- High Availability and Disaster Recovery Strategies
- IaaS Platform and Database Tools for HADR
- PaaS Platform and Database Tools for HADR
- Database Backup and Recovery
Lab : Plan and Implement a High Availability and Disaster Recovery Environment
- Create an Always On Availability Group
- Enable Geo-Replication for Azure SQL Database
- Backup to URL and Restore from URL
Describe core data concepts
Describe how to work with relational data on Azure
Describe how to work with non-relational data on Azure
Describe an analytics workload on Azure
Microsoft Solutions Partner
As an authorized Microsoft Solutions Partner, we deliver Microsoft Official Courseware (MOC) taught by Microsoft Certified Trainers (MCTs). Our curriculum, labs and exam delivery meet Microsoft's highest standards for accredited training.
See What You'll Learn
Watch a short overview of the DP-900 & DP-300 course — what's covered, who it's for, and what you'll walk away certified to do. Or download the full syllabus as a PDF.
The Certification Camps Difference
How Does the Certification Camps Boot Camps Work?
Start your learning immediately with access to content as soon as your registration is processed.
Step 01
Before the Boot Camp
Start learning now. Once your registration is processed, you'll receive access to materials. Prepare for your live boot camp and identify knowledge gaps to maximize your experience.
Step 02
During the Boot Camp
Attend instructor-led live training at our facility in Florida or online — same class, same instructor, same interaction. Engage in presentations, labs and demos, then take the certification exam(s) while attending.
Step 03
After the Boot Camp
Continue to access your student lab environment for 90 days after your camp is over. Need to defer your exams or re-sit the training? You have up to 6 months after the camp is complete.
Trusted by 15,000+ IT Professionals
★★★★★ 4.9 · Based on 2,300+ verified reviews
Common Questions
Related Microsoft Azure Data Bootcamps
Build a complete career path. Many students combine certifications for deeper expertise. Ask us about combo pricing.
Seats are filling fast.
Lock in your spot today.
Join 15,000+ professionals and register for the DP-900 & DP-300 boot camp today.