Module 1: Design a SQL Server migration strategy
- Explain what data platform modernization is
- Review the stages of a data migration
- Recommend when to use an Azure data platform technology
- Explore the cost savings of moving your SQL workloads to Azure
Module 2 : Assess SQL Server databases for migration to Azure SQL
- Understand common compatibility issues and blockers that may prevent a migration to Azure SQL.
- Discover the various tools and options available for assessing SQL Server databases for migration purposes.
- Use the Azure migration extension for Azure Data Studio to assess SQL Server databases.
- Use the Azure Migrate and other tools to assess SQL Server databases.
Module 3: 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 4 : 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 5 : Migrate SQL Server workloads to Azure Virtual Machine
- Understand the importance of careful planning for a successful migration of SQL Server workloads to Azure Virtual Machines.
- Migrate databases using Azure SQL Migration extension for Azure Data Studio and tracking database migration activities to SQL Server on Azure Virtual Machines.
- Explore several other methods for migrating SQL Server databases to Azure Virtual Machines.
Module 6 : 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 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 7 : 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 8 : Perform post-migration tasks on Azure SQL
- Implement compliance controls for sensitive data.
- Monitor database performance in Azure SQL.
- Configure high availability and disaster recovery in Azure SQL.
- Automate database tasks for scalability.
