What Will You Learn?
In this module, you will learn, what is Data Warehouse, Why we need it and how it is different from the traditional transactional database. We will learn the concept of dimensional modeling which is a database design method optimized for data warehouse solutions. Then I will explain what we mean when we say facts and their corresponding fact tables. What are the dimensions and their corresponding dimension tables? how are these special kinds of tables joined together to form a star schema or snowflake schema?About This Course
About This Course
Provider: Udemy
Format: Online
Duration: 30 minute to complete [Approx]
Target Audience: Beginners
Learning Objectives: You will be proficient in Data Warehouse basic concepts like architecture, dimensional modeling, fact vs dimension table, star vs snowflake schema after completing this free course.
Course Prerequisites: NA
Assessment and Certification: NA
Instructor: Eshant Garg (Azure Data Engineer Associate)
Key Topics: Data Warehouse Basic concepts, Database, Schema and Snowflake schema
Topic Covered:
- Introduction
- Data Warehouse Basic concepts
- Dimensional modeling
- Facts and Dimensional tables
- Schema and Snowflake schema
- Microsoft SQL Data Warehouse
- speed up with Cloud warehousing
0 Comments