Migrate Open Source Data Workloads to Azure

Unlock the power of Azure SQL Database migration with our Migrate Open Source Data Workloads to Azure course, tailored for database developers and administrators seeking to seamlessly transition MySQL and PostgreSQL workloads.

Course Category Icon

Essential Skills Gained

Checkmark

Assess an existing enterprise environment.

Checkmark

Plan and implement Policy-Based Management.

Checkmark

Describe the considerations for consolidating workloads with SQL Server 2014.

Checkmark

Describe considerations for including SQL Server 2014 in a private cloud.

Format

  • Instructor-led
  • 1 days with lectures and hands-on labs.

Audience

  • Database developers
  • MySQL/Postgres administrators

Description

This course will enable the students to understand Azure SQL Database, and educate the students on what is required to migrate MySQL and PostgreSQL workloads to Azure SQL Database.

Calendar icon

Upcoming Course Dates

No upcoming dates. Please check back later.

Course Outline

Download PDF

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

  1. OSS Databases Overview

  2. Common OSS Database Workloads

  3. Customer Challenges in Migration

Lab: Creating Source OSS Databases

  1. Installation of Postgres Migration DB Server

  2. Installation of MySQL Migration DB Server

  3. Backups/Data Dumps from Postgres / MySQL

  4. Restore from Data Dumps

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

  1. Configure and Manage Azure SQL DB for MySQL

  2. Migrate on-premises MySQL to SQL DB for MySQL

  3. Application Migration

  4. Post-migration Considerations

Lab: Migrating MySQL DB Workloads to Azure SQL DB

  1. Migrating MySQL DB Workloads to Azure SQL DB

  2. Define Source and Target DBs

  3. Perform Migration

  4. Verify Migration

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

  1. Configure and Manage Azure SQL DB for PostgreSQL

  2. Migrate on-premises MySQL to SQL DB for PostgreSQL

  3. Application Migration

  4. Post-migration Considerations

Lab: Migrating PostgreSQL DB Workloads to Azure SQL DB

  1. Configure Azure SQL DB for PostgreSQL

  2. Define Source and Target DBs

  3. Perform Migration

  4. Verify Migration

Your Team has Unique Training Needs.

Your team deserves training as unique as they are.

Let us tailor the course to your needs at no extra cost.