DP-070: Migrate Open Source Data Workloads to Azure

The course is intended for database developers who would like to migrate their MySQL and / or PostgreSQL workloads to the Azure SQL Database service. Or for MySQL and PostgreSQL database administrators who are interested in understanding the features and benefits of Azure’s services. 

The course is great for expanding knowledge about the benefits that Azure offers when migrating and maintaining workloads in Azure SQL Database. 

• Working with PostgreSQL and/or MySQL
• Using backup and recovery techniques with open-source data
• SQL administration

Module 1: Migrate to Azure SQL DB for MySQL & PostgreSQL 

This module describes the benefits and architecture of Azure SQL DB. 

Lessons 

• OSS databases overview 
• Common OSS database workloads 
• Customer challenges in migration
  

Module 2: Migrate on-premises MySQL to Azure SQL DB for MySQL 

This module describes the benefits and process of migrating MySQL workloads to Azure SQL DB 

Lessons 

• Configure and Manage Azure SQL DB for MySQL 
• Migrate on-premises MySQL to SQL DB for MySQL 
• Application Migration 
• Post-migration considerations
  

Module 3: Migrate on-premises PostgreSQL to Azure SQL DB for PostgreSQL 

This module describes the benefits and process of migrating PostgreSQL DB workloads to Azure SQL DB 

Lessons 

• Configure and Manage Azure SQL DB for PostgreSQL 
• Migrate on-premises MySQL to SQL DB for PostgreSQL 
• Application Migration 
• Post-migration considerations