Building a modern Data WareHouse on Microsoft Fabric

...
A discount is available when:
  • a single customer proceeds with more than three registrations for a particular session;
  • a learner is not currently employed.
Please contact us to receive your discount coupon if you meet any of the above-mentioned criteria.

Please also note that the upcoming sessions are guaranteed to run once they have a minimum number of learners registered.
Total price:
1,070.001,320.00 final price

Available Sessions

DateTimezoneTraining TypeWeekend-WeekdayDescriptionPrice 
Coming soon1,070.001,320.00 final price

Learn how to design, build and operate a modern Data WareHouse on Microsoft Fabric course will provide a comprehensive overview of data warehousing with Azure Synapse Analytics, from planning and design to implementation, maintenance and optimization. You’ll learn about key concepts like data warehouse principles, data storage data transformation and security.

Who should attend

This 32-hour course is for Data Engineers, Data Analysts and anyone who would like to learn about Data WareHousing on Microsoft Fabric.

Prerequisites

Participants should be IT Professionals having a familiarity with databases and data warehouses.

What will you learn

During this 32-hour workshop, participants will combine theory with best practices and hands-on exercises on the following topics.

  • Data Warehouse Basic Principles
    • Introduction
    • Dimension tables
    • Fact tables
    • Star Schema
    • Snowflake Schema
  • Designing a Data Warehouse solution on Azure Synapse Analytics
    • Introduction to Cloud Warehousing
    • Introduction to Azure Synapse Analytics
    • Design a Star or Snowflake schema
    • Designing Dimension tables
    • Designing Fact tables
    • Designing Data pipelines
    • Data types and Table types
    • Data Storage
    • Best practices for Fact and Dimension tables
  • Implementing a Data Warehouse on Azure Synapse Analytics
    • Implementing Dimension Tables
    • Implementing Fact Tables
    • Best practices for Loading Data
    • SQL and Apache Spark pools
    • Data warehouse developer features
    • Manage and monitor activities
    • Data warehouse optimization
    • Data warehouse security
Date

Coming soon

Timezone

Training Type

Weekend-Weekday