Your cart is empty.
Keep shopping
Data Warehouse - The Ultimate Guide
Bestseller
Role Play
73,252 students
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
Explore related topics
Course content
15 sections • 108 lectures • 9h 23m total length
Requirements
- Basic SQL is helpful but absolutely not necessary
- Laptop or PC
Description
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
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!
Who this course is for:
- Data Analyst that want to upskill and learn how to build a data warehouse
- Data Engineers that want to learn about data warehousing and data modeling
- People that want to become a data architect, BI consultant, data engineer or data analyst
- Data professionals that want to upskill in Business Intelligence & Data Modeling