Intermediate Level

Microsoft Certified Azure Database Administrator Associate (DP-300)

★ 4.8 (300 learners) 60 hrs total 17 modules

Microsoft Azure Entra ID

Only 5 seats left · Next batch starts 22 Aug 2026

Download Curriculum

60 hrs: of content
17 modules: in curriculum
16 projects: hands-on builds
Intermediate: difficulty

Curriculum covers

Frameworks you'll master

2 tools & frameworks

Microsoft Azure Entra ID

Course Curriculum

17 modules · 60 hours · 24 live sessions

Optimize Query Performance 1 sessions

Determine the appropriate type of execution plan
Different types of loops used in execution plans, and Scan and Seek
Identify problem areas in execution plans
Optimize Query Performance

Evaluate Performance Improvements 1 sessions

Identify and implement index changes for queries
DMVs which gather query performance information
Determine the appropriate DMVs to gather performance information]
Recommend query construct modifications based on resource usage
Assess the use of hints for query performance

Plan and Implement Data Platform Resources 6 sessions

Deploy database offerings on selected platforms
Configure customized deployment templates
Evaluate requirements and functional benefits/impact for the deployment
Evaluate scalability and security aspects
HA/DR of the possible database offerings
Automate deployment by using Azure Resource Manager (ARM) templates
Automate deployment by using Bicep Install Visual Studio Code
Automate deployment by using Bicep Creating/deploying Bicep code
Automate deployment by using PowerShell
Automate deployment by using Azure CLI
Configure Azure SQL Database resources for scale and performance
Configure Azure SQL Database for scale and performance
vCorebased purchasing model
DTUbased purchasing model, Server vs Serverless
Serverless/provisioned and elastic pools
Other Azure SQL Database configuration settings
Calculate resource requirements, including Elastic pool requirements
Database sharding and table partitioning
Evaluate the use of compression for tables and indexes
Set up SQL Data Sync
Evaluate a strategy for migrating to Azure
Evaluate requirements and strategies for the migration
Azure Migrate
SQL Server Migration Assistant (SSMA)
Data Migration Assistant (DMA)
Azure Database Migration Service (DMS)
Implement a migration between Azure SQL services export data
Implement a migration between Azure SQL services Other methods
Perform post migration validations
Configure database AuthN and AuthZ by using platform and database tools
What is Microsoft Entra ID?
configure Microsoft Entra ID authentication
create users from Microsoft Entra ID identities
configure security principals – roles
configure security principals GRANT/REVOKE/DENY
configure security principals individual permissions
configure security principals the ALL permission
configure permissions by using custom roles
apply principle of least privilege for all securables

Implement security for data at rest and in transit 1 sessions

implement Transparent Data Encryption (TDE)
implement objectlevel encryption and Always Encrypted
Encrypted versus Transparent Data Encryption
Implement Always Encrypted with VBS enclaves
implement Dynamic Data Masking
configure server and databaselevel firewall rules
Configure Transport Layer Security (TLS)

Implement Compliance Controls for sensitive data – Part 1 1 sessions

apply a data classification strategy
configure server and database audits
implement data change tracking Change Tracking
implement data change tracking Change Data Capture
perform a vulnerability assessment

Implement Compliance Controls for sensitive data – Part 2 1 sessions

Adding a secret in Azure Key Vault
Manage database resources by using Azure Purview theory + credentials
Manage data resources by using Azure Purview sources and scans
Implement Azure SQL Database ledger – Theory
Implement Azure SQL Database ledger Creating Updateable ledger table
Implement Azure SQL Database ledger Appendonly table and verifying
Implement rowlevel security
Configure Advanced Threat Protection / Microsoft Defender for SQL

Monitor Activity and Performance 4 sessions

prepare an operational performance baseline Metrics Explorer
prepare an operational performance baseline Other ways
create event notifications for Azure resources
determine sources for performance metrics
interpret performance metrics
Monitor by using Intelligent Insights
configure and monitor activity and performance
SQL Insights
Monitor by using SQL insights Theory and deploying components
Monitor by using SQL insights – Implementation
Creating a database watcher
Monitoring using a database watcher
Implement performancerelated maintenance tasks
implement index maintenance tasks
implement statistics maintenance tasks
configure database autotuning and automate performance tuning
manage storage capacity
assess growth/fragmentation and report on database free space
Implement performancerelated issues
Query Store an introduction
configure Query Store, extract query plans
identify sessions that cause blocking
Isolation Levels
assess performancerelated database configuration parameters
configure Intelligent Query Processing (IQP)

Automate tasks and perform backup and restore a database by using database tools 1 sessions

What is Elastic Job Agent?
automate database maintenance tasks
Full, differential and transaction log backups
perform a database restore to a point in time test DR
configure longterm backup retention

Recommend an HADR strategy for a data platform solution 1 sessions

recommend HADR strategy based on RPO/RTO requirements
evaluate Azurespecific HADR solutions
configure replication Active Georeplication
configure autofailover groups and test HA by using failover

Perform Administration by using TSQL 1 sessions

evaluate database health using DMVs overall resource usage
evaluate database health using DMVs other topics
evaluate server health using DMVs
perform database consistency checks by using DBCC
review database configuration options

Introduction to Virtual Machines and Managed Instance (MI) 1 sessions

Evaluating MIs and VMs based on specific requirements
configure Azure SQL Managed Instance for scale and performance
More about Azure SQL Managed Instance
Accessing Azure SQL Managed Instance in SSMS
Implement Azure SQL Managed Instance database copy and move
configure SQL Server in Azure VMs Part 1
configure SQL Server in Azure VMs Part 2
Logging into SQL Server on Azure Virtual Machines

Configure database authentication and filegroups 1 sessions

create users from Azure AD identities (MIs and VMs)
manage certificates using TSQL
configure database and objectlevel permissions using GUI
configure security principals (MIs and VMs)
recommend table, index storage inc. filegroups (MI and VMs)

Evaluate and implement an alert and notification strategy 1 sessions

create event notifications based on metrics
configure notifications for task success/failure/noncompletion
manage schedules and automate maintenance jobs
create alerts for server configuration changes
split and filter event notifications for Azure resources

Identify performancerelated tasks 1 sessions

determine sources for performance metrics
implement index maintenance tasks (Database Engine Tuning Advisor)
Monitor activity: SQL Profile, Extended Events, Performance Dashboard
configure Resource Governor for performance (VM/MI)

Create scheduled tasks 1 sessions

apply patches and updates for hybrid and IaaS deployment
implement Azure Key Vault and disk encryption for Azure VMs
configure multiserver automation
implement policies by using automated evaluation modes

Perform backup and restore a database by using database tools – VM’s 1 sessions

automate backups
perform a database backup with options
database (and transaction log) backups with options
perform a database restore with options
perform restore of user databases in TSQL
backup and restore to and from cloud storage

Recommend and test HA/DR strategies, and configure HA/DR 1 sessions

configure replication Transactional replication
evaluate HADR for hybrid and Azurespecific deployments
Creating Virtual Machines for Failover Cluster and Always on Availability Group
Connecting Virtual Machines to a Domain
Configure failover cluster instances on Azure VMs
Checking SQL Server Installation and preparing for AO
configure quorum options for a Windows Server Failover Cluster
create an Availability Group
Failover, integrate database into Always on Availability Group
configure an Always on Availability Group listener
Log shipping theory and creating folders
Configure log shipping
Testing log shipping and troubleshooting

Download Full Curriculum

Batch Schedule

⚡ Seats filling fast — only 5 remaining across all batches

Available Batches
Batch Type	Schedule	Duration	Next Start Date	Availability
Weekend	Sat & Sun, 10am–1pm	10 weeks	22 Aug 2026	Available
Weekday	Mon–Fri, 7–9pm	8 weeks	24 Aug 2026	Available
Fast-track	Mon–Sun, 6 hours/day	2 weeks	31 Aug 2026	Only 5 seats left

Ready to Get Started?