Data Warehouse – The Ultimate Guide
About 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
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!
What Will You 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
Course Content
Subtitle Guide – Hướng dẫn thêm phụ đề
01 – Intro
02 – Data Warehouse Basics
03 – Data Warehouse Architecture
-
-
06:27
-
07:22
-
03:39
-
06:27
-
06:23
-
06:48
-
07:47
-
07:29
-
04:29
04 – Dimensional Modeling
-
-
03:26
-
04:34
-
05:03
-
04:26
-
07:39
-
05:11
-
10:18
05 – Facts
-
-
08:28
-
04:01
-
03:19
-
03:19
-
00:32
-
03:32
-
03:51
-
03:34
-
03:35
-
04:05
-
04:40
-
06:02
-
04:37
-
02:05
-
02:59
-
03:29
-
05:25
06 – Dimensions
-
-
06:24
-
07:24
-
04:42
-
04:47
-
03:40
-
03:40
-
08:07
-
05:57
-
05:37
07 – Slowly Changing Dimensions
08 – ETL process
-
-
06:37
-
03:02
-
03:16
-
06:59
-
04:15
-
09:32
-
04:58
-
10:05
-
13:38
-
04:37
-
06:05
-
07:24
-
05:18
-
09:11
-
07:07
-
05:45
-
05:51
09 – ETL tools
10 – Case Study Creating a Data Warehouse
-
-
02:23
-
08:55
-
02:59
-
07:47
-
06:34
-
05:34
-
09:26
-
03:10
-
06:17
11 – ETL vs. ELT
-
-
05:15
-
04:54
12 – Using a Data Warehouse
13 – Optimizing a Data Warehouse
-
-
05:01
-
02:42
-
03:31
-
07:41
-
03:56