Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Udemy

Data Warehouse - The Ultimate Guide

via Udemy

Overview

Master Data Warehousing, Dimensional Modeling & ETL process

What you'll learn:
  • Architect & implement a professional data warehouse end-to-end
  • You will learn the principles of Data Warehouse Design
  • You will master ETL process in both theory & practise
  • You will implement in a case study your own data warehouse & ETL process
  • You will learn the modern architecture of a Data Warehouse
  • Dimensional Modeling in a professional way

Master Data Warehousing, Dimensional Modeling & ETL process

Do you want to learn how to implement a data warehouse in a modern way?

This is the only course you need to master architecting and implementing a data warehouse end-to-end!


Data Modeling and data warehousing is one of the most important skills in Business Intelligence &Data Engineering!

This is the most comprehensive &most modern course you can find on data warehousing.


Here is why:

  • Most comprehenisve course with 9 hours video lectures

  • Learn from a real expert - crystal clear & straight-forward

  • Master theory &practice - hands-on demonstrations, assignments &quizzes

  • We will implement a complete data warehouse - end-to-end

  • Understand everything step by step from the absolute basics to the advanced topics

  • Learn the practical steps and the important theory to upskill your career

This course will take you all the way to being able to architect and implement a data warehouse in a company in a professional manner.


Here is what you'll learn:

  • Data Warehouse Basics

  • Data Warehouse architecture

  • Data Warehouse infrastructure

  • Data Modeling

  • Setting up an ETLprocess

  • Dimensional Modeling:Facts &Dimensions

  • Implementing a comeplete data warehouse hands-on

  • Slowly Changing Dimensions

  • Understanding ETLtools

  • ELTvs. ETL

  • Advanced topics like:Columnar storage, OLAPCubes, In-memory databases, massive parallel processing &cloud data warehouses

  • Optimizing a data warehouse using indexes (B-tree indexes &Bitmap indexes)

  • Practically using and connecting a data warehouse


By the end of this course you will be able to design &build a complete data warehouse from the ground up. You will have the knowledge, the practical skills and the confidence to implement a modern data warehouse professionally.

Everything you need to be a highly proficient data architect, data engineer, data analyst or Business Intelligence expert!


Join now to get instant & lifetime access - of course backed by the no-questions-asked 30 days money back guarantee!




Taught by

Nikolai Schuler

Reviews

4.6 rating at Udemy based on 7439 ratings

Start your review of Data Warehouse - The Ultimate Guide

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.