Architecture
Data Warehouse Architecture
Data Warehouse Architecture
Data Cleaning
Data Modelling
Data Types
Basics of Data Warehouses
Designing Schemas
ETL and ELT
Functions
Joins in Snowflake
Data Warehouse Life Cycle
OLAP and OLTP Systems
On-premise and the Cloud Data Warehouses
Snowflake Query Optimization
Querying
Row vs. Column Store
Handling Semi-structured Data
Snowflake SQL
Starter Notes on Snowflake
Subquerying and CTEs (Common Table Expressions)
Uploading Data
Users, Roles, and Warehouses