. DP-3001: Migrate SQL Server workloads to Azure SQL

Course Information

Course Name

DP-3001: Migrate SQL Server workloads to Azure SQL

Duration

1 Day

Overview

You’ll learn how to assess SQL Server components and compatibility for migration using the Azure SQL Migration Extension and Database Migration Assistant. You’ll also learn how to provision and configure Azure SQL resources. You’ll gain hands-on experience in choosing the best migration option to meet business requirements for downtime, handling migration state, and monitoring database migration.

Additionally, you’ll also learn to perform post-migration tasks like disaster recovery and monitoring. These skills are essential for ensuring a smooth, efficient transition to Azure SQL, and maintaining its operation post-migration.

Audience Profile

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.

At Course Completion

In this module, you’ll:

• 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 Databas.

• 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.

Course Outline

Module 1: Design a SQL Server migration strategy

Module 2: Assess SQL Server databases for migration to Azure SQL

Module 3: Deploy IaaS solutions with Azure SQL

Module 4: Deploy PaaS solutions with Azure SQL

Module 5: Migrate SQL Server workloads to Azure Virtual Machine

Module 6: Migrate SQL Server workloads to Azure SQL Database

Module 7: Migrate SQL Server workloads to Azure SQL Managed Instance

Module 8: Perform post-migration tasks on Azure SQL

All Microsoft certification courses are conducted by certified trainers from Iverson.

Digital Methods acts as the official training partner and assists with program consultation, registration, coordination, scheduling, and administrative arrangements to ensure a seamless and professionally managed training experience.