Online learning from an accredited institution
DP-300: Azure Database Administrator
As the Azure database administrator, you implement and manage the operational aspects of cloud-native and
hybrid data platform solutions built on SQL Server and Azure SQL services. You use a variety of methods and
tools to perform and automate day-to-day operations, including applying knowledge of using Transact-SQL (TSQL)
and other tools for administrative management purposes
4 Day Instructor-Led
Prerequisites:
As a candidate for this certification, you should have subject matter expertise in building database
solutions that are designed to support multiple workloads built with:
• SQL Server on-premises
• Azure SQL services
• Azure SQL Database
• Azure SQL Managed Instance
• SQL Server on Azure Virtual Machines (Windows and Linux)
Course Outline
Module 1: Plan and Implement Data Platform Resources
• 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
Module 2: Implement a Secure Environment for a Database Service
• Configure database authentication and authorization
• Protect data in-transit and at rest
• Implement compliance controls for sensitive data
Module 3: Monitor and Optimize Operational Resources in Azure SQL
• Describe performance monitoring
• Configure SQL Server resources for optimal
performance
• Configure databases for optimal performance
Module 4: Optimize query performance in Azure SQL
• Explore query performance optimization
• Explore performance-based database design
• Evaluate performance improvements
Module 5: Plan and Implement a High Availability and Disaster Recovery Environment
• Describe high availability and disaster recovery strategies
• Explore IaaS and PaaS solutions for high availability and disaster recovery
• Backup and restore databases