AI Instructor Live Labs Included Exam Prep

DP-300: Administering Microsoft Azure SQL Solutions

Prepare for the DP-300 certification exam. Learn to deploy, secure, monitor, automate, and protect Azure SQL solutions through AI-guided lessons and 15 hands-on labs in real Azure environments.

Intermediate

15h 15m

10 Lessons

DP-300

Exam Preparation Included

Practice with real exam-style questions for the DP-300 certification. AI-powered feedback helps you understand every answer.

Practice Questions Track Progress AI Feedback

About This Course

Master the skills needed to administer and manage SQL Server and Azure SQL databases as a Microsoft Azure Database Administrator. This comprehensive course prepares you for the DP-300 certification exam by covering all five exam domains through AI-guided teaching lessons and hands-on lab exercises.What You'll Learn: Plan and implement data platform resources deploy SQL Server on Azure VMs and provision Azure SQL Databases with proper networking. Implement a secure environment configure Microsoft Entra ID authentication, firewall rules, Microsoft Defender for SQL, and data classification. Monitor and optimize operational resources use monitoring tools to isolate performance problems, detect fragmentation, resolve blocking issues, and optimize queries. Configure and manage automation deploy databases using ARM templates, set up CPU alerts with Azure Monitor, and automate index maintenance with Azure Automation. Plan and implement high availability and disaster recovery configure geo-replication across regions and implement backup/restore to Azure Blob Storage.Prerequisites: Experience with SQL Server administration and T-SQL queries. Basic understanding of Azure cloud concepts and the Azure portal. Familiarity with database concepts (indexes, normalization, query plans).Course Format: This AI-led course alternates between teaching lessons (guided by an AI instructor) and hands-on lab exercises (real Azure environments). Each exam domain has a dedicated teaching lesson followed by practical labs that reinforce the concepts.

Course Curriculum

10 Lessons

AI Lesson

Plan and Implement Data Platform Resources

1h 0m

Learn how to plan and deploy SQL Server on Azure Virtual Machines and Azure SQL Database. Understand deployment options, networking configurations, and when to choose IaaS vs PaaS for your database workloads.

Lab Exercise

Provisioning Azure SQL Resources

1h 55m 2 Exercises

Hands-on exercises for provisioning SQL Server on an Azure VM and creating an Azure SQL Database with Virtual Network endpoints.

Provision SQL Server on an Azure Virtual Machine Deploy a SQL Server virtual machine in Azure and connect to it using SQL Server Management Studio. Gain hands-on experience provisioning and configuring SQL Server as an IaaS resource in Azure. ~30 min

Provision an Azure SQL Database Create an Azure SQL Database with a Virtual Network Endpoint and connect to it using SQL Server Management Studio. Understand how to deploy and access a fully managed PaaS database in Azure. ~40 min

AI Lesson

Implement a Secure Environment for Database Services

1h 0m

Learn how to secure Azure SQL databases using Microsoft Entra ID authentication, firewall rules, Microsoft Defender for SQL, and data classification to protect sensitive information.

Lab Exercise

Securing Azure SQL Solutions

2h 10m 3 Exercises

Hands-on exercises for configuring Microsoft Entra ID access, database firewall rules, and enabling Microsoft Defender with data classification.

Authorize Access to Azure SQL Database with Microsoft Entra ID Use Microsoft Entra ID to grant access to an Azure SQL Database and create database users with T-SQL. Implement both Microsoft Entra and SQL-based authentication to secure your database. ~25 min

Configure Azure SQL Database Firewall Rules Configure server-level and database-level firewall rules to control access to an Azure SQL Database, and create a contained database user using T-SQL. ~30 min

Enable Microsoft Defender for SQL and Data Classification Enable Microsoft Defender for SQL on an Azure SQL Database and apply data classification labels based on Azure portal recommendations to strengthen your database security posture. ~30 min

AI Lesson

Monitor and Optimize Operational Resources

1h 0m

Learn how to monitor Azure SQL performance, identify and resolve fragmentation, blocking issues, and database design problems, and optimize query performance using execution plans and DMVs.

Lab Exercise

Performance Monitoring and Query Optimization

2h 35m 5 Exercises

Hands-on exercises for monitoring performance, detecting fragmentation, resolving blocking issues, identifying database design problems, and optimizing poorly performing queries.

Isolate Performance Problems Through Monitoring Explore server resource metrics for an Azure SQL Database and use Query Performance Insight to identify poorly performing queries. ~30 min

Detect and Correct Fragmentation Issues Analyze index fragmentation in a SQL Server database and rebuild or reorganize indexes to improve query performance. ~20 min

Identify and Resolve Blocking Issues Identify sessions that are being blocked in SQL Server and learn how to diagnose and mitigate blocking scenarios using dynamic management views. ~15 min

Identify Database Design Issues Analyze the AdventureWorks database to identify performance issues caused by poor normalization, incorrect data type choices, and suboptimal index design. ~15 min

Isolate Problem Areas in Poorly Performing Queries Run queries with suboptimal performance against AdventureWorks2017, analyze execution plans, and apply improvements to boost query efficiency. ~30 min

AI Lesson

Configure and Manage Automation of Tasks

1h 0m

Learn how to automate Azure SQL database deployments with ARM templates, set up monitoring alerts, and create automation runbooks for routine maintenance tasks.

Lab Exercise

Automating Database Tasks

1h 50m 3 Exercises

Hands-on exercises for deploying Azure SQL databases using ARM templates, creating CPU alerts with Azure Monitor, and building automation runbooks for index maintenance.

Deploy Azure SQL Database Using ARM Template Explore and deploy an Azure SQL Database using an Azure Resource Manager template from the Azure Quickstart Templates gallery. ~15 min

Create a CPU Status Alert for a SQL Server Configure an Azure Monitor alert to notify you when CPU usage on an Azure SQL Server exceeds a defined threshold. ~20 min

Deploy an Automation Runbook to Rebuild Indexes Create an Azure Automation runbook that automatically rebuilds indexes in an Azure SQL Database on a schedule to reduce manual maintenance tasks. ~30 min

AI Lesson

Plan and Implement High Availability and Disaster Recovery

1h 0m

Learn how to implement geo-replication for cross-region high availability, configure failover strategies, and use backup/restore to Azure Blob Storage for disaster recovery scenarios.

Lab Exercise

High Availability and Disaster Recovery

1h 45m 2 Exercises

Hands-on exercises for configuring geo-replication across Azure regions with manual failover and implementing SQL Server backup/restore to Azure Blob Storage.

Configure Geo-Replication for Azure SQL Database Configure geo-replication for an Azure SQL Database to create a readable secondary replica in another Azure region and perform a manual failover. ~30 min

Backup to URL and Restore from URL Back up a SQL Server database directly to Azure Blob Storage using a URL and restore it to simulate recovery from a human error. ~30 min

This course includes:

24/7 AI Instructor Support
Live Lab Environments
5 Hands-on Lessons
Exam Prep Included

Skill Level Intermediate

Total Duration 15h 15m