40514: Microsoft Cloud Workshop: Data Platform Upgrade and Migration Course Overview

40514: Microsoft Cloud Workshop: Data Platform Upgrade and Migration Course Overview

The 40514: Microsoft Cloud Workshop: Data Platform Upgrade and Migration course is an in-depth training program designed to equip learners with the knowledge and skills necessary to upgrade and migrate existing data platforms to Azure cloud services. The course is structured into two main modules.

Module 1: Whiteboard Design Session - Data platform upgrade and migration involves interactive discussions where participants review a customer case study, design a proof-of-concept solution, and then present their solution, focusing on strategies for data migration and platform upgrades.

Module 2: Hands-on Lab - Data platform upgrade and migration provides practical experience where learners deploy SQL Server instances, migrate these instances to Azure SQL Database using the Data Migration Service (DMS), and implement post-upgrade enhancements. Additionally, participants will work on setting up Oracle 11g Express Edition and migrating an Oracle database to SQL Server 2017, as well as migrating the associated application.

This course helps learners understand the intricacies of a data platform migration to Azure, ensuring they acquire the necessary skills to manage data migration and understand the benefits of upgrading to a cloud-based data solution.

This is a Rare Course and it can be take up to 3 weeks to arrange the training.

Koenig's Unique Offerings

images-1-1

1-on-1 Training

Schedule personalized sessions based upon your availability.

images-1-1

Customized Training

Tailor your learning experience. Dive deeper in topics of greater interest to you.

images-1-1

4-Hour Sessions

Optimize learning with Koenig's 4-hour sessions, balancing knowledge retention and time constraints.

images-1-1

Free Demo Class

Join our training with confidence. Attend a free demo class to experience our expert trainers and get all your queries answered.

Purchase This Course

Fee On Request

  • Live Online Training (Duration : 8 Hours)
  • Per Participant
  • Guaranteed-to-Run (GTR)
  • date-img
  • date-img

♱ Excluding VAT/GST

Classroom Training price is on request

  • Live Online Training (Duration : 8 Hours)
  • Per Participant

♱ Excluding VAT/GST

Classroom Training price is on request

Request More Information

Email:  WhatsApp:

Winner of the Microsoft’s Asia Superstar Campaign in FY 22

Course Prerequisites

To ensure that participants are prepared to successfully engage with the 40514: Microsoft Cloud Workshop: Data Platform Upgrade and Migration course, the following minimum prerequisites are recommended:


  • Basic understanding of database concepts, including relational databases and SQL (Structured Query Language).
  • Familiarity with Microsoft SQL Server and its core features.
  • Experience with database administration or development on SQL Server or another database platform.
  • Working knowledge of Microsoft Azure services, particularly Azure SQL Database and Azure Data Migration Service (DMS).
  • Some experience with or exposure to Oracle database systems would be beneficial, though not strictly required.
  • Understanding of cloud computing concepts and the differences between on-premises and cloud-based database solutions.
  • Basic familiarity with virtual machines and their role in a cloud environment.
  • Ability to navigate and use the Windows operating system, as well as a basic understanding of Windows Server administration.

These prerequisites are designed to facilitate effective learning without overwhelming participants who have the baseline knowledge outlined above. If you need to brush up on any of these areas, we recommend doing so prior to attending the workshop to maximize the benefits of the training.


Target Audience for 40514: Microsoft Cloud Workshop: Data Platform Upgrade and Migration

Course 40514: Microsoft Cloud Workshop: Data Platform Upgrade and Migration is designed for professionals seeking to modernize and migrate their data platforms to Azure.


Target audience for the course includes:


  • Database Administrators
  • Data Architects
  • IT Professionals with a focus on data management and database systems
  • Cloud Solution Architects
  • Systems Engineers
  • Technical Decision Makers evaluating data platform migrations
  • DevOps Engineers involved in database deployment and migration
  • Application Developers working with databases that need migration or upgrading
  • Data Analysts looking to understand the migration impact on data analysis
  • IT Project Managers overseeing database or cloud migration projects


Learning Objectives - What you will Learn in this 40514: Microsoft Cloud Workshop: Data Platform Upgrade and Migration?

Introduction to Course Learning Outcomes and Concepts:

The 40514: Microsoft Cloud Workshop: Data Platform Upgrade and Migration course is designed to equip students with skills for modernizing and migrating data platforms to Azure, incorporating strategies for SQL Server and Oracle database migration.

Learning Objectives and Outcomes:

  • Understand the critical considerations for upgrading and migrating legacy data platforms to modern Azure solutions.
  • Develop a comprehensive proof of concept (POC) for data platform migration that aligns with the customer's business requirements and constraints.
  • Gain proficiency in deploying SQL Server instances in preparation for migration.
  • Learn to use the Azure Database Migration Service (DMS) to effectively migrate SQL Server databases to Azure SQL Database.
  • Identify and implement post-migration enhancements to optimize performance and costs in the cloud environment.
  • Acquire the skills to set up Oracle 11g Express Edition as a precursor to migration.
  • Master the process of migrating an Oracle database to SQL Server 2017, ensuring data integrity and minimal downtime.
  • Understand how to migrate associated applications to work with the modernized database.
  • Learn to present migration solutions to stakeholders, demonstrating the business impact and technical benefits.
  • Build confidence in troubleshooting and resolving common migration challenges during the hands-on lab experience.