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

Name: DP-070: Migrate Open Source Data Workloads to Azure Training
Brand: Microtek Learning
Price: 654 USD
Rating: 5 (1643 reviews)

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.

📘 Azure 👥 1643 Enrolled ⏱️ 1 Day 💼 Intermediate Level ⭐ 5 | 113 Reviews

Why Microtek Learning?

500+

Courses

10+ Years

Experience

95K+

Global Learners

Virtual Instructor-Led Training

$654

Course Overview

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.

Mode of Training

🏫 Classroom 💻 Live Online 🧪 Blended 👨‍👩‍👧‍👦 Private Group

What you will learn

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

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.

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

📞 Talk to a Learning Advisor

📘 DP-070: Migrate Open Source Data Workloads to Azure Outline

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

Still have questions?

Reach out to our learning advisors for personalized guidance on choosing the right course, group training, or enterprise packages.

📞 Talk to an Advisor

What You Get with Microtek Learning

Instructor-Led Excellence

✓ Certified Instructor-led Training
✓ Top Industry Trainers
✓ Official Student Handbooks

Measurable Learning Outcomes

✓ Pre- & Post-Training Assessments
✓ Practice Tests
✓ Exam-Oriented Curriculum

Real-World Skill Building

✓ Hands-on Activities & Scenarios
✓ Interactive Online Courses
✓ Peer Collaboration (Not in self-paced)

Full Support & Perks

✓ Exam Scheduling Support ^*
✓ Learn & Earn Program ^*
✓ Support from Certified Experts
✓ Gov. & Private Pricing ^*

Our Clients

For over 10 years, Microtek Learning has helped organizations, leaders, students and professionals to reach their maximum potential. We have led the path by addressing their challenges and advancing their performances.