Administering Microsoft Azure SQL Solutions

Module 1 : Prepare to Maintain SQL Databases on Azure

• Introduction
• Describe Microsoft Intelligent Data Platform roles
• Understand SQL Server in an Azure virtual machine
• Design Azure SQL Database for cloud-native applications
• Explore Azure SQL Database Managed Instance
• Knowledge check
• Summary

Module 2 : Deploy IaaS Solutions with Azure SQL

• Introduction
• Explain IaaS options to deploy SQL Server in Azure
• Understand hybrid scenarios
• Explore performance and security
• Explain high availability and disaster recovery options
• Exercise: Provision a SQL Server on an Azure Virtual Machine
• Knowledge check
• Summary

Module 3 : Deploy PaaS Solutions with Azure SQL

• Introduction
• Explain PaaS options for deploying SQL Server in Azure
• Explore single SQL database
• Deploy SQL database elastic pool
• Understand SQL database hyperscale
• Examine SQL managed instance
• Describe SQL Edge
• Exercise: Deploy an Azure SQL Database
• Knowledge check
• Summary

Module 4 : Evaluate Strategies for Migrating to Azure SQL

• Introduction
• Understand compatibility level
• Understand Azure preview features
• Describe Azure database migration options
• Knowledge check
• Summary

Module 5: Migrate SQL Workloads to Azure SQL Databases

• Introduction
• Choose the right SQL Server Instance option in Azure
• Migrate SQL Server to Azure SQL Database offline
• Migrate SQL Server to Azure SQL Database online
• Load and move data to Azure SQL Database
• Summary

Module 6: Migrate SQL Workloads to Azure Managed Instances

• Introduction
• Evaluate migration scenarios to SQL Database Managed Instance
• Migrate to SQL Database Managed Instance
• Load and Move data to SQL Database Managed Instance
• Summary

Module 7: Configure Database Authentication and Authorization

• Introduction
• Describe Active Directory and Azure Active Directory
• Describe authentication and identities
• Describe Security Principals
• Describe database and object permissions
• Identify authentication and authorization failures
• Exercise: Authorize Access to Azure SQL Database with Azure Active Directory
• Knowledge check
• Summary

Module 8: Protect Data In-transit and At Rest

• Introduction
• Explore Transparent Data Encryption
• Configure server and database firewall rules
• Explain object encryption and secure enclaves
• Enable encrypted connections
• Describe SQL injection
• Understand Azure Key Vault
• Exercise: Configure a server-based firewall rule using the Azure portal
• Knowledge check
• Summary

Module 9 : Implement Compliance Controls for Sensitive Data

• Introduction
• Explore data classification
• Explore server and database audit
• Implement Dynamic Data Masking
• Implement Row Level security
• Understand Microsoft Defender for SQL
• Explore Azure SQL Database Ledger
• Implement Azure Purview
• Exercise: Enable Microsoft Defender for SQL and Data Classification
• Knowledge check
• Summary

Module 10 : Describe Performance Monitoring

• Introduction
• Describe performance monitoring tools
• Describe critical performance metrics
• Establish baseline metrics
• Explore extended events
• Describe Azure SQL Insights
• Explore Query Performance Insight
• Exercise: Isolate problems with monitoring
• Knowledge check
• Summary

Module 11 : Configure SQL Server Resources for Optimal Performance

• Introduction
• Explain how to optimize Azure storage for SQL Server virtual machines
• Describe virtual machine resizing
• Optimize database storage
• Control SQL Server resources
• Knowledge check
• Summary

Module 12 : Configure Databases for Optimal Performance

• Introduction
• Explore database maintenance checks
• Describe database scoped configuration options
• Describe automatic tuning
• Describe intelligent query processing
• Exercise: Detect and correct fragmentation issues
• Knowledge check
• Summary

Module 13 : Explore Query Performance Optimization

• Introduction
• Understand query plans
• Explain estimated and actual query plans
• Describe dynamic management views and functions
• Explore Query Store
• Identify problematic query plans
• Describe blocking and locking
• Exercise: Identify and resolve blocking issues
• Knowledge check
• Summary

Module 14 : Evaluate Performance Improvements

• Introduction
• Describe wait statistics
• Tune and maintain indexes
• Understand query hints
• Exercise: Isolate problem areas in poorly performing queries
• Knowledge check
• Summary

Module 15 : Explore Performance-based Design

• Introduction
• Describe normalization
• Choose appropriate data types
• Design indexes
• Exercise: Identify database design issues
• Summary

Module 16 : Automate Deployment of Database Resources

• Introduction
• Describe deployment models in Azure
• Automate deployment by using Azure Resource Manager templates and Bicep
• Automate deployment by using PowerShell

• Automate deployment by using Azure CLI
• Exercise: Deploy an Azure SQL Database using an Azure Resource Manager template
• Knowledge check
• Summary

Module 17 : Create and Manage SQL Agent Jobs

• Introduction
• Create a SQL Server maintenance plan
• Describe task status notifications
• Knowledge check
• Exercise: Create a CPU status alert for a SQL Server
• Summary

Module 18 : Manage Azure PaaS Tasks using Automation

• Introduction
• Explore Elastic jobs
• Understand Azure Automation
• Build an automation runbook
• Automate database workflows by using Logic Apps
• Monitor automated tasks
• Exercise: Deploy an automation runbook to automatically rebuild indexes
• Knowledge check
• Summary

Module 19 : Describe High Availability and Disaster Recovery Strategies

• Introduction
• Describe recovery time objective and recovery point objective
• Explore high availability and disaster recovery options
• Describe Azure high availability and disaster recovery features for Azure Virtual Machines
• Describe high availability and disaster recovery options for PaaS deployments
• Explore an IaaS high availability and disaster recovery solution
• Describe hybrid solutions
• Knowledge check
• Summary

Module 20 : Explore IaaS and PaaS Solutions for High Availability and Disaster Recovery

• Introduction
• Describe failover clusters in Windows Server
• Configure Always-on availability groups
• Describe temporal tables in Azure SQL Database
• Describe active geo-replication for Azure SQL Database
• Explore auto-failover groups for Azure SQL Database and Azure SQL Managed Instance
• Exercise: Configure geo replication for Azure SQL Database
• Knowledge check
• Summary

Module 21 : Back Up and Restore Databases

• Introduction
• 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
• Exercise: Backup to URL
• Knowledge check
• Summary