40517: Microsoft Cloud Workshop: Migrate EDW to Azure SQL Data Warehouse Course Overview

40517: Microsoft Cloud Workshop: Migrate EDW to Azure SQL Data Warehouse Course Overview

The 40517: Microsoft Cloud Workshop: Migrate EDW to Azure SQL Data Warehouse course is designed to equip learners with the skills and knowledge required to migrate an existing Enterprise Data Warehouse (EDW) to Azure SQL Data Warehouse. This course is divided into two modules, each with a focus on different aspects of the migration process.

In Module 1: Whiteboard Design Session, participants will engage in a collaborative environment where they will review a customer case study, design a proof of concept solution, and present their solution to their peers. This module helps learners understand the real-world scenarios and planning strategies involved in such migrations.

Module 2: Hands-on Lab is where participants get practical experience. They will configure Azure services, prepare data and schema, migrate data to Azure SQL Data Warehouse, investigate table distribution, create an Analysis Services Model, and visualize data with Power BI Desktop. This hands-on approach ensures learners can apply theoretical knowledge to actual migration tasks, providing them with the confidence to execute similar projects in their professional roles. Through this course, participants will gain a deep understanding of not just the migration process but also the optimization and analytics capabilities of Azure's data services.

Purchase This Course

Fee On Request

  • Live Training (Duration : 8 Hours)
  • Per Participant
  • Guaranteed-to-Run (GTR)
  • Classroom Training fee on request

Filter By:

♱ Excluding VAT/GST

You can request classroom training in any city on any date by Requesting More Information

  • Live Training (Duration : 8 Hours)
  • Per Participant
  • Classroom Training fee on request

♱ Excluding VAT/GST

You can request classroom training in any city on any date by Requesting More Information

Request More Information

Email:  WhatsApp:

Koenig's Unique Offerings

Target Audience for 40517: Microsoft Cloud Workshop: Migrate EDW to Azure SQL Data Warehouse

  1. This course trains participants in migrating enterprise data warehouses (EDW) to Azure SQL Data Warehouse, focusing on architects and engineers.


  2. Target Audience for Course 40517: Microsoft Cloud Workshop: Migrate EDW to Azure SQL Data Warehouse:


  • IT professionals responsible for data warehouse migrations
  • Database architects designing scalable cloud data solutions
  • Data engineers implementing data storage on Azure
  • Cloud solution architects transitioning on-premises data to Azure
  • BI developers creating reporting solutions with Power BI
  • Technical team leads overseeing cloud migration projects
  • Systems administrators involved in cloud-based server management
  • Data scientists requiring large scale data storage solutions for analysis
  • IT project managers coordinating database migration projects
  • SQL Server database administrators expanding to Azure services
  • Azure consultants providing expertise in Azure SQL Data Warehouse


Learning Objectives - What you will Learn in this 40517: Microsoft Cloud Workshop: Migrate EDW to Azure SQL Data Warehouse?

  1. Introduction to learning outcomes: The course equips students with the ability to design, migrate, and manage an Enterprise Data Warehouse (EDW) transition to Azure SQL Data Warehouse, enhancing analytics with cloud scalability.

  2. Learning Objectives and Outcomes:

  • Understand the customer case study to identify the business requirements and challenges in migrating to Azure SQL Data Warehouse.
  • Design a robust proof of concept solution that aligns with the customer's needs and Azure best practices.
  • Develop presentation skills to effectively communicate the proposed solution to stakeholders.
  • Gain hands-on experience in configuring Azure services essential for the migration process.
  • Learn data and schema preparation techniques for a successful migration to Azure SQL Data Warehouse.
  • Execute the migration of an existing EDW to Azure SQL Data Warehouse, ensuring data integrity and system compatibility.
  • Explore table distribution methods within Azure SQL Data Warehouse to optimize query performance and resource utilization.
  • Create an Analysis Services model to support advanced analytics on the migrated data warehouse.
  • Utilize Power BI Desktop to visualize data, providing insights and business intelligence from the Azure SQL Data Warehouse.
  • Acquire the skills to manage and maintain a cloud-based data warehouse solution, ensuring scalability and cost-efficiency.

Suggested Courses

USD