| 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 Microsoft Entra ID |
| 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 |