In the Advanced Snowflake training course, you'll learn:
Quick Recap of Snowflake Basics
- Layered architecture of Snowflake
- Ingesting data into Snowflake
- Concept of micro partitions
- Functions and procedures
- Working with Snowflake
Ingesting and Streaming Data
- How does Snowpipe work?
- Ingesting data using Snowpipe
- Concept of Streams
- Streams and tasks
- Implementation of CDC using streams
Working with Snowflake Cache
- Types of Cache
- Understanding Result Cache
- Exploring Data Cache
- Optimizing Query performance with Cache
Data Sharing
- Data Sharing Concepts
- Data Providers & Consumers
- Sharing Data outside organization
- Sharing Data within organization
Managing Security
- Authentication
- Role Hierarchy in Snowflake
- Encryption
- Network Policies
- Dynamic Data Masking
Query Tuning and Best Practices
- Understanding Query Plan
- Pruning
- Spillage
- Best Practices for writing Query
Designing Snowflake Objects
- Things to take care while designing
- Data Clustering
- When to choose Materialized Views?
- Performance Tuning
