Microsoft Certified: Azure Database Administrator Associate
Overview : This course provides students with the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings. Additionally, it will be of use to individuals who develop applications that deliver content from SQL-based relational databases.
Our Objectives
What we aim to achieve through this training
Plan and implement data platform resources
Implement a secure environment
Monitor, Configure and Optimise database resources and Automate Database Operations
Plan and configure a high availability and disaster recovery (HA/DR) environment
What You'll Learn?
Gain practical, job-ready skills to excel in this field
Azure Data Platform Planning and Migration
Learn to design and deploy Azure SQL solutions, configure scale and performance across SQL Database, Managed Instance and SQL Server VMs and implement effective migration strategies. Gain expertise in partitioning, sharding, compression, hybrid deployments and troubleshooting migrations to ensure resilient, optimised data platforms.
Securing Azure SQL Data Platforms
Learn to configure authentication and authorisation with Microsoft Entra ID, enforce least‑privilege access and secure data at rest and in transit using encryption, firewalls and private endpoints. Implement compliance controls with auditing, classification, masking, row‑level security and ledger features to protect sensitive information.
Azure SQL Resource Monitoring and Optimisation
Learn to monitor database activity and performance with baselines, metrics, Query Store and Intelligent Insights. Gain expertise in troubleshooting query issues, optimising indexes and execution plans and configuring database solutions with tuning, integrity checks and scaling to ensure high‑performance, resilient workloads.
Automating Azure SQL Tasks and Deployments
Learn to configure and manage SQL Server Agent jobs with schedules, alerts and troubleshooting, automate database deployments using ARM templates, Bicep, PowerShell and CLI and streamline operations with elastic jobs, database automation and monitoring for resilient, efficient task execution.
High Availability and Disaster Recovery for Azure SQL
Learn to plan and implement HA/DR strategies based on RPO/RTO requirements, configure backup and restore solutions and deploy advanced availability features such as geo‑replication, failover groups, Always On availability groups and log shipping. Gain expertise in monitoring and troubleshooting HA/DR environments to ensure business continuity and resilience.
Azure Database Security, Compliance and Governance
Learn to apply governance strategies, configure auditing, implement compliance controls and enforce security standards across Azure SQL environments to ensure regulatory alignment and secure operations.
Course Curriculum
Structured learning path to master Microsoft Certified: Azure Database Administrator Associate
Plan and implement data platform resources
Deploy data platform resources in Azure SQL. Explore options for deployment and migration. Calculate resource requirements and create templates.
- Prepare to maintain SQL Server-based databases on Azure
- Deploy IaaS solutions with Azure SQL
- Deploy PaaS solutions with Azure SQL
- Migrate SQL Server workloads to Azure SQL Database
- Migrate SQL Server workloads to Azure SQL Managed Instance
Implement a secure environment for a database service
Implement SQL Server-based options for authentication and authorisation and Azure options for securing Azure SQL databases. Explore encryption, firewalls and advanced threat protection.
- Configure database authentication and authorisation
- Protect data in-transit and at rest
- Implement compliance controls for sensitive data
Monitor and optimise operational resources in Azure SQL
Configure hardware and server resources for optimum performance after establishing a baseline. Identify sources of performance problems. Troubleshoot using Azure SQL Intelligent Insights.
- Describe performance monitoring
- Configure SQL Server resources for optimal performance
- Configure databases for optimal performance
Optimise query performance in Azure SQL
Analyse individual query performance and determine where improvements can be made. Explore performance-related Dynamic Management Objects. Investigate how indexes and database design affect queries.
- Explore query performance optimisation
- Explore performance-based database design
- Evaluate performance improvements
Automate database tasks for Azure SQL
Scripting repetitive tasks in Azure SQL for regular maintenance jobs and multi-instance administration. Automation of error and resource alerts. Configuration of notifications for failures.
- Automate database deployment
- Create and manage SQL Agent jobs
- Manage Azure PaaS tasks using automation
Plan and implement a high availability and disaster recovery environment
Data must be available when needed. Configure, test and manage a solution for high availability and disaster recovery using Azure tools and SQL Server tools.
- Describe high availability and disaster recovery strategies
- Explore IaaS and PaaS solutions for high availability and disaster recovery
- Backup and restore databases
Certification & Exam Details
| Exam Name | Microsoft Certified: Azure Database Administrator Associate |
| Exam Code | DP-300 |
| Exam Duration | 100 minutes |
| Number of Questions | 40-60 multiple-choice questions and case-study questions. |
| Passing Score | 700 or Greater is required to pass |
| Language of Exam | English |
Who Can Join?
Designed for anyone starting their learning journey
IT Professionals
Broaden expertise in cloud data platforms
Senior Functional and Technical Consultants
Apply advanced database strategies in enterprise projects
Database Administrators
Manage, secure and optimise Azure SQL environments
Developers and Technical Leads
Integrate and extend database solutions for applications
IT Decision Makers and System Engineers
Plan and oversee resilient, scalable data solutions
Aspiring Solution Architects
Build skills for designing enterprise‑grade Azure data architectures
Fresh IT Graduates
Gain entry‑level knowledge in database administration
Job Seekers
Enhance employability with Microsoft Azure database skills
Career Paths
Roles and opportunities following this course
Entry-Level / Foundation Roles
Database Administrator (DBA), Cloud Database Administrator, SQL Server Administrator
Mid-Level / Specialised Roles
Data Engineer, Cloud Solutions Specialist, Database Security Specialist
Advanced / Leadership Roles
Cloud Solutions Architect (Data Focus), Data Platform Consultant, IT Manager / Technical Lead
How To Get Certified?
Register at Edura Training and Development
Complete the recommended training modules
Pass the final assessment
Earn your Microsoft Certified Azure Database Administrator Associate Certification
