---
title: DP-300 Labs
description: "Lab exercises for DP-300: Administering Microsoft Azure SQL Solutions. Includes Applied Skills, Microsoft Learn, and Microsoft GitHub labs."
---

**Applied Skills:**

:::note
Applied Skills on Microsoft Learn are practical, hands-on exercises designed to help users build and demonstrate proficiency in specific technologies or tasks. These small labs focus on solving real-world scenarios, reinforcing learning through direct application of skills, and preparing users for industry roles or certifications.
:::

### Migrate SQL Server workloads to Azure SQL Database

### Configure and migrate to Azure Database for PostgreSQL

**Microsoft Learn:**

:::note
Microsoft Learn Sandboxes require you to bring in your own subscription.
:::

### Provision a SQL Server on an Azure Virtual Machine

### Compare on-premises Azure costs

### Deploy an Azure SQL Database

### Identify compatibility issues

### Migrate a SQL Server database to Azure SQL Database

### Migrate a SQL Server database to Azure SQL Managed Instance

### Migrate SQL Server databases to SQL Server on Azure Virtual Machine

### Access to Azure SQL Database with Microsoft Entra ID

### Configure a server-based firewall rule using the Azure portal

### Enable Microsoft Defender for SQL and Data Classification

### Isolate problems with monitoring

### Detect and correct fragmentation issues

### Identify and resolve blocking issues

### Identify database design issues

### Isolate problem areas in poorly performing queries

### Diagnose a slow query and generate a fix with Copilot

### Deploy an Azure SQL Database using an Azure Resource Manager template

### Create a CPU status alert for a SQL Server

### Deploy an automation runbook to automatically rebuild indexes

### Configure geo replication for Azure SQL Database

### Backup to URL

**Microsoft GitHub:**

:::note
Microsoft GitHub labs are series of labs designed to be used in Microsoft Instructor Lead Trainings delivered by Microsoft Certified Trainers where participants also have access to the environment to perform them. This means that for everyone else, it is necessary to bring your own environment to go through them.
:::

### Setup your own environment