{"product_id":"migrate-sql-server-workload-to-azure-sql-dp-3001","title":"Migrate SQL Server workload to Azure SQL (DP-3001)","description":"\u003cdiv\u003e\u003cp\u003ePrepare 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.\u003c\/p\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eMigrate SQL Server workload to Azure SQL (DP-3001) Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cb\u003eUpon successful completion of this course, students will gain proficiency in the following areas:  \u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eAssessing SQL Server databases for migration. \u003c\/li\u003e\n\u003cli\u003eDeploying Azure SQL solutions. \u003c\/li\u003e\n\u003cli\u003eMigrating SQL Server workloads to Azure SQL. \u003c\/li\u003e\n\u003cli\u003ePerforming post-migration tasks on Azure SQL. \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cb\u003eTraining Prerequisites\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003ePrior 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.\u003c\/p\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003eMigrate SQL Server workload to Azure SQL (DP-3001) Training Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 1: Design a SQL Server Migration Strategy \u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eIntroduction \u003c\/li\u003e\n\u003cli\u003eExamine data platform modernization \u003c\/li\u003e\n\u003cli\u003ePlan a data migration \u003c\/li\u003e\n\u003cli\u003eExplore available data migration technologies \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eExercise: Compare on-premises Azure costs\u003c\/p\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 2: Assess SQL Server Databases for Migration to Azure SQL \u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eIntroduction \u003c\/li\u003e\n\u003cli\u003eReview database for compatibility \u003c\/li\u003e\n\u003cli\u003eExplore assessment options for database migration \u003c\/li\u003e\n\u003cli\u003eAssess a database with Azure Migration extension \u003c\/li\u003e\n\u003cli\u003eAssess a database with Azure Migrate \u003c\/li\u003e\n\u003cli\u003eAssess a database with Data Migration Assistant \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eExercise: Identify compatibility issues \u003c\/p\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 3: Deploy PaaS Solutions with Azure SQL \u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eIntroduction \u003c\/li\u003e\n\u003cli\u003eExplain PaaS options for deploying SQL Server in Azure \u003c\/li\u003e\n\u003cli\u003eExplore single SQL database \u003c\/li\u003e\n\u003cli\u003eDeploy SQL database elastic pool \u003c\/li\u003e\n\u003cli\u003eUnderstand SQL database hyperscale \u003c\/li\u003e\n\u003cli\u003eExamine SQL managed instance \u003c\/li\u003e\n\u003cli\u003eDescribe SQL Edge \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eExercise: Deploy an Azure SQL Database \u003c\/p\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 4: Configure Database Authentication and Authorization \u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eIntroduction \u003c\/li\u003e\n\u003cli\u003eDescribe Active Directory and Microsoft Entra ID \u003c\/li\u003e\n\u003cli\u003eDescribe authentication and identities \u003c\/li\u003e\n\u003cli\u003eDescribe security principals \u003c\/li\u003e\n\u003cli\u003eDescribe database and object permissions \u003c\/li\u003e\n\u003cli\u003eIdentify authentication and authorization failures \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eExercise: Authorize Access to Azure SQL Database with Microsoft Entra ID \u003c\/p\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 5: Migrate SQL Server Workloads to Azure SQL Database \u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eIntroduction \u003c\/li\u003e\n\u003cli\u003eChoose the right Azure SQL Database feature \u003c\/li\u003e\n\u003cli\u003eUse Azure SQL Migration extension to migrate to Azure SQL Database \u003c\/li\u003e\n\u003cli\u003eExplore Data Migration Assistant to migrate to Azure SQL Database \u003c\/li\u003e\n\u003cli\u003eMigrate to Azure SQL Database using BACPAC \u003c\/li\u003e\n\u003cli\u003eUse an online method to migrate to Azure SQL Database \u003c\/li\u003e\n\u003cli\u003eMove data to Azure SQL Database \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eExercise: Migrate a SQL Server database to Azure SQL Database \u003c\/p\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 6: Perform Post-Migration Tasks on Azure SQL \u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eIntroduction \u003c\/li\u003e\n\u003cli\u003eMigrate SQL logins and groups \u003c\/li\u003e\n\u003cli\u003eImplement security to protect Azure SQL \u003c\/li\u003e\n\u003cli\u003eImplement compliance controls for sensitive data \u003c\/li\u003e\n\u003cli\u003eMonitor database performance \u003c\/li\u003e\n\u003cli\u003eConfigure high availability and disaster recovery \u003c\/li\u003e\n\u003cli\u003eAutomate database tasks for scalability \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eExercise: Configure geo-replication for Azure SQL Database \u003c\/p\u003e\n\u003c\/div\u003e","brand":"Microsoft","offers":[{"title":"267A88US \/ 2026-07-07T09:00:00 \/ Online","offer_id":47534210547931,"sku":"US-8696-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"26AA07US \/ 2026-10-01T09:00:00 \/ Online","offer_id":47638416851163,"sku":"US-8696-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"271B90US \/ 2027-01-12T09:00:00 \/ Online","offer_id":48216573083867,"sku":"US-8696-IL","price":716.0,"currency_code":"USD","in_stock":true}],"url":"https:\/\/learningtreeinternational-dirinfosec-hhs.myshopify.com\/products\/migrate-sql-server-workload-to-azure-sql-dp-3001","provider":"Learning Tree International","version":"1.0","type":"link"}