Azure Database Administrator Associate (DP-300)
Master Azure SQL administration including deployment security performance tuning and high availability. Learn to manage Azure SQL Database Managed Instance and SQL Server on VMs.
No DP-300 practice exam yet
Your points already work on 4 E2E Test Vendor and Microsoft exams.
See the examsCourse Content
5 modules · 75 lessons
Module 1: Plan and Implement Data Platform Resources
Plan and deploy Azure SQL solutions and configure resources.
Deploy Azure SQL Solutions
Plan and deploy Azure SQL database offerings.
- Lesson Introduction to Azure SQL Services 12 min
- Quiz Introduction to Azure SQL Services Quiz 5 questions
- Lesson Azure SQL Database Deployment 12 min
- Quiz Azure SQL Database Deployment Quiz 5 questions
- Lesson Azure SQL Managed Instance 12 min
- Quiz Azure SQL Managed Instance Quiz 5 questions
- Lesson SQL Server on Azure VMs 12 min
- Quiz SQL Server on Azure VMs Quiz 5 questions
- Lesson Elastic Pools Configuration 12 min
- Quiz Elastic Pools Configuration Quiz 5 questions
- Lesson Serverless SQL Database 12 min
- Quiz Serverless SQL Database Quiz 5 questions
Configure Resources for Scale
Configure Azure SQL resources for scale and performance.
- Lesson Azure SQL Database Scaling 12 min
- Quiz Azure SQL Database Scaling Quiz 5 questions
- Lesson DTU vs vCore Models 12 min
- Quiz DTU vs vCore Models Quiz 5 questions
- Lesson Read Scale-Out Configuration 12 min
- Quiz Read Scale-Out Configuration Quiz 5 questions
- Lesson Hyperscale Architecture 12 min
- Quiz Hyperscale Architecture Quiz 5 questions
Migration Strategies
Plan and implement database migration strategies.
- Lesson Database Migration Assessment 12 min
- Quiz Database Migration Assessment Quiz 5 questions
- Lesson Azure Database Migration Service 12 min
- Quiz Azure Database Migration Service Quiz 5 questions
- Lesson Online vs Offline Migration 12 min
- Quiz Online vs Offline Migration Quiz 5 questions
- Lesson Data Migration Assistant 12 min
- Quiz Data Migration Assistant Quiz 5 questions
Module 2: Configure High Availability and Disaster Recovery
Configure high availability and disaster recovery.
High Availability
Implement high availability solutions.
- Lesson Availability Zones 12 min
- Quiz Availability Zones Quiz 5 questions
- Lesson Failover Groups 12 min
- Quiz Failover Groups Quiz 5 questions
- Lesson Auto-Failover Configuration 12 min
- Quiz Auto-Failover Configuration Quiz 5 questions
- Lesson Always On Availability Groups 12 min
- Quiz Always On Availability Groups Quiz 5 questions
Disaster Recovery
Implement disaster recovery solutions.
Backup and Restore
Implement backup and restore strategies.
- Lesson Automated Backups 12 min
- Quiz Automated Backups Quiz 5 questions
- Lesson Point-in-Time Restore 12 min
- Quiz Point-in-Time Restore Quiz 5 questions
- Lesson Copy-Only Backups 12 min
- Quiz Copy-Only Backups Quiz 5 questions
- Lesson Restore Deleted Databases 12 min
- Quiz Restore Deleted Databases Quiz 5 questions
Module 3: Automate Database Tasks
Automate Azure SQL database tasks.
Task Automation
Configure task automation for Azure SQL.
Alerting and Notifications
Configure alerting for Azure SQL.
- Lesson Azure Monitor Alerts 12 min
- Quiz Azure Monitor Alerts Quiz 5 questions
- Lesson Action Groups Configuration 12 min
- Quiz Action Groups Configuration Quiz 5 questions
- Lesson Database Watcher Alerts 12 min
- Quiz Database Watcher Alerts Quiz 5 questions
- Lesson Log Analytics Integration 12 min
- Quiz Log Analytics Integration Quiz 5 questions
Infrastructure as Code
Deploy Azure SQL using IaC.
- Lesson ARM Templates for SQL 12 min
- Quiz ARM Templates for SQL Quiz 5 questions
- Lesson Bicep for Azure SQL 12 min
- Quiz Bicep for Azure SQL Quiz 5 questions
- Lesson PowerShell Automation 12 min
- Quiz PowerShell Automation Quiz 5 questions
- Lesson Azure CLI for SQL 12 min
- Quiz Azure CLI for SQL Quiz 5 questions
Module 4: Implement a Secure Environment
Implement security for Azure SQL databases.
Database Authentication
Configure authentication for Azure SQL.
- Lesson Azure AD Authentication 12 min
- Quiz Azure AD Authentication Quiz 5 questions
- Lesson SQL Authentication 12 min
- Quiz SQL Authentication Quiz 5 questions
- Lesson Managed Identities 12 min
- Quiz Managed Identities Quiz 5 questions
- Lesson Contained Database Users 12 min
- Quiz Contained Database Users Quiz 5 questions
Database Authorization
Configure authorization and permissions.
- Lesson Database Roles and Permissions 12 min
- Quiz Database Roles and Permissions Quiz 5 questions
- Lesson Row-Level Security 12 min
- Quiz Row-Level Security Quiz 5 questions
- Lesson Dynamic Data Masking 12 min
- Quiz Dynamic Data Masking Quiz 5 questions
- Lesson Column-Level Security 12 min
- Quiz Column-Level Security Quiz 5 questions
Data Encryption
Implement data encryption solutions.
- Lesson Transparent Data Encryption 12 min
- Quiz Transparent Data Encryption Quiz 5 questions
- Lesson Always Encrypted 12 min
- Quiz Always Encrypted Quiz 5 questions
- Lesson Customer-Managed Keys 12 min
- Quiz Customer-Managed Keys Quiz 5 questions
- Lesson Transport Layer Security 12 min
- Quiz Transport Layer Security Quiz 5 questions
Network Security
Configure network security for Azure SQL.
- Lesson Firewall Rules Configuration 12 min
- Quiz Firewall Rules Configuration Quiz 5 questions
- Lesson Private Endpoints 12 min
- Quiz Private Endpoints Quiz 5 questions
- Lesson Virtual Network Integration 12 min
- Quiz Virtual Network Integration Quiz 5 questions
- Lesson Service Endpoints 12 min
- Quiz Service Endpoints Quiz 5 questions
Auditing and Compliance
Configure auditing and compliance features.
- Lesson Azure SQL Auditing 12 min
- Quiz Azure SQL Auditing Quiz 5 questions
- Lesson Microsoft Defender for SQL 12 min
- Quiz Microsoft Defender for SQL Quiz 5 questions
- Lesson Vulnerability Assessment 12 min
- Quiz Vulnerability Assessment Quiz 5 questions
- Lesson Data Classification 12 min
- Quiz Data Classification Quiz 5 questions
- Lesson Ledger Tables Configuration 12 min
- Quiz Ledger Tables Configuration Quiz 5 questions
Module 5: Monitor and Optimize Resources
Monitor and optimize Azure SQL resources.
Performance Monitoring
Monitor Azure SQL performance.
- Lesson Azure SQL Analytics 12 min
- Quiz Azure SQL Analytics Quiz 5 questions
- Lesson Query Performance Insight 12 min
- Quiz Query Performance Insight Quiz 5 questions
- Lesson Extended Events 12 min
- Quiz Extended Events Quiz 5 questions
- Lesson Dynamic Management Views 12 min
- Quiz Dynamic Management Views Quiz 5 questions
Query Optimization
Optimize SQL queries for performance.
- Lesson Query Store Analysis 12 min
- Quiz Query Store Analysis Quiz 5 questions
- Lesson Execution Plan Analysis 12 min
- Quiz Execution Plan Analysis Quiz 5 questions
- Lesson Index Tuning 12 min
- Quiz Index Tuning Quiz 5 questions
- Lesson Statistics Management 12 min
- Quiz Statistics Management Quiz 5 questions
Automatic Tuning
Configure automatic tuning features.
- Lesson Automatic Index Management 12 min
- Quiz Automatic Index Management Quiz 5 questions
- Lesson Automatic Plan Correction 12 min
- Quiz Automatic Plan Correction Quiz 5 questions
- Lesson Intelligent Query Processing 12 min
- Quiz Intelligent Query Processing Quiz 5 questions
- Lesson Performance Recommendations 12 min
- Quiz Performance Recommendations Quiz 5 questions
Database Maintenance
Implement database maintenance tasks.
- Lesson Index Maintenance Strategies 12 min
- Quiz Index Maintenance Strategies Quiz 5 questions
- Lesson Statistics Update Procedures 12 min
- Quiz Statistics Update Procedures Quiz 5 questions
- Lesson Database Consistency Checks 12 min
- Quiz Database Consistency Checks Quiz 5 questions
- Lesson Maintenance Plan Creation 12 min
- Quiz Maintenance Plan Creation Quiz 5 questions
Your Progress
No DP-300 practice exam yet
Your points already work on 4 E2E Test Vendor and Microsoft exams.
See the exams