Migrate SQL Server workload to Azure SQL (DP-3001)
Prepare for the seamless migration of SQL Server workloads to Azure SQL Database with this focused learning path. Explore assessment methodologies and compatibility checks using tools like the Azure SQL Migration Extension and Database Migration Assistant. Gain practical experience in provisioning and configuring Azure SQL Database resources while mastering migration strategies tailored to minimize downtime and optimize performance. Additionally, delve into essential post-migration tasks such as disaster recovery planning and database monitoring, ensuring a smooth transition and sustained operational excellence in the Azure environment. Migrate SQL Server workload to Azure SQL (DP-3001) Benefits Upon successful completion of this course, students will gain proficiency in the following areas: Assessing SQL Server databases for migration. Deploying Azure SQL solutions. Migrating SQL Server workloads to Azure SQL. Performing post-migration tasks on Azure SQL. Training Prerequisites Prior experience in administering SQL Server databases is required. Additionally, familiarity with Microsoft Azure services is recommended to ensure optimal understanding and engagement with the course material. Migrate SQL Server workload to Azure SQL (DP-3001) Training Outline 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