Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-800-268-7737 Other Contact Options
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

Migrate Open Source Data Workloads to Azure (DP-070T00)

New – Learn to Migrate Open Source Data Workloads to Azure

GK# 100533

Course Overview

TOP

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.

Schedule

TOP
  • Delivery Format:
  • Date:
  • Location:
  • Limited Time Offer: This course is 40% off! Use promo code 40GTR at checkout.
  • Access Period:

$

Class is Full
This session is full. Please select a different session.

What You'll Learn

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

 

Outline

TOP
Viewing outline for:

Classroom Live 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

At the end of this module, the 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


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


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


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

Labs

TOP
Viewing labs for:

Classroom Live Labs

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


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


Lab: Migrating PostgreSQL DB Workloads to Azure SQL DB

  • Configure Azure SQL DB for PostgreSQL
  • Define Source and Target DBs
  • Perform Migration
  • Verify Migration

Prerequisites

TOP

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

TOP

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.

Training Exclusives

This course comes with 12 months access to the following benefits:

  • Practice Labs
  • 24x7 Mentoring
  • Indexed Class Recordings
  • Unlimited Course Retakes
  • Digital courseware
Find out more
Course Delivery

This course is available in the following formats:

Classroom Live

Receive face-to-face instruction at one of our training center locations.

Duration: 1 day

Virtual Classroom Live

Experience live, expert-led online training from the convenience of your home, office or anywhere with an internet connection.

Duration: 1 day

Request this course in a different delivery format.
Enroll