Reviews
Target Audience
Course Overview
Course Requirements
Course Syllabus
See All    Download exam skill outline
-
Module 1: Plan and Implement Data Platform Resources
▼
Content:
•Evaluate and provision Azure SQL offerings: Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure Virtual Machines.
•Migration strategies: discovery, assessment, migration execution, synchronization, and post-migration validation.
•Configure scalability and performance optimizations, including table partitioning, compression, and resource scaling.

•Learning Outcomes:
•Choose the right database service for workload requirements.
•Successfully migrate existing workloads to Azure SQL.
•Optimize cost and performance using built-in Azure features.
-
Module 2: Implement a Secure Environment
▼

Content:

  • Identity management with SQL Authentication, Windows Authentication, and Microsoft Entra ID (Azure AD).

  • Encryption strategies: Transparent Data Encryption (TDE), Always Encrypted with secure enclaves, TLS.

  • Data classification, auditing, and dynamic data masking.

  • Network security, firewall rules, and Defender for SQL.

  • Learning Outcomes:

  • Secure Azure SQL environments against unauthorized access.

  • Implement compliance-driven security policies.

  • Protect sensitive data through encryption and auditing.

-
Module 3: Monitor, Configure, and Optimize Database Performance
▼

Content:

  • Monitoring tools: SQL Insights, Extended Events, Query Store, Dynamic Management Views (DMVs).

  • Query tuning: analyzing execution plans, indexes, statistics, and identifying bottlenecks.

  • Automatic tuning and Intelligent Query Processing (IQP).

  • Advanced configuration using Resource Governor and workload isolation.
    Learning Outcomes:

  • Diagnose and resolve performance issues.

  • Continuously monitor workloads to improve efficiency.

  • Apply intelligent performance features to optimize query execution.

-
Module 4: Automate Tasks
▼

Content:

  • Task automation using SQL Server Agent, Azure Automation, and Elastic Jobs.

  • Using PowerShell, Azure CLI, and ARM/Bicep templates for automation.

  • Alerts, notifications, and scheduled jobs for proactive database management.
    Learning Outcomes:

  • Reduce administrative overhead by automating routine tasks.

  • Standardize deployments and updates across environments.

  • Implement proactive monitoring and remediation actions.

-
Module 5: Plan and Implement High Availability and Disaster Recovery
▼

Content:

  • High availability (HA) and disaster recovery (DR) strategies based on RPO/RTO.

  • Configuring failover groups, Active Geo-Replication, Always On Availability Groups, and cluster-based solutions.

  • Backup and restore strategies using T-SQL, Azure Storage, and long-term retention policies.
    Learning Outcomes:

  • Ensure business continuity with robust HA/DR solutions.

  • Select the best HA/DR option for cloud, hybrid, and on-premises workloads.

  • Implement backup and recovery plans aligned with business needs.

-
Final Outcome
▲

Upon completion, participants will:

  • Master the deployment and configuration of SQL Server and Azure SQL resources.

  • Secure and monitor database environments with advanced compliance features.

  • Automate administrative tasks to maximize efficiency.

  • Design resilient high availability and disaster recovery solutions.

  • Be fully prepared for the Microsoft Exam DP-300, leading to the Azure Database Administrator Associate certification.