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

To ensure that participants are prepared to fully engage with and benefit from the 40517: Microsoft Cloud Workshop: Migrate EDW to Azure SQL Data Warehouse course, the following prerequisites are recommended:

• Basic understanding of cloud computing and its core services, preferably with some exposure to Microsoft Azure.
• Familiarity with data warehousing concepts and principles, including the architecture and functioning of a data warehouse.
• Knowledge of relational databases, particularly Microsoft SQL Server, and experience with database design and management.
• Experience with SQL and the ability to write T-SQL queries to manipulate and retrieve data.
• Some experience with data migration strategies and tools, especially in the context of moving data to the cloud.
• An understanding of the Extract, Transform, Load (ETL) processes and tools that facilitate data movement and integration.
• Familiarity with business intelligence (BI) solutions and concepts, such as OLAP cubes and data modeling.
• Basic proficiency with data visualization tools like Power BI or similar, for the purpose of visualizing and analyzing data.

Participants are not expected to be experts in all the above areas but should have a foundational knowledge to ensure a smooth learning experience.

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.