Microsoft/DP-050T00: Migrate SQL workloads to Azure

DP-050T00: Migrate SQL workloads to Azure Certification Training Course Overview

DP-050T00: Migrate SQL workloads to Azure training course to learn about data platform modernization and how it is suitable for given business requirements. In this training class, you will learn how to migrate to the three target platforms for SQL based workloads; Azure Virtual Machines, Azure SQL Databases and Azure SQL Database Managed Instances.

Target Audience:

This course is recommended for data professionals and data architects who want to learn about migrating data platform technologies that exist on Microsoft Azure and how existing SQL based workloads can be migrated and modernized.

DP-050T00: Migrate SQL workloads to Azure (16 Hours) Download Course Contents

Live Virtual Classroom
Group Training 900
02 - 03 Aug 09:00 AM - 05:00 PM CST
(8 Hours/Day)

06 - 07 Sep 09:00 AM - 05:00 PM CST
(8 Hours/Day)

1-on-1 Training (GTR) 1050
4 Hours
8 Hours
Week Days
Week End

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here Hire Our Trainers! Click here

Course Modules

Module 1: Introducing Data Platform Modernization
  • Understand Data Platform Modernization
  • Understanding the stages of migration
  • Data Migration Paths
  • Understand Data Platform Modernization
  • Understand the Stages of Migration
  • Data Migration Paths
Module 2: Choose the right tools for Data Migration
  • Discover the Database Migration Guide
  • Build your data estate inventory using Map Toolkit
  • Identify Migration candidates using Data Migration Assistant
  • Evaluate a Data workload using Database Experimentation Assistant
  • Data Migration using Azure Database Migration Service
  • Migrate non-SQL Server workloads to Azure using SQL Migration Assistant
  • Identify Migration candidates using Data Migration Assistant
  • Evaluate a Data workload using Database Experimentation Assistant
Module 3: Migrating SQL Workloads to Azure Virtual Machines
  • Considerations of SQL Server to Azure VM Migrations
  • SQL Workloads to Azure VM Migration Options
  • Implementing High Availability and Disaster Recovery Scenarios
  • Migrating SQL Workloads to Azure Virtual Machines
Module 4: Migrate SQL Workloads to Azure SQL Databases
  • Choose the right SQL Server Instance option in Azure
  • Migrate SQL Server to Azure SQL DB offline
  • Migrate SQL Server to Azure SQL DB online
  • Load and Move data to Azure SQL Database
  • Migrate SQL Workloads to Azure SQL Databases
Module 5: Migrate SQL Workloads to Azure SQL Database Managed Instance
  • Evaluate migration scenarios to SQL Database Managed Instance
  • Migrate to SQL Database Managed instance
  • Load and Move data to SQL Database Managed instance
  • Application Configuration and Optimization
  • Migrate SQL Workloads to Azure SQL Database Managed Instance
Download Course Contents

Request More Information

Course Prerequisites

Successful students start this role with a fundamental knowledge of cloud computing concepts and professional experience in implementing SQL solutions.

Specifically:

  • Working with and maintaining SQL workloads
  • Experience with Azure, such as deploying and managing resources

 

Upon Completion of this Course, you will accomplish following: 

  • Understand Data Platform Modernization
  • Choose the right tools for Data Migration
  • Migrate SQL Workloads to Azure Virtual Machines
  • Migrate SQL Workloads to Azure SQL Databases
  • Migrate SQL Workloads to Azure SQL Database Managed Instance