EDW to Azure SQL Data Migration: 1-Day Workshop
Dynamics Edge
In this workshop, you will migrate an existing data warehouse from an on-premises SQL Server into Azure SQL Data Warehouse.
In this workshop, you will migrate an existing data warehouse from an on-premises SQL Server into Azure SQL Data Warehouse.
This 1-day, instructor-led workshop is intended for data professionals who want to want to learn more about Azure and Azure services. In this workshop, you will migrate a retail chain from an existing data warehouse in an on-premises SQL Server into Azure SQL Data Warehouse. Prepare a detailed migration plan including data preparation, importing data into Azure SQL Data Warehouse, and architecting a data orchestration strategy to move data from the existing on-premises source systems to Azure SQL Data Warehouse.
What You’ll Learn
- Configure a Data Management Gateway to access on-premises data sources from Azure
- Configure Power BI Dashboards to leverage data stored in Azure SQL Data Warehouse
Prerequisites
- Workshop content presumes 300-level of architectural expertise of infrastructure and solutions design.
- We suggest students take a Microsoft Azure Essentials course prior to attending this workshop.
Workshop Outline
Module 1: Whiteboard Design Session - Migrate EDW to Azure SQL Data Warehouse
- Review the customer case study
- Design a proof of concept solution
- Present the solution
Module 2: Hands-on Lab - Migrate EDW to Azure SQL Data Warehouse
- Configure Azure services
- Data and schema preparation
- Migrate the data to Azure SQL Data Warehouse
- Integrate Azure SQL Data Warehouse and On-Premises Data Sources with Azure Data Factory and Power BI
