Welcome
Course orientation (must watch first!)
()
Signing up for the Snowflake trial
()
Snowsight web UI orientation
()
1. Snowflake AI Data Cloud Features and Architecture
The Snowflake Data Cloud
()
IaaS vs. PaaS vs. SaaS
()
Snowflake editions
()
Commercial options
()
Phased release process
()
Snowflake architecture
()
Data sharing
()
Tools and interfaces
()
Connectors
()
Data partner ecosystem
()
Snowflake table types
()
Snowflake view types
()
Snowflake stage types
()
Extensibility
()
Data types
()
Non-relational data
()
Row vs. column orientated databases
()
Micro-partitions
()
Data clustering
()
Storage layer
()
2. Account Management and Data Governance
Managing Snowflake accounts
()
Access control
()
Security features
()
Data security
()
Object tagging
()
Snowflake Horizon
()
Network rules
()
3. Data Loading, Unloading, and Connectivity
Stages
()
File formats
()
Key commands
()
Bulk vs continuous loading
()
Best practices for data loading
()
Load options
()
Unloading data
()
Streams and tasks
()
Snowpipe streaming
()
Dynamic tables
()
Openflow
()
4. Performance Optimization, Querying, and Transformation
Cost management
()
Virtual warehouses
()
Configuring a virtual warehouse
()
Caching
()
Managing virtual warehouses
()
Query profile
()
Data spilling
()
Micro-partition pruning
()
Query acceleration service
()
Search optimisation service
()
Window functions
()
Estimating functions
()
Table sampling
()
User-defined functions
()
Stored procedures
()
Merge operator
()
TRY function
()
Pivot and Unpivot
()
Common table expressions
()
Working with semi and unstructured data
()
Iceberg
()
dbt projects
()
5. Data Collaboration
Infrastructure protection
()
High availability
()
Data encryption
()
Data protection
()
Cloning
()
Time travel
()
Fail safe
()
Underlying storage concepts
()
Secure data shares
()
Data marketplace
()
Data exchange
()
Native applications
()
Data clean rooms
()
Snowflake Cortex services
()
Ex_Files_Snowflake_SnowPro_Core.zip
(499 KB)