Azure

DP-300 Administering Microsoft Azure SQL Solutions

Become an Azure Database Administrator in just 4 instructor-led days. This hands-on course teaches you to provision, secure, monitor, optimize and automate Azure SQL databases – preparing you for the Microsoft Certified: Azure Database Administrator Associate (Exam DP-300).

Why choose this course?

Full-stack Azure SQL coverage – learn IaaS, PaaS, Managed Instance, migration, HA/DR, security, performance tuning and automation in one bootcamp.
Hands-on, exam-aligned labs – every module maps directly to the DP-300 syllabus and uses real-world scenarios.
Cloud-native best practices – leverage Azure Monitor, Query Store, Intelligent Insights, ARM/Bicep and DevOps pipelines for database lifecycle management.
Hybrid delivery – attend on-campus or virtually from anywhere in South Africa.

This course is ideal for:

DBAs, data engineers and cloud administrators responsible for operational databases in Azure.
Infrastructure or DevOps engineers migrating on-prem SQL workloads to Azure.
Developers and architects who need to secure and optimize data platforms.
Anyone preparing for Exam DP-300 on their Microsoft certification journey.

Prerequisites

Hands-on experience with T-SQL, core Azure services (portal/CLI), and basic database administration concepts (e.g., Windows/Linux SQL Server).

Course Content

Introduction to Azure database administration – roles, IaaS vs PaaS, provisioning SQL Server on Azure VMs and Azure SQL Database fundamentals.
Plan and implement data platform resources – deploy SQL on VMs, single/multi-tenant PaaS (elastic pools, hyperscale), Managed Instance and migration approaches.
Implement a secure environment for a database service – Azure AD and SQL authentication, firewall & networking, TDE, Always Encrypted, data masking, row-level security & Defender for SQL.
Monitor and optimize operational resources in Azure SQL – Azure Monitor, metrics & alerts, Query Store, performance baselining, extended events, automatic tuning & Intelligent Insights.
Optimize query performance in Azure SQL – execution plans, index/statistic tuning, Query Store hints and best practices for high-egress workloads.
Automate database tasks for Azure SQL – ARM templates/Bicep, PowerShell, Azure CLI, SQL Agent (VMs), elastic jobs, Azure Automation and Logic Apps integration.
Plan and implement a high availability & disaster recovery environment – RPO/RTO planning, Always On AGs, failover clusters, geo-replication, auto-failover groups, backups & restores.

Hardware Requirements

Interested?

Enquire today and one of our consultants will be in touch.