Azure Database Administrator Associate (DP-300)

Learn to administer Azure SQL solutions and prepare for exam DP-300: Administering Microsoft Azure SQL Solutions. The course follows the official skills measured.

What you'll learn

• Plan, deploy and migrate Azure SQL resources
• Secure data and meet compliance
• Monitor and optimize performance
• Automate database tasks
• Plan and configure high availability and disaster recovery

Course outline

1. Plan and Implement Data Platform Resources (15–20%)
   • Plan and deploy Azure SQL solutions
   • Configure resources for scale and performance
   • Migration strategy
2. Implement a Secure Environment (20–25%)
   • Authentication and authorization
   • Security for data at rest and in transit
   • Compliance controls for sensitive data
3. Monitor, Configure and Optimize Database Resources (20–25%)
   • Monitor activity and performance
   • Optimize query performance
   • Configure for optimal performance
4. Configure and Manage Automation of Tasks (15–20%)
   • SQL Server Agent jobs
   • Automate deployment
   • Database tasks in Azure
5. Plan and Configure HA/DR (20–25%)
   • HA/DR strategy
   • Backup and restore
   • Configure HA/DR