SNOWFLAKE COURSE CONTENT
Environment & Architecture
- Trial account setup, web console
- DB & table creation, shared models
- Snowflake Cache Layers
Clustering & Warehousing
- Micro-partitions, clustering keys
- Scaling virtual warehouses
- Concurrency tuning
Data Loading & COPY
- Internal/External Stages
- Copy command basics
- Integration with AWS S3
- Azure Blob, Parquet support
Snowpipe & Load Options
- Snowpipe demo
- Pre-validation, rejection handling
- Purge, enforce, truncate columns
- Copy History
Data Sharing & Accounts
- Secure views & Reader accounts
- Cross-region data sharing
Time Travel & Fail Safe
- Retention methods, recovery
- Fail-safe restoration logic
- Permanent vs Transient tables
Cloning & Scheduling
- Zero-copy cloning
- Sampling, Tasks & dependencies
Streams & Materialized Views
- Change tracking, SCD
- Materialized view usage
Performance & Best Practices
- Query optimization & scaling
- Cost observability and tuning
