LANTEC Logo
Lantec | Course: DP 070 - Migrate Open Source Data Workloads to Azure

DP 070 - Migrate Open Source Data Workloads to Azure

$595.00
1 days
Audience
Prerequisites

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.

OUTLINE:

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
Labs
  • Creating source OSS databases
    • Installation of Postgres migration DB server
    • Installation of MySQL migration DB server
    • Backups / data dumps from Postgres / MySQL
    • Restore from data dumps
After completing this module, students will be able to:
  • 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
Labs
  • Migrating MySQL DB Workloads to Azure SQL DB
    • Migrating MySQL DB Workloads to Azure SQL DB
    • Define Source and Target DBs
    • Perform Migration
    • Verify Migration
After completing this module, students will be able to:
  • 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
Labs
  • Migrating PostgreSQL DB Workloads to Azure SQL DB
    • Configure Azure SQL DB for PostgreSQL
    • Define Source and Target DBs
    • Perform Migration
    • Verify Migration
After completing this module, students will be able to:
  • Configure and Manage Azure SQL DB for PostgreSQL
  • Migrate on-premises MySQL to SQL DB for PostgreSQL
  • Application Migration
  • Post-migration considerations

Scheduled Courses

This course isn't currently on the schedule, but we can add it. Just let us know.

Need to Request This Course On a Different Day?

LANTEC is very responsive to local client needs and unique or custom class demands. If you require a delivery date option for a class title on our schedule, please submit your specific request for immediate consideration. We can often accommodate countless additional courses NOT available on our public schedules, please inquire for personal assistance.
Want to schedule it?


Misty Ellison, ISG

LANTEC's entire team worked beautifully with all of ISG's staff. They were accommodating, communicative, and provided first class instruction. I cannot say enough great things about the staff at LANTEC, we were extremely satisfied by the assistance given throughout the life of our grant.