Microtek Learning Logo

DP-070: Migrate Open Source Data Workloads to Azure Training

5
(5)

This training qualifies the individual to learn Azure SQL Database and trains them on migrating MySQL and PostgreSQL workloads to SQL Database. This course is based on the objectives of the course version DP-070T00-A.

  • Accredited By : Microsoft Partner Logo
  • Category : Azure

Course Price : $595 Per Participant

Course Description

Note: This course is retired on January 31, 2023.

This training qualifies the individual to learn Azure SQL Database and trains them on migrating MySQL and PostgreSQL workloads to SQL Database.

This course is based on the objectives of the course version DP-070T00-A.

Microsoft Course Microsoft Course
500+

Courses

experience experience
20+

Years of Experience

learners learners
95K+

Global Learners

What you will learn

  • green-tick Migrate on-premises MySQL to Azure SQL DB for MySQL
  • green-tick Migrate on-premises PostgreSQL to Azure SQL DB for PostgreSQL

Prerequisites

Some knowledge of open-source relational database management systems such as Postgres and/or MySQL, SQL administration, backup and recovery techniques, i.e. dumping table data

Who should attend this course?

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.

Microsoft Learning PartnerMicrosoft Learning Partner

Microtek Learning is a Microsoft Certified Partner for Learning Solutions. This class uses official Microsoft courseware and will be delivered by a Microsoft Certified Trainer (MCT).

Schedules

Oops! For this course, there are currently no public schedules available. Clicking on "Notify Me" will allow you to express your interest.

For dates, times, and location customization of this course, get in touch with us.

You can also speak with a learning consultant by calling 800-961-0337.

Curriculum

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

Lesson

  • OSS databases overview
  • Common OSS database workloads
  • Customer challenges in migration
  • Lab: 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
  • At the end of this module, the students will be able to:

  • OSS databases overview
  • Common OSS database workloads
  • Customer challenges in migration
  • This module describes the benefits and process of migrating MySQL workloads to Azure SQL DB

    Lesson

  • Configure and Manage Azure SQL DB for MySQL
  • Migrate on-premises MySQL to SQL DB for MySQL
  • Application Migration
  • Post-migration considerations
  • Lab: 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
  • At the end of this module, the 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
  • This module describes the benefits and process of migrating PostgreSQL DB workloads to Azure SQL DB

    Lesson

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

  • Configure Azure SQL DB for PostgreSQL
  • Define Source and Target DBs
  • Perform Migration
  • Verify Migration
  • At the end of this module, the 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
  • Course Details

    • skill skill-green
      Skill Level: Intermediate
    • enroll enroll-green
      Enrolled: 1643
    • duration duration green
      Duration: 1 Day

    Talk to Learning Advisor