Data Warehouse - The Ultimate Guide

About this course

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 ETL process

• Dimensional Modeling: Facts & Dimensions

• Implementing a comeplete data warehouse hands-on

• Slowly Changing Dimensions

• Understanding ETL tools

• ELT vs. ETL

• Advanced topics like: Columnar storage, OLAP Cubes, 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

 

 

About Certificate

This certificate above verifies that Stefan Troehler successfully completed the course Data Warehouse - The Ultimate Guide on 06/26/2023 as taught by Nikolai Schuler on Udemy. The certificate indicates the entire course was completed as validated by the student. The course duration represents the total video hours of the course at time of most recent completion.