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

How it works

Registration

You may enroll in the course by providing your full name and email address through our website's 'add to cart' feature or by sending an email to hello@learningactors.com. We treat your personal data, including your full name and email address, with strict confidentiality.

Payment Options

We offer multiple payment methods, including credit cardbank transfer, and PayPal. To receive your invoice, please provide your VAT number (when applicable), address, and zip code. Again, you may provide us with this information either through our website's 'add to cart' feature or by sending an email to hello@learningactors.com. Please note that you can typically expect to receive your invoice on the first day of training, unless there are exceptional circumstances that necessitate a different approach. We’re happy to provide you with a pro-forma invoice if this meets your needs.

Expectations

Following registration, you can anticipate an info email from us approximately one week before the course start date. This email will contain course details, such as the title, date, and time, along with a request to complete a pre-course form. Additionally, we will provide the relevant Zoom link, which is  applicable for all our virtual-live courses, and will invite you to the course's Slack channel on the LA Slack workspace (learningactors.slack.com). For specific courses, you will also receive a preparation email that will set you ready for the course.
Finally, after the session concludes, we kindly request that you take a moment to provide us with your feedback, as it is of great importance to us. Additionally, we will ensure that you receive the learning material through Slack, which will be instrumental in keeping your learning journey on track!

Reminders

  • Discounts are available in two scenarios: when a single customer registers for more than three sessions or if the customer is currently unemployed. Contact the LA team to receive a discount coupon if you meet these criteria.
  • All upcoming sessions displayed on our website are guaranteed to proceed once the minimum required number of learners register. In the case that we must cancel a session, a full refund will be issued to those who have pre-paid for that specific session.