Architecture
Data Warehouse Architecture
Data Warehouse Architecture
Data Cleaning
Data Modelling
Data Recovery and Management in Snowflake
Data Types
Basics of Data Warehouses
Designing Schemas
ETL and ELT
Functions
Joins in Snowflake
Data Warehouse Life Cycle
Loading Data
Micro-Partitions in Snowflake
Object Hierarchy
OLAP and OLTP Systems
On-premise and the Cloud Data Warehouses
Snowflake Query Optimization
Querying
Row vs. Column Store
Handling Semi-structured Data
Snowflake Cortex AI features and functions
Snowflake SQL
Starter Notes on Snowflake
Subquerying and CTEs (Common Table Expressions)
Table Types and Views in Snowflake
Tools
Using Snowflake
Virtual Warehouses