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
- Lab: Compare on-premises Azure costs
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 to assess SQL Server databases
- Use Data Migration Assistant (DMA) to assess SQL Server databases
- Lab: Identify compatibility issues
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
- Lab: Deploy an Azure SQL Database
Configure database authentication and authorization
- Learn about authentication options for Azure SQL Database
- Create various security principals
- Configure permissions within a SQL database
- Identify authentication and authorization failures
- Lab: Authorize Access to Azure SQL Database with Microsoft Entra ID
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 the Data Migration Assistant (DMA) tool to facilitate SQL Server migrations to Azure SQL Database
- 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
- Lab: Migrate a SQL Server database to Azure SQL Database