Overview
This course covers the fundamental concepts, design considerations, and best practices intended for key stakeholders who will be working on the Snowflake Platform.
Objectives
At the end of Snowflake training course, participants will be able to
- Illustrate the unique and differentiated architecture of the Snowflake Platform
Load and transform data
Evaluate Query Constructs and DDL & DML Operations
Review Snowflakes broad SQL support for data analysis
Describe how user and application access can be easily managed
Demonstrate best practices for working with semi-structured data
Discuss how Snowflake provides a unique approach to caching
Examine the various ways to connect and interact with the Snowflake Platform
Employ Snowflakes method for continuous data protection
Utilize Data Sharing to send your data in real-time to Customers and Partners
Scale your Virtual Warehouse for performance and concurrency
Explain the different ways you can manage and monitor your Snowflake account
Prerequisites
Previous Data Warehouse knowledge is assumed
Course Outline
- Snowflake Technical Overview
- Cloud Services Layer
- Compute Layer
- Storage Layer
- Query Constructs
- Data Description Language (DDL)
- Data Manipulation Language (DML)
- SQL Support and Query Best Practices
- SQL Analytic Functions
- High Performing Estimation Functions
- UDF and Stored Procedure
- Demo Query Profile
- Data Encryption
- Authentication
- Role-Based Access Control
- Capabilities and Best Practices for working with semi-structured data in Snowflake
- Caching Features in Snowflake
- Best Practices of using caching for performance and cost optimization
- Snowflake Clients and Connectors Overview
- SnowSQL – Snowflake CLI
- Time Travel in Snowflake
- Cloning in Snowflake
- Query Profile
- Micro-Partitions & Data Clustering
- Scaling a Virtual Warehouse
- System Resource Usage and Billing
- Managing Virtual Warehouses
- Workload independence and segmentation
- Monitoring Tool: Resource Monitors
- Monitoring Tools: Information Schema and Account Usage