Administering Microsoft Azure SQL Solutions (DP-300T00)

Module 1 : Prepare to maintain SQL databases on Azure

• Understand the role of Azure Database Administrator as it fits in with other data platform roles.
• Describe the key differences between the SQL Server-based database options in Azure.
• Describe other features for Azure SQL platforms available.

Module 2 : Deploy IaaS solutions with Azure SQL

• Explore the basics of SQL Server in an Infrastructure as a Service (IaaS) offering
• Learn the available options for provisioning and deployment
• Deploy SQL Server into an Azure Virtual Machine

Module 3 : Deploy PaaS solutions with Azure SQL

• Gain an understanding SQL Server in a Platform as a Service (PaaS) offering
• Understand PaaS provisioning and deployment options
• Understand elastic pools
• Examine Azure SQL Managed Instances
• Explore Azure SQL Edge
• Configure a template for PaaS deployment

Module 4 : Evaluate strategies for migrating to Azure SQL

• Evaluate different Azure migration options when moving your SQL environment to the cloud.
• Understand how SQL Server compatibility level affects database behavior.
• Understand the differences between private and public preview options.

Module 5 : Migrate SQL Server workloads to Azure SQL Database

• Explore the advantages, capabilities, and migration possibilities offered by Azure SQL Database.
• Migrate databases using Azure SQL Migration extension for Azure Data Studio and tracking database migration activities.
• Use the Data Migration Assistant (DMA) tool to facilitate SQL Server migrations to Azure SQL Database.
• Use transactional replication as an online method to migrate to Azure SQL Database.
• Explore several other methods for migrating SQL Server databases to Azure SQL Database.

Module 6 : Migrate SQL Server workloads to Azure SQL Managed Instance

• Explore the advantages, capabilities, and migration possibilities offered by Azure SQL Managed Instance.
• Learn how Log Replay Service works to migrate to Azure SQL Managed Instance.
• Understand how Managed Instance link feature works in a migration scenario.
• Load and move data to and from Azure SQL Managed Instance.
• Explore several other methods for migrating SQL Server databases to Azure SQL Database.

Module 7 : Configure database authentication and authorization

• Learn about authentication options for Azure SQL Database
• Create various security principals
• Configure permissions within a SQL database
• Identify authentication and authorization failures

Module 8 : Protect data in-transit and at rest

• Understand the data encryption options available in the various platforms
• Implement object level encryption
• Understand the difference between database and server firewall rules for Azure SQL Database
• Explore Always Encrypted with secure enclaves

Module 9 : Implement compliance controls for sensitive data

• Plan and implement data classification in Azure SQL Database
• Understand and configure row-level security and dynamic data masking
• Understand the usage of Microsoft Defender for SQL
• Explore how Azure SQL Database Ledger works

Module 10 : Describe performance monitoring

• Review potential performance issues.
• Identify critical Azure metrics.
• Learn how to collect metrics for an established baseline.
• Use extended events for performance analysis.
• Understand Azure SQL Database Intelligent Insights.

Module 11 : Configure SQL Server resources for optimal performance

• Understand your options for configuration of Azure storage
• Learn how to configure TempDB data files in SQL Server
• Learn how to choose the right type of VM for SQL Server workloads
• Understand the use cases and configuration of Resource Governor in SQL Server

Module 12 : Configure databases for optimal performance

• Understand database scoped configuration options
• Understand maintenance tasks related to indexing and statistics
• Understand the features of Intelligent Query Processing (IQP)
• Explore the automatic tuning feature in Azure

Module 13 : Explore query performance optimization

• Generate and save execution plans
• Compare the different types of execution plans
• Understand how and why query plans are generated
• Explain the purpose and benefits of the Query Store
• Investigate the available reports and data in the Query Store

Module 14 : Evaluate performance improvements

• Determine when changing indexes or defining new ones can affect performance
• Evaluate wait statistics as an aid in finding areas for performance improvement
• Understand how query hints work, and when to use them

Module 15 : Explore performance-based design

• Explore normal forms and how they affect database design
• Choose appropriate datatypes for your data
• Evaluate appropriate index types

Module 16 : Automate deployment of database resources

• Describe the deployment models available on Azure
• Deploy database resources using PowerShell and Azure CLI
• Deploy an Azure Resource Manager template and Bicep
• Understand the difference between multiple command-line options

Module 17 : Create and manage SQL Agent jobs

• Schedule necessary maintenance activities for your databases.
• Configure notifications and alerts on SQL Server Agent jobs, and SQL Server.
• Configure alerts based on performance monitor values.

Module 18 : Manage Azure PaaS tasks using automation

• Understand the benefits of Azure policy
• Explore the capabilities of Azure Automation
• Configure elastic jobs
• Use Logic Apps for database workflow

Module 19 : Describe high availability and disaster recovery strategies

• Define recovery time objective and recovery point objective
• Explore the available high availability and disaster recovery options for both IaaS and PaaS
• Devise an appropriate high availability and disaster recovery strategy

Module 20 : Explore IaaS and PaaS solutions for high availability and disaster recovery

• Explore options for deploying a WSFC in Azure
• Explore options for deploying an AG in Azure
• Implement Temporal Tables
• Plan active geo-replication and auto-failover groups

Module 21 : Back up and restore databases

• Explore backup and restore options for IaaS
• Implement backup and restore for PaaS