DP-300T00 Administering Microsoft Azure SQL Solutions
Module 1: Understanding Microsoft Intelligent Data Platform Roles
– Describe Microsoft Intelligent Data Platform roles
– Understand the role of SQL Server in an Azure virtual machine
– Design Azure SQL Database for cloud-native applications
– Explore Azure SQL Database Managed Instance
Module 2: Deploying IaaS Solutions with Azure SQL
– Explain IaaS options for deploying SQL Server in Azure
– Understand hybrid scenarios
– Explore performance and security considerations
– Explain high availability and disaster recovery options
Module 3: Deploying PaaS Solutions with Azure SQL
– Explain PaaS options for deploying SQL Server in Azure
– Explore single SQL database deployment
– Deploy SQL database elastic pool
– Understand SQL database hyperscale
– Examine SQL managed instance
– Describe SQL Edge
Module 4: Strategies for Migrating to Azure SQL
– Understand compatibility level and Azure preview features
– Describe Azure database migration options
Module 5: Migrating SQL Server Workloads to Azure SQL Database
– Choose the right Azure SQL Database feature
– Use Azure SQL migration extension and Data Migration Assistant
– Migrate to Azure SQL Database using BACPAC or online methods
– Move data to Azure SQL Database
Module 6: Migrating SQL Server Workloads to Azure SQL Managed Instance
– Evaluate migration scenarios
– Use Log Replay Service (LRS) and Managed Instance link to migrate
– Move data to SQL Managed Instance
Module 7: Configuring Database Authentication and Authorization
– Describe Active Directory and Microsoft Enterprise ID
– Explain authentication, identities, and security principals
– Define database and object permissions
– Identify authentication and authorization failures
Module 8: Protecting Data In-Transit and At Rest
– Explore Transparent Data Encryption and object encryption
– Configure server and database firewall rules
– Enable encrypted connections
– Describe SQL injection and Azure Key Vault
Module 9: Implementing Compliance Controls for Sensitive Data
– Explore data classification and server/database audit
– Implement Dynamic Data Masking and Row-Level security
– Understand Microsoft Defender for SQL and Azure SQL Database Ledger
– Implement Azure Purview
Module 10: Performance Monitoring and Optimization
– Describe performance monitoring tools and critical metrics
– Establish baseline metrics and explore extended events
– Use Query Performance Insight
– Configure SQL Server resources for optimal performance
Module 11: Automating Deployment of Database Resources
– Describe deployment models in Azure
– Automate deployment using Azure Resource Manager templates and Bicep, PowerShell, and Azure CLI
Module 12: Managing SQL Agent Jobs
– Create a SQL Server maintenance plan
– Describe task status notifications
Module 13: Managing Azure PaaS Tasks Using Automation
– Explore Elastic jobs and Azure Automation
– Build an automation runbook
– Automate database workflows using Logic Apps
– Monitor automated tasks
Module 14: High Availability and Disaster Recovery Strategies
– Describe recovery time objective and recovery point objective
– Explore high availability and disaster recovery options for Azure Virtual Machines and PaaS deployments
– Describe hybrid solutions
Module 15: IaaS and PaaS Solutions for High Availability and Disaster Recovery
– Describe failover clusters in Windows Server
– Configure Always-on availability groups
– Describe active geo-replication for Azure SQL Database
– Explore auto-failover groups for Azure SQL Database and Azure SQL Managed Instance
Module 16: Backing Up and Restoring Databases
– Back up and restore SQL Server running on Azure virtual machines
– Back up a SQL Server virtual machine
– Back up and restore a database using Azure SQL Database