Module 1: Design a SQL Server Migration Strategy
- Introduction
- Examine data platform modernization
- Plan a data migration
- Explore available data migration technologies
Exercise: Compare on-premises Azure costs
Module 2: Assess SQL Server Databases for Migration to Azure SQL
- Introduction
- Review database for compatibility
- Explore assessment options for database migration
- Assess a database with Azure Migration extension
- Assess a database with Azure Migrate
- Assess a database with Data Migration Assistant
Exercise: Identify compatibility issues
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
Module 4: Configure Database Authentication and Authorization
- Introduction
- Describe Active Directory and Microsoft Entra ID
- 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 Microsoft Entra ID
Module 5: Migrate SQL Server Workloads to Azure SQL Database
- Introduction
- Choose the right Azure SQL Database feature
- Use Azure SQL Migration extension to migrate to Azure SQL Database
- Explore Data Migration Assistant to migrate to Azure SQL Database
- Migrate to Azure SQL Database using BACPAC
- Use an online method to migrate to Azure SQL Database
- Move data to Azure SQL Database
Exercise: Migrate a SQL Server database to Azure SQL Database
Module 6: Perform Post-Migration Tasks on Azure SQL
- Introduction
- Migrate SQL logins and groups
- Implement security to protect Azure SQL
- Implement compliance controls for sensitive data
- Monitor database performance
- Configure high availability and disaster recovery
- Automate database tasks for scalability
Exercise: Configure geo-replication for Azure SQL Database