Discover the basics of data warehouses, how they function and differ from other solutions, and how to implement them in your current or future role.
Overview
Syllabus
Introduction
- Introduction to data warehouses
- Data warehouse key concepts
- Importance of data warehouses
- Data lake vs. data warehouse
- Data mart vs. data warehouse
- ETL process
- Traditional data warehouse options
- Dimensional modeling
- Dimensional modeling vs. a traditional approach
- Facts
- Dimensions
- Star schema
- Snowflake schema
- How to install SQL Server
- How to connect SSMS to SQL Server
- How to create a data warehouse using SQL Server
- Cloud data warehouse
- Cloud vs. on-premises data warehouse
- Cloud data warehouse options
- Next steps
Taught by
Deepak Goyal