Migrate SQL Server workload to Azure SQL (DP-3001)

Course Overview

1 - Design a SQL Server migration strategy

• Examine data platform modernization
• Plan a data migration
• Explore the available data migration technologies

2 - Assess SQL Server databases for migration to Azure SQL

• 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

3 - 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

4 - Configure database authentication and authorization

• Describe Active Directory and Microsoft Entra ID
• Describe authentication and identities
• Describe Security Principals
• Describe database and object permissions
• Identify authentication and authorization failures

5 - Migrate SQL Server workloads to Azure SQL Database

• 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

6 - Perform post-migration tasks on Azure SQL

• 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

Prerequisites

• Experience with SQL Server databases.
• Knowledge of SQL Server editions and versions.
• Basic knowledge of security concepts like identities and permissions.
• Experience using the Azure portal to create resources and set permissions.