Projects
Assignments
Overview
This 4-day course covers the fundamental concepts, design considerations, and best practices intended for key stakeholders who will be working on the Snowflake Platform. The course will consist of lecture, demos, and labs on a wide range of foundational topics.
Objectives
At the end of Snowflake training course, participants will be able to
Prerequisites
Previous Data Warehouse knowledge is assumed
Course Outline
Snowflake Architecture and Overviewedforce2021-12-14T14:03:08+05:30
- Snowflake Technical Overview
- Cloud Services Layer
- Compute Layer
- Storage Layer
Snowflake Objects & Commandsedforce2021-12-14T14:04:55+05:30
- Query Constructs
- Data Description Language (DDL)
- Data Manipulation Language (DML)
Snowflake SQL Support for Data Analysisedforce2021-12-14T14:05:19+05:30
- SQL Support and Query Best Practices
- SQL Analytic Functions
- High Performing Estimation Functions
- UDF and Stored Procedure
- Demo Query Profile
Managing Securityedforce2021-12-14T14:05:53+05:30
- Data Encryption
- Authentication
- Role-Based Access Control
Semi-structured Dataedforce2021-12-14T14:06:26+05:30
- Capabilities and Best Practices for working with semi-structured data in Snowflake
Cachingedforce2021-12-14T14:06:48+05:30
- Caching Features in Snowflake
- Best Practices of using caching for performance and cost optimization
Snowflake Clients and Ecosystemedforce2021-12-14T14:07:09+05:30
- Snowflake Clients and Connectors Overview
- SnowSQL – Snowflake CLI
Continuous Data Protectionedforce2021-12-14T14:07:35+05:30
- Time Travel in Snowflake
- Cloning in Snowflake
Performance & Concurrencyedforce2021-12-14T14:08:22+05:30
- Query Profile
- Micro-Partitions & Data Clustering
- Scaling a Virtual Warehouse
Account and Resource Management and Monitoringedforce2021-12-14T14:09:05+05:30
- System Resource Usage and Billing
- Managing Virtual Warehouses
- Workload independence and segmentation
- Monitoring Tool: Resource Monitors
- Monitoring Tools: Information Schema and Account Usage
