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

Course 8696

  • Duration: 1 day
  • Language: English
  • Level: Intermediate

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) Training Delivery Methods

  • In-Person

  • Online

  • Upskill your whole team by bringing Private Team Training to your facility.

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

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

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

Exercise: Compare on-premises Azure costs

  • 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 

  • 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 

  • 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 

  • 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 

  • 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 

Need Help Finding The Right Training Solution?

Our training advisors are here for you.

Chat With Us