Course HighlightsCOURSE
DP-050: Migrate SQL workloads to Azure

DP-050: Migrate SQL workloads to Azure

Explore data platform modernization. Learn how it works for given business requirements and become familiar with each stage of the data platform modernization process.

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

DP-050: Migrate SQL workloads to Azure Highlights

Course Enrollment

Starts on

15 September 2022

Enrollment closes on
21 August 2022

  Course duration

Duration

  • 2 days, online
    8 hours/day
  Course Fee

Fee

US$ 1,110

Course Enrollment

Starts on

15 September 2022

Enrollment closes on
21 August 2022

Course duration

Duration

  • 2 days, online
    8 hours/day
Course Fee

Fee

US$ 1,110

DP-050 is a two-day intermediate-level course for data professionals who define data platform modernization and identify business requirements.

During this DP-050 course you will learn about the various stages, technologies, and paths involved in a data platform migration. You will explore how migration paths differ and discover how to assess the best option for your project. You will also build your understanding and knowledge of the various migration tools that can be used to assess compatibility and workload issues using Microsoft Data Migration Assistant and Database Experimentation Assistant.

Additionally, you will learn how to migrate SQL workloads to Azure VM, Azure SQL Databases and managed instances. Plus, you will build your understanding of how to implement high availability and disaster recovery SQL Server workloads to ensure service continuity including offline and online migrations.

Overall, this course will prepare you for taking the DP-050: Migrate NoSQL 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 5 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:

  • Understand Data Platform Modernization.
  • Be able to choose the right tools for data migration.
  • Be able to migrate SQL workloads to Azure Virtual Machines.
  • Be able to migrate SQL workloads to Azure SQL Databases.
  • Be able to migrate SQL workloads to an Azure SQL Database Managed Instance.
  • Data architects.
  • Database administrators.
  • Data professionals.

To enroll in this course you need to have a fundamental knowledge of cloud computing concepts and professional experience in implementing SQL solutions.

Specifically:

  • Working with, and maintaining, SQL workloads.
  • Experience with Azure, such as deploying and managing resources.

This course will help you to prepare for the DP-050: Migrate SQL Workloads to Azure certification exam.

In this course, you will explore the objectives of data platform modernization and how it is suitable for given business requirements.

  • You will become familiar with each stage of the data platform modernization process and be able to define what tasks are involved at each stage, such as the assessment and planning phases.
  • You will learn how to migrate to the three target platforms for SQL based workloads; Azure Virtual Machines, Azure SQL Databases and Azure SQL Database Managed Instances.
  • You will explore the changes that may need to be made to existing SQL based applications so they can make best use of modern data platforms in Azure.

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

Enrollment is Closed
Introduction
Grading Scheme
Pre-Requisite
Exam and Certification Details
About this module
Understand Data Platform Modernization
Understand the stages of migration
Understand data migration technologies
Knowledge Check
About this module
Discover the Database Migration Guide
Identify migration candidates using Data Migration Assistant
Evaluate data workload using Database Experimentation Assistant
Data migration using Azure Database Migration Service
Migrate non-SQL Server workloads to Azure using SQL Migration Assistant
Knowledge Check
About this module
Considerations of SQL Server to Azure VM migrations
SQL workloads to Azure VM migration options
Implement high availability and disaster recovery scenarios
Knowledge Check
About this module
Considerations for migrating to Azure SQL Database
Migrate to Azure SQL Database
Service continuity of Azure SQL Database
Knowledge Check
About this module
What is Azure SQL Database managed instance
Migrate to Azure SQL Database managed instance
Synchronize data to Azure SQL Database managed instance
Knowledge Check
Course Certificate

Earn your certificate

Once you have completed this course, you will earn your certificate.

Preview digital certificate
DP-050: Migrate SQL workloads to Azure
Enrollment is Closed

FAQs

You can become certified in DP-050: Migrating SQL Workloads to Azure by following the below listed steps:

Step 1: Complete recommended training for DP-050: Migrating SQL 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 Migrating SQL Workloads to Azure exam, and schedule it with Pearson VUE.

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

To benefit the most from this course, you should have a fundamental knowledge of cloud computing concepts, and you should know how to work with and maintain SQL workloads. You should also be able deploy and manage resources on Azure.

This DP-050 course will prepare you for the role of a data engineer. Through this course, you will understand data platform modernization and how to choose the right tools for data migration. You will also gain knowledge of how to migrate to the three target platforms for SQL based workloads: Azure Virtual Machines, Azure SQL Databases, and Azure SQL Database Managed Instances. Plus, this course will prepare you for taking the DP-050 certificate exam. You’ll get tips from our Microsoft Certified Trainer and you’ll have access to practice papers and knowledge checks.

Yes! This DP-050 online training will explain the concepts required to prepare you for the DP-050 exam. This course will guide you through the benefits and limitations of each target platform and its usage for business, as well as the technical requirements for modern SQL workloads. You will explore the changes that may be needed for existing SQL-based applications so that they can make the best use of modern data platforms in Azure. Plus, because this is an instructor-led course, you will be able to ask our Microsoft Certified Trainer questions as you learn.   

Absolutely, yes. DP-050 certification is ideal for individuals who have technical knowledge equivalent to Azure and prior experience in working with SQL Server. This course will prepare you for the role of a data engineer. Moreover, the DP-050 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).