Agenda

• Prepare to maintain SQL databases on Azure
• 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
• Deploy IaaS solutions with Azure SQL
• Explain IaaS options to deploy SQL Server in Azure
• Understand hybrid scenarios
• Explore performance and security
• Explain high availability and disaster recovery options
• Deploy PaaS solutions with Azure SQL
• 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
• Evaluate strategies for migrating to Azure SQL
• Understand compatibility level
• Understand Azure preview features
• Describe Azure database migration options
• Migrate SQL workloads to Azure SQL databases
• 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
• Migrate SQL workloads to Azure Managed Instance
• Evaluate migration scenarios to SQL Database Managed Instance
• Migrate to SQL Database Managed Instance
• Load and Move data to SQL Database Managed Instance
• Configure database authentication and authorization
• Describe Active Directory and Azure Active Directory
• Describe authentication and identities
• Describe Security Principals
• Describe database and object permissions
• Identify authentication and authorization failures
• Protect data in-transit and at rest
• 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
• Implement compliance controls for sensitive data
• 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
• Describe performance monitoring
• Describe performance monitoring tools
• Describe critical performance metrics
• Establish baseline metrics
• Explore extended events
• Describe Azure SQL Insights
• Explore Query Performance Insight
• Configure SQL Server resources for optimal performance
• Explain how to optimize Azure storage for SQL Server virtual machines
• Describe virtual machine resizing
• Optimize database storage
• Control SQL Server resources
• Configure databases for optimal performance
• Explore database maintenance checks
• Describe database scoped configuration options
• Describe automatic tuning
• Describe intelligent query processing
• Explore query performance optimization
• 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
• Evaluate performance improvements
• Describe wait statistics
• Tune and maintain indexes
• Understand query hints
• Explore performance-based design
• Describe normalization
• Choose appropriate data types
• Design indexes
• Automate deployment of database resources
• 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
• Create and manage SQL Agent jobs
• Create a SQL Server maintenance plan
• Describe task status notifications
• Manage Azure PaaS tasks using automation
• Explore Elastic jobs
• Understand Azure Automation
• Build an automation runbook
• Automate database workflows by using Logic Apps
• Monitor automated tasks
• Describe high availability and disaster recovery strategies
• 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
• Explore IaaS and PaaS solutions for high availability and disaster recovery
• 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
• Back up and restore 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