DP-3001: Migrate SQL Server Workload To Azure SQL Training

DP-3001 walks you through migrating SQL Server workloads to Azure SQL. You'll learn how to assess what you have, plan the migration, move the data, and optimize things once you're on Azure. Whether you're doing a straightforward lift and shift or a full modernization, this course covers the process.

📘 SQL 👥 154 Enrolled ⏱️ 1 Day 💼 Intermediate Level ⭐ 5 | 65 Reviews

Why Microtek Learning?

500+

Courses

10+ Years

Experience

95K+

Global Learners

Virtual Instructor-Led Training

$599

Course Overview

This course gives you practical knowledge for migrating on premises SQL Server workloads to Azure SQL. It covers migration strategies, the tools you'll use, and how to optimize your databases once they're running in the cloud. The focus is on getting the migration right the first time.

Mode of Training

🏫 Classroom 💻 Live Online 🧪 Blended 👨‍👩‍👧‍👦 Private Group

Upcoming Schedules

Start Date	Time	Duration	Mode	Price
Apr 27, 2026	9:00 am - 5:00 pm	1 Day	Online	$599	GTR
May 12, 2026	9:00 am - 5:00 pm	1 Day	Online	$599	GTR
May 29, 2026	9:00 am - 5:00 pm	1 Day	Online	$599	GTR
Jun 16, 2026	9:00 am - 5:00 pm	1 Day	Online	$599	GTR
Jun 30, 2026	9:00 am - 5:00 pm	1 Day	Online	$599	GTR
Jul 15, 2026	9:00 am - 5:00 pm	1 Day	Online	$599	GTR

+ View more schedules

What you will learn

Design a SQL Server migration strategy
Assess SQL Server databases for migration to Azure SQL
Deploy PaaS solutions with Azure SQL
Configure database authentication and authorization
Migrate SQL Server workloads to Azure SQL Database
Perform post-migration tasks on Azure SQL

Who Should Attend This Course?

Database Administrator
Data Engineer
Technical Architect

Prerequisites

Experience in administering SQL Server databases.
Knowledge of SQL Server editions and versions.
Knowledge of basic T-SQL.

📞 Talk to a Learning Advisor

📘 DP-3001: Migrate SQL Server Workload To Azure SQL Outline

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

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

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

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

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