Database Administration Exercises

These exercises support Microsoft course DP-300: Administering Microsoft Azure SQL Solutions.

Module Exercise
Setup your own environment Setup your own environment
Plan and Implement Data Platform Resources Lab 1 - Provision SQL Server on an Azure Virtual Machine
Plan and Implement Data Platform Resources Lab 2 - Provision an Azure SQL Database
Implement a Secure Environment for a Database Service Lab 3 – Authorize access to Azure SQL Database with Azure Active Directory
Implement a Secure Environment for a Database Service Lab 4 – Configure Azure SQL Database firewall rules
Implement a Secure Environment for a Database Service Lab 5 – Enable Microsoft Defender for SQL and Data classification
Monitor and optimize operational resources in Azure SQL Lab 6 – Isolate performance problems through monitoring
Monitor and optimize operational resources in Azure SQL Lab 7 – Detect and correct fragmentation issues
Optimize query performance in Azure SQL Lab 8 – Identify and resolve blocking issues
Optimize query performance in Azure SQL Lab 9 – Identify database design issues
Optimize query performance in Azure SQL Lab 10 – Isolate problem areas in poorly performing queries in a SQL Database
Automate database tasks for Azure SQL Lab 11 – Deploy Azure SQL Database using Azure Resource Manager template
Automate database tasks for Azure SQL Lab 12 – Create a CPU status alert for a SQL Server
Automate database tasks for Azure SQL Lab 13 – Deploy an automation runbook to automatically rebuild indexes
Plan and implement a high availability and disaster recovery solution Lab 14 – Configure geo-replication for Azure SQL Database
Plan and implement a high availability and disaster recovery solution Lab 15 – Backup to URL and Restore from URL