Reviews
Target Audience
Course Overview
Course Requirements
Course Syllabus
See All    Download exam skill outline
-
Module 1: Plan and Implement Data Platform Resources
▼

Understanding and deploying Azure SQL infrastructure.
Lessons:

  • Prepare to maintain SQL Server–based databases on Azure

  • Deploy IaaS solutions with Azure SQL

  • Deploy PaaS solutions with Azure SQL

  • Migrate SQL Server workloads to Azure SQL Database

  • Migrate SQL Server workloads to Azure SQL Managed Instance

Key Topics:

  • Deployment models: IaaS vs PaaS vs hybrid

  • Azure SQL Database, Managed Instance, SQL Server on VM

  • Migration strategies and tools

  • Resource sizing, provisioning, and ARM / template deployment

-
Module 2: Implement a Secure Environment
▼

Securing Azure SQL resources with authentication, authorization, and data protection.
Lessons:

  • Configure database authentication and authorization

  • Protect data in transit and at rest

  • Implement compliance controls for sensitive data

Key Topics:

  • Azure Active Directory identities, SQL authentication, permissions

  • Encryption (TDE, Always Encrypted), TLS

  • Firewalls, data classification, dynamic data masking, row-level security

-
Module 3: Monitor and Optimize Operational Resources
▼

Monitoring resource health and performance tuning.
Lessons:

  • Establish performance baselines

  • Identify performance issues

  • Optimize hardware and server configurations

  • Perform maintenance tasks

Key Topics:

  • Performance metrics (CPU, I/O, storage, memory)

  • Query Store, dynamic management views (DMVs)

  • Index and statistics maintenance

  • Scaling strategies and resource governance

-
Module 4: Optimize Query Performance
▼

Deep dive into query-level optimization.
Lessons:

  • Analyze query execution plans

  • Design database for performance

  • Implement performance improvements

Key Topics:

  • Estimated vs actual plans, Query Store insights

  • Index strategy and normalization trade-offs

  • Intelligent query processing, locking, query hints

-
Module 5: Automate Database Tasks
▼

 Automation of deployment, maintenance, and operational workflows.
Lessons:

  • Automate resource deployment (ARM templates, CLI, PowerShell)

  • Create and manage SQL Server Agent or Elastic Jobs

  • Use Azure Automation and Logic Apps for database workflows

Key Topics:

  • Infrastructure as Code (IaC) for databases

  • Job scheduling, monitoring, and alerts

  • Runbooks, automation pipelines, multi-instance orchestration

-
Module 6: Plan and Implement High Availability and Disaster Recovery
▲

Strategies and implementation for business continuity.
Lessons:

  • Define HA/DR requirements (RTO, RPO)

  • Implement HA/DR in IaaS and PaaS

  • Configure backup and restore strategies

Key Topics:

  • Always On Availability Groups, auto-failover groups, geo-replication

  • Backup to URL, point-in-time restore, long-term retention

  • Hybrid HA/DR scenarios with SQL Server on Azure VM