> > > DP-050

Migrate SQL workloads to Azure (DP-050)

 

Who should attend

The audience for this course is data professionals and data architects who want to learn about migrating data platform technologies that exist on Microsoft Azure and how existing SQL based workloads can be migrated and modernized. The secondary audience for this course is individuals who manage data platforms or develop applications that deliver content from the existing data platform technologies.

Prerequisites

In addition to their professional experience in SQL Server, students who take this training should have technical knowledge equivalent to the following courses:

Microsoft Azure Fundamentals (AZ-900)

Course Objectives

After completing this course, students will be able to:

  • Understand Data Platform Modernization
  • Choose the right tools for Data Migration
  • Migrate SQL Workloads to Azure Virtual Machines
  • Migrate SQL Workloads to Azure SQL Databases
  • Migrate SQL Workloads to Azure SQL Database Managed Instance

Course Content

In this course, the students will explore the objectives of data platform modernization and how it is suitable for given business requirements. They will also explore each stage of the data platform modernization process and define what tasks are involved at each stage, such as the assessment and planning phase. Students will also learn the available migration tools and how they are suitable for each stage of the data migration process. The student 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. The student will learn the benefits and limitations of each target platform and how they can be used to fulfil both business and technical requirements for modern SQL workloads. The student will explore the changes that may need to be made to existing SQL based applications, so that they can make best use of modern data platforms in Azure.

Classroom Training

Duration 2 days

Online Training

Duration 2 days

 
Click on town name to book Schedule
Africa
Egypt
24/11/2019 - 25/11/2019 Online Training Time zone: Africa/Cairo Course language: English
26/01/2020 - 27/01/2020 Cairo Course language: English
09/02/2020 - 10/02/2020 Online Training Time zone: Africa/Cairo Course language: English
19/04/2020 - 20/04/2020 Cairo Course language: English
03/05/2020 - 04/05/2020 Online Training Time zone: Africa/Cairo Course language: English
19/07/2020 - 20/07/2020 Cairo Course language: English
02/08/2020 - 03/08/2020 Online Training Time zone: Africa/Cairo Course language: English
18/10/2020 - 19/10/2020 Cairo Course language: English
01/11/2020 - 02/11/2020 Online Training Time zone: Africa/Cairo Course language: English

Fast Lane Flex™ Classroom If you can't find a suitable date, don't forget to check our world-wide FLEX™ training schedule.

Middle East
United Arab Emirates
24/11/2019 - 25/11/2019 Online Training Time zone: Asia/Dubai Course language: English This course is being delivered by iTLS.
26/01/2020 - 27/01/2020 Dubai Course language: English This course is being delivered by iTLS.
09/02/2020 - 10/02/2020 Online Training Time zone: Asia/Dubai Course language: English This course is being delivered by iTLS.
19/04/2020 - 20/04/2020 Dubai Course language: English This course is being delivered by iTLS.
03/05/2020 - 04/05/2020 Online Training Time zone: Asia/Dubai Course language: English This course is being delivered by iTLS.
19/07/2020 - 20/07/2020 Dubai Course language: English This course is being delivered by iTLS.
02/08/2020 - 03/08/2020 Online Training Time zone: Asia/Dubai Course language: English This course is being delivered by iTLS.
18/10/2020 - 19/10/2020 Dubai Course language: English This course is being delivered by iTLS.
01/11/2020 - 02/11/2020 Online Training Time zone: Asia/Dubai Course language: English This course is being delivered by iTLS.
Europe
Germany
02/12/2019 - 03/12/2019 Frankfurt
20/01/2020 - 21/01/2020 Munich
27/01/2020 - 28/01/2020 Hamburg
10/02/2020 - 11/02/2020 Hamburg
16/03/2020 - 17/03/2020 Münster
30/03/2020 - 31/03/2020 Münster
20/04/2020 - 21/04/2020 Düsseldorf
11/05/2020 - 12/05/2020 Berlin
Croatia
07/09/2020 - 08/09/2020 FLEX training This is an English language FLEX course.
Time zone: Europe/Zagreb
Czech Republic
13/07/2020 - 14/07/2020 FLEX training This is an English language FLEX course.
Time zone: Europe/Prague
Italy
24/02/2020 - 25/02/2020 Milan
25/05/2020 - 26/05/2020 Rome
31/08/2020 - 01/09/2020 Milan
09/11/2020 - 10/11/2020 Rome
Poland
11/05/2020 - 12/05/2020 FLEX training This is an English language FLEX course.
Time zone: Europe/Warsaw
Romania
30/03/2020 - 31/03/2020 FLEX training This is an English language FLEX course.
Time zone: Europe/Bucharest
Serbia
10/02/2020 - 11/02/2020 FLEX training This is an English language FLEX course.
Time zone: Europe/Belgrade
Slovenia
11/05/2020 - 12/05/2020 FLEX training This is an English language FLEX course.
Time zone: Europe/Ljubljana
Spain
18/11/2019 - 19/11/2019 Online Training Time zone: Europe/Madrid Course language: English
20/01/2020 - 21/01/2020 Madrid Course language: English
03/02/2020 - 04/02/2020 Online Training Time zone: Europe/Madrid Course language: English
14/04/2020 - 15/04/2020 Madrid Course language: English
27/04/2020 - 28/04/2020 Online Training Time zone: Europe/Madrid Course language: English
06/07/2020 - 07/07/2020 Madrid Course language: English
20/07/2020 - 21/07/2020 Online Training Time zone: Europe/Madrid Course language: English
21/09/2020 - 22/09/2020 Madrid Course language: English
05/10/2020 - 06/10/2020 Online Training Time zone: Europe/Madrid Course language: English
Switzerland
16/12/2019 - 17/12/2019 Zurich
16/12/2019 - 17/12/2019 Basel
16/12/2019 - 17/12/2019 Bern
25/05/2020 - 26/05/2020 Zurich
This computer icon in the schedule indicates that this date/time will be conducted as Instructor-Led Online Training.
This is a FLEX course, which is delivered both virtually and in the classroom.