Microsoft

Course DP-070T00-A: Migrate Open Source Data Workloads to Azure

Course DP-070T00-A: Migrate Open Source Data Workloads to Azure

Share This Learning Path

Need more info? Contact us

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.

Audience Profile

The primary audience for this course is database developers who plan to migrate their MySQL or Postgres DB workloads to Azure SQL DB. The secondary audience for this course is MySQL/Postgres administrators to raise awareness of the features and benefits of Azure SQL DB.

Prerequisites

  • Successful students start this role with a fundamental knowledge of cloud computing concepts and experience with open source relational database management systems.
  • Specifically: Working with PostgreSQL and/or MySQL, Using backup and recovery techniques with open source data, SQL administration.
  • To gain these skills, take the following free online training before attending the course: Core cloud services – Azure compute options, Deploy MariaDB, MySQL, and PostgreSQL on Azure, Introduction to Azure SQL, Introduction to open source database migration to Azure Cosmos DB.

Course outline

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

Module Overview

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

Lessons

OSS databases overview
Common OSS database workloads
Customer challenges in migration

Lab Sessions

Creating source OSS databases

Lab Lessons

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

Module Overview

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

Lab Sessions

Migrating MySQL DB Workloads to Azure SQL DB

Lab Lessons

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

Module Overview

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

Lab Sessions

Migrating PostgreSQL DB Workloads to Azure SQL DB

Lab Lessons

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.

Book Your Seat​

Find Learning Paths​

  • Search Paths

  • Vendors

Latest Learning Paths​

Join our community of certified professionals

Sign Up to our newsletter, and stay always up to date with latest IT certifications

About Us

ICTC is the leader in technical certification courses and exams. Our labs consist of a latest tech PCs and our instructors are certified from each vendor

Facebook Linkedin

Learn

View all the provided certifications and there relevant courses. Book online for a certification exam.

Explore

Contact Us

International Computer Training Center

Copyright reserved to ICTC. Proudly Crafted by GTP Works

Choose how to get more info...

Give as a call

211 500 2 900

Let us, call you

Send us an email