Pass the Microsoft Azure Database Administrator Certification in Just 5 Days
Live instructor-led training, official courseware, hands-on labs, exam vouchers, and a free retake — all in one package.
What's Included
Upcoming Sessions
MCA Microsoft Azure Database Administrator Certification (DP-900, DP-300) Boot Camp
Scroll to see additional dates.
Remote Live
Why Thousands Choose Career Camps
17+ Years of Training Experience
For more than 17 years, professionals and organizations have relied on our training expertise to build in-demand technology skills, prepare for industry certifications, and advance their teams.
5,000+ Professionals Trained
With 5,000+ professionals trained, we bring extensive experience supporting individuals, enterprise teams, government organizations, and military clients with technology skills and certification training.
Trusted by Professionals & Organizations
Trusted by thousands of IT professionals, businesses, government organizations, and enterprise teams for high-quality certification training and technology skills development.
Access to 10+ Training Providers
Get access to training from 10+ established certification training providers, giving you more options to find the right course, schedule, delivery format, and training solution for your certification goals.
Live Certified Instructors
Learn directly from experienced certified instructors—not prerecorded videos or self-paced material.
Official Training
Train with authorized, official courseware and curriculum from leading technology certification providers. Get the same industry-recognized training designed to prepare professionals for today’s most in-demand certifications and technology roles.
Course Description
- Description
- Prerequisites
- Our Facilities
- Why Choose Us
- Microsoft Gold Learning Partner
- What You'll Learn
Description
Prerequisites
Successful Azure Database Administrators start this role with professional experience in database management and technical knowledge of cloud technologies. Specifically:
Working with, maintaining, and developing with SQL Server
Experience with Azure, such as deploying and managing resources
At a minimum, you should know the information in the following courses before attending the course:
Introduction to Cloud Infrastructure (AZ-900)
Microsoft Azure Data Fundamentals Training (DP-900)
Our Facilities
CAREER CAMPS FACILITIES
CAMPUS – Career Camps built out a stand alone training center (not a hotel conference room) with spacious classrooms, new desk, Herman Miller Aeron chairs & comfortable common areas. Each student has a dedicated desk with two monitors. Each classroom has a maximum of two rows – so everyone is able to be engaged without the “back row” feeling.
CLASSROOM EQUIPMENT – Students work on a dedicated Dell Client Desktop with 32GB memory with 512GB SSD drives – All Labs are executed the extremely fast Microsoft Data Center Hosted Lab Environment.
CAMPUS INTERNET – The campus is connected with a 1Gbps (1,000 Mbps) Verizon Fios Business Connection which provides complete internet (including VPN) access for students.
COMMON AREA – Amenities including snacks, drinks (Coffee, 100% juices, sodas, etc) all complimentary.
LODGING – We use the Hyatt Place Lakewood Ranch. This “upgraded” hotel offers extremely comfortable beds, great breakfast and very fast internet access.
NEAR BY AMENITIES – Many shops, restaurants and grocery options are available within walking distance. Additionally – the hotel provided scheduled shuttle services. Restaurants like Bone Fish Grill, Ruby Tuesday’s, Five Guys, Chipotle, Quiznos, Chili’s and over 20 additional choices in the immediate area. All of these options are offered in a pedestrian walking village.
Why Choose Us
CAREER CAMPS DIFFERENCE
Career Camps provides an in-depth hands on learning environment. Our instructors teach using demonstrations and explain concepts beyond the scope of the courseware. The best instructors are contracted from all across the US. These professionals are real world consultants who actually implement these technologies. Career Camps knows our clients work in the “real world” and it only makes sense to have an instructor with the experience in the real world.
Facilities – Many of our competitors over-crowd classrooms by placing 2 to 3 students per desk and 20+ students per instructor. Often these companies “extend” the life of very old equipment with slow performance on the software used today. Our average class size is 8 students. Our facilities have the best equipment with the most comfortable, focused environment for learning.
Instructors – Our CEO holds one of the rarest Microsoft Certifications – the Microsoft Certified Learning Consultant (MCLC) Certification. This certification reflects a commitment to make sure our instructors are also actively engaged in real world consulting projects. Students expect a professional who can answer questions and demonstrate the technology.
Face to Face Training – We believe the best way to interact and learn is face to face training. Many of our competitors which offer local training are simply providing students with headphones/mic to attend class with an instructor at a remote location.
Test Pass – We offer a free retake voucher (if needed) for each of the exams required for certification. Any training center offering a “100% pass guarantee” would have to use unethical practices or unlimited test vouchers (which is not likely or practical).
Distractions – Students often look for a “local” training center so they can be close to home and work. Boot camp requires a tremendous time commitment during the program. Long class hours combined with self study each evening. The goal of boot camp is to achieve certification in a fraction of the time. We strongly recommend students attend camp away from home and work in a focused, distraction free environment.
Boot Camp – Boot camp is an accelerated training focused on teaching technology and testing students on the official exams. Most training providers “added” boot camps to the existing standard training classes they offer. These training centers think a boot camp is just a regular class where you send the student home with a voucher on the last day. Career Camps administers exams throughout the camp. Equally important – not every trainer can teach a boot camp and not all courseware is designed for boot camp format. Our trainers know the boot camp format and our courseware is designed for accelerated learning.
Florida – Career Camps has one of the most scenic locations boasting some of the best weather in US. We believe students should have a comfortable and inviting atmosphere while attending these otherwise intense programs. We place our location, facilities and amenities up against that any competitor.
Microsoft Gold Learning Partner
What You'll Learn
- Describe core data concepts in Azure
- Explain concepts of relational data in Azure
- Explain concepts of non-relational data in Azure
- Identify components of a modern data warehouse in Azure
- Plan, deploy and configure Azure SQL offerings
- Monitor database performance and tune a database and queries for optimum performance
- Plan and configure a High Availability Solution
Course Outline
The Role of the Azure Database Administrator
- 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
Plan and Implement Data Platform Resources
- 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
Implement a Secure Environment
- 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
Monitor and Optimize Operational Resources
- 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
Optimize Query Performance
- 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
Automation of Tasks
- 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
Plan and Implement a High Availability and Disaster Recovery Environment
- 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
Azure Data Foundations
- 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
Explore core data concepts
- Students will learn the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build their foundational knowledge of cloud data services within Microsoft Azure.
- Students will identify and describe core data concepts such as relational, non-relational, big data, and analytics, and explore how this technology is implemented with Azure. Students will explore the roles, tasks, and responsibilities in the world of data.
- Explore core data concepts
- Explore roles and responsibilities in the world of data
- Describe concepts of relational data
- Explore concepts of non-relational data
- Explore concepts of data analytics
- After completing this module, students will be able to:
- Show foundational knowledge of cloud data services within Azure
- Identify and describe core data concepts such as relational, non-relational, big data, and analytics
- Explain how this technology is implemented with Azure
Explore relational data in Azure
- Students will learn the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build their foundational knowledge of cloud data services within Microsoft Azure.
- Students will explore relational data offerings, provisioning and deploying relational databases, and querying relational data through cloud data solutions with Azure.
- Explore relational data services in Azure
- Explore provisioning and deploying relational database services in Azure
- Query relational data in Azure
- After completing this module, students will be able to:
- Describe relational data services on Azure
- Explain provisioning and deploying relational databases on Azure
- Query relational data through cloud data solutions in Azure
Explore non-relational data in Azure
- Students will learn the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build their foundational knowledge of cloud data services within Azure. Students will explore non-relational data services, provisioning and deploying non-relational databases, and non-relational data stores with Microsoft Azure.
- Explore non-relational data services in Azure
- Explore provisioning and deploying non-relational data services on Azure
- Manage non-relational data stores in Azure
- After completing this module, students will be able to:
- Describe non-relational data services on Azure
- Explain provisioning and deploying non-relational databases on Azure
- Describe non-relational data stores on Azure
Explore modern data warehouse analytics in Azure
- Students will learn the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build their foundational knowledge of cloud data services within Azure. Students will explore the processing options available for building data analytics solutions in Azure. Students will explore Azure Synapse Analytics, Azure Databricks, and Azure HDInsight. Students will learn what Power BI is, including its building blocks and how they work together.
- Examine components of a modern data warehouse
- Explore data ingestion in Azure
- Explore data storage and processing in Azure
- Get started building with Power BI
- After completing this module, students will be able to:
- Describe processing options available for building data analytics solutions in Azure
- Describe Azure Synapse Analytics, Azure Databricks, and Azure HDInsight
- Explain what Microsoft Power BI is, including its building blocks and how they work together
Frequently Asked Questions
What is the Microsoft Azure Database Administrator Boot Camp?
The MCA Microsoft Azure Database Administrator Certification (DP-900, DP-300) Boot Camp is an intensive 5-day, instructor-led training program that combines Azure Data Fundamentals (DP-900) and Administering Microsoft Azure SQL Solutions (DP-300). The course takes students from foundational data concepts to practical Azure database administration skills.
What certifications does this boot camp prepare me for?
The program prepares students for the DP-900: Microsoft Azure Data Fundamentals and DP-300: Administering Microsoft Azure SQL Solutions exams. The DP-300 certification is particularly relevant for professionals pursuing the Microsoft Certified: Azure Database Administrator Associate credential.
Who should attend Azure Database Administrator training?
This boot camp is ideal for Azure Database Administrators, SQL Database Administrators, database professionals, SQL Server administrators, cloud engineers, systems administrators, IT professionals, and data professionals who want to build or expand their Azure database administration skills.
Do I need previous database experience?
Previous database experience is helpful but not necessarily required for the DP-900 fundamentals portion. For the accelerated DP-300 training, students will benefit from having experience with SQL Server, relational databases, database administration, or general IT infrastructure.
Does the Azure Database Administrator Boot Camp include hands-on training?
Yes. The boot camp is designed as live, instructor-led training with practical exercises and real-world database administration scenarios. Students can gain experience working with Azure database services, security, monitoring, performance, backup, and troubleshooting.
Do I need programming experience for DP-900 or DP-300?
No. Programming experience is not required. However, familiarity with SQL, relational databases, database concepts, or database administration is highly beneficial, particularly for the DP-300 portion of the course.
Related products
-
MCA Microsoft Power BI Data Analyst Certification (PL-900, PL-300) Boot Camp
$3,995.00 Course Details This product has multiple variants. The options may be chosen on the product page -
MCA Microsoft Fabric Analytics Engineer Certification (DP-900, DP-600) Boot Camp
$3,495.00 Course Details This product has multiple variants. The options may be chosen on the product page -
MCA Azure AI App & Agent Developer Associate Certification (AI-901, AI-103) Boot Camp
$3,995.00 Course Details This product has multiple variants. The options may be chosen on the product page
Ready to Take the Next Step?
Choose your upcoming training date or talk with our training advisors about the right option for you or your team.