Module 1: Overview and Architecture
- Overview
- Snowflake Structure
- Using Snowsight
- Storage Layer
- Compute Layer
- Cloud Services Layer
- Snowgrid
- Generative AI
Module 2: Connecting to Snowflake
- Connection Options
- SnowSQL
- Visualizations in Snowsight
- Data Protection Features
- Cloning
- Time Travel
- Fail-safe
- Introduction to Replication
Module 3: SQL Support in Snowflake
- Tables, Views, and Data Types
- Transactions
- Standard SQL and Snowflake
- Collation
- Multi-table Inserts
- Query Tags
- Working with Parameters
Module 4: Metadata and Caching in Snowflake
- Overview
- Metadata
- Query Result Cache
- Data Cache
Module 5: Query Performance
- Using Explain
- Query Profile
- SQL Performance Tips
Module 6: Data Loading and Unloading
- Data Loading Objects
- Data Loading Process
- Transformations and Copy Options
- Data Loading Recommendations
- Continuous Data Loading
- Unloading Data
Module 7: Functions, Procedures, and Snowflake Scripting
- User-defined Functions
- Stored Procedures
- Snowflake Scripting
Module 8: Using Tasks, Streams, and Dynamic Tables
- Tasks Overview
- Creating Tasks
- Managing Tasks
- Streams Overview
- Dynamic Tables Overview
Module 9: Managing Security
- Security Overview
- Access
- Authentication
- Authorization
- Data Protection
- Trust Centre
Module 10: Access Control and User Management
- Concepts
- Types of Roles
- Ownership
- View Grants
Module 11: Semi-structured Data
- Overview
- Query Semi-structured Data
Module 12: Introduction to Data Sharing
- Snowflake Data Sharing Overview
- Shares
Module 13: Virtual Warehouse Scaling
- Types of Virtual Warehouse Scaling
- Auto-scaling Policies
Module 14: Cost Management
- Overview
- Visibility
- Control
- Optimization
Module 15: Introduction to Snowflake AI and ML
- Overview of Cortex LLM Functions
- Overview of Snowflake ML Functions