Overview
This 4-day instructor-led course delves into the fundamental concepts, design considerations, and best practices of the Snowflake Cloud Data Platform. Through a blend of lectures, demonstrations, and hands-on labs, participants will gain a solid foundation to effectively work with Snowflake.
Objectives
By the end of this course, participants will be able to:
Prerequisites
- Basic understanding of data warehousing concepts.
- Familiarity with SQL.
Course Outline
Module 1: Snowflake Architecture(Week 1)keerti2025-01-04T00:09:55+05:30
-
- Snowflake Architecture and Overview:
- Technical Overview
- Cloud Services Layer
- Storage Layer
- Compute Layer
- Snowflake Clients & Ecosystem:
- Clients and Connectors Overview
- SnowSQL – Snowflake CLI
- Caching:
- Caching Features in Snowflake
- Best Practices for Performance and Cost Optimization
- Snowflake Architecture and Overview:
Module 2: Snowflake Objects(Week 2)keerti2025-01-04T00:10:51+05:30
-
- Snowflake Objects & Commands:
- Data Description Language (DDL)
- Data Manipulation Language (DML)
- Querying and Filtering
- Subqueries
- The Query Profile
- Data Movement:
- Data Loading and Unloading
- Best Practices
- Streams & Tasks
- Snowflake Objects & Commands:
Module 3: Snowflake SQL Support(Week 3)keerti2025-01-04T00:12:32+05:30
-
-
- Snowflake SQL Support for Data Analysis:
- SQL Analytic Functions
- User-Defined Functions (UDF) and Stored Procedures
- Query Profile Demonstration
- Managing Security:
- Access Control and User Management
- Data Protection and Encryption
- Working with Semi-Structured Data:
- Handling Semi-Structured Data
- Optimization Techniques
- Snowflake SQL Support for Data Analysis:
-
Module 4: Performance and Concurrency(Week 4)keerti2025-01-04T00:14:02+05:30
- Understanding Micro-Partitions
- Data Clustering
- Scaling Virtual Warehouses
Module 5: Account and Resource Management(Week 4)keerti2025-01-04T00:15:20+05:30
- System Resource Usage and Billing
- Managing Virtual Warehouses
- Resource Monitors
- Information Schema and Account Usage
