DP-070: Migrate Open Source Data Workloads to Azure

Loading...
icon

icon
Loading...
course-icon

Course

org-logo
DP-070: Migrate Open Source Data Workloads to Azure

DP-070: Migrate Open Source Data Workloads to Azure

Build critical skills using Azure SQL Database. Learn how to migrate MySQL and PostgreSQL workloads to Azure SQL Database.

Benefit from instructor-led preparation for the DP-070 certification exam with tips, tricks, guidance, and mentored support.

vILT

Mentored

BEGINNER

flag-icon

Starts on

Jan 23, 2023

time-icon

Duration

1 days, online
8 hours/day
fee-icon

Fee

Loading...

DP-070: Migrate Open Source Data Workloads to Azure is a one-day intermediate-level course for database developers and MySQL/Postgres administrators. You will learn about Azure SQL Database and the requirements for migrating open-source data workloads, i.e. MySQL and PostgreSQL to Azure SQL Database.

During the course you will become familiar with open-Source databases (OSS) and the architecture of Azure SQL DB. You will explore the challenges customers face during migration. You will discover how to install MySQL and Postgres migration DB servers. You will investigate backups/database dumps from MySQL/Postgres and how to restore from database dumps. Plus, you will learn how to migrate on-premises MySQL and PostgreSQL to Azure SQL, including the configuration, source and target DBs, and post-migration considerations.

Overall, this course will help you to prepare for the DP-070: Migrate Open Source Data Workloads to Azure certification exam. Entry for the exam is not included. However, you will get a clear overview of the Microsoft certification process, plus you will get tips and tricks, testing strategies, practice questions, and useful information to help you pass the exam successfully.

This course comprises 3 purposely designed modules that take you on a carefully defined learning journey.

It is an instructor-led course which runs to a fixed schedule, with set start and finish dates. It is driven forward by your instructor and features live sessions that are aired at a set time. You will, however, have time to complete certain activities at your own pace outside of the live sessions.

The materials for each module are accessible from the start of the course and will remain available for the duration of your enrollment. Methods of learning and assessment will include reading material, hands-on labs, and online exam questions.

As part of our mentoring service you will have access to valuable guidance and support throughout the course. We provide a dedicated discussion space where you can ask questions, chat with your peers, and resolve issues.

Once you have successfully completed the course, you will earn your Certificate of Completion.

After completing this course, you will be able to:

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

  • Database developers.
  • Data engineers.
  • Database professionals.
  • MySQL/Postgres administrators.

To enroll in this course you need to have a fundamental knowledge of cloud computing concepts and experience with open source relational database management systems.

  • Working with PostgreSQL and/or MySQL.
  • Using backup and recovery techniques with open source data.
  • SQL administration.

This course will help you to prepare for the DP-070: Migrate Open Source Data Workloads to Azure certification exam.

The course will introduce you to Azure SQL Database, and build your understanding of what is required to migrate MySQL and PostgreSQL workloads to Azure SQL Database.

  • You will become familiar with Azure SQL Database.
  • You will learn how you can migrate MySQL and PostgreSQL workloads to Azure SQL Database.

When you take this course, you will also get information and guidance on the Microsoft certification process, knowledge checks and practice questions, and useful tips on how to pass the exam.

Course Outline

Why Learn with SkillUp Online?

We believe every learner is an individual and every course is an opportunity to build job-ready skills. Through our human-centered approach to learning, we will empower you to fulfil your professional and personal goals and enjoy career success.

tick

Reskilling into tech? We’ll support you.

tick

Upskilling for promotion? We’ll help you.

tick

Cross-skilling for your career? We’ll guide you.

icon

Personalized Mentoring & Support

1-on-1 mentoring, live classes, webinars, weekly feedback, peer discussion, and much more.

icon

Practical Experience

Hands-on labs and projects tackling real-world challenges. Great for your resumé and LinkedIn profile.

icon

Best-in-Class Course Content

Designed by the industry for the industry so you can build job-ready skills.

icon

Job-Ready Skills Focus

Competency building and global certifications employers are actively looking for.

Course Details

certificate

Type of certificate

Certificate of Completion

course

About this course

03 Modules

03 Skills

includes

Includes

Discussion space

01 Labs

03 Knowledge checks

01 Practice exam

exercises

Exercises to explore

OSS databases

Azure SQL DB

MySQL

PostgreSQL

You’ll learn with these experts

profile-image

Microsoft

This course is led by experienced Microsoft Certified Trainers (MCTs).

Newsletters & Updates

Subscribe to get the latest tech career trends, guidance, and tips in your inbox.

FAQs

You can become certified in DP-070: Migrate Open Source Data Workloads to Azure by following these steps:

Step 1: Complete recommended training for DP-070: Migrate Open Source Data Workloads to Azure with a Microsoft authorized training partner. SKillUp Online is a Microsoft authorized training partner.

Step 2: After completing the training, visit Microsoft's official website. Register for the Migrate Open Source Data Workloads to Azure exam, and schedule it with Pearson VUE.

Step 3: Take the exam, pass it, and get certified!

To get the most from this Microsoft training, you should have a fundamental knowledge of cloud computing concepts. You should be able to deploy MariaDB, MySQL, and PostgreSQL on Azure. And you should have prior knowledge of Azure SQL and open-source database migration to Azure Cosmos DB.

This course will help you to migrate on-premises MySQL to Azure SQL DB for MySQL and on-premises PostgreSQL to Azure SQL DB for PostgreSQL.

Also, this course will help you to prepare for the DP-070 certification exam.

Yes, it absolutely will. This DP-060 online training will explain the concepts required to prepare you for the DP-060 Migrate NoSQL Workloads to Azure Cosmos DB exam. Plus, because its an instructor-led course, youll get all sorts of tips and help regarding the exam from our Microsoft Certified Trainer, along with practice papers and knowledge checks to ensure your skills are developing in the right way.

Yes, the DP-070 online training will explain the concepts required to prepare you for the DP-070: Migrate Open Source Data Workloads to Azure exam. You will benefit from practice papers, knowledge checks, hands-on labs, and tips on taking the exam from our Microsoft Certified Trainer.

Absolutely! DP-070: Migrate Open Source Data Workloads to Azure certification is ideal for individuals who have technical knowledge equivalent to Azure and prior experience in SQL Server. This course will prepare you for the role of data engineer. Moreover, the DP-070 exam will also prepare you for taking associate level courses in the future.

If you sign up with SkillUp Online, our Microsoft Certified Trainers (MCTs) will walk you through all the modules as per the Microsoft Official Curriculum (MOC). Theyll also be there to answer your questions as you learn.

DP-070: Migrate Open Source Data Workloads to Azure

Course Details

certificate

Type of certificate

Certificate of Completion

course

About this course

03 Modules

03 Skills

includes

Includes

Discussion space

01 Labs

03 Knowledge checks

01 Practice exam

exercises

Exercises to explore

OSS databases

Azure SQL DB

MySQL

PostgreSQL

You’ll learn with these experts

profile-image

Microsoft

This course is led by experienced Microsoft Certified Trainers (MCTs).

Newsletters & Updates

Subscribe to get the latest tech career trends, guidance, and tips in your inbox.