Duration
1 Day
Level
Basic Level
Design and Tailor this course
Official Course
This one-day, role-specific course introduces business users to the Snowflake Data Cloud and its architecture.
Participants learn how to connect to Snowflake and how to analyze and report data insights from Snowflake.
The course consists of lectures, labs, demonstrations, and discussions.
Business users
• Why Snowflake?
• Snowflake Functional Architecture
• Platform Features
• Getting Started with Snowflake
• Snowflake Architecture Layers
• Snowflake Structure
• Information Schema and Account Usage
• Using Parameters to Control Snowflake
• Query Tags
• Sample Data Sets
• Client Interface Overview
• Snowsight
• SnowSQL
• Connecting Tools to Snowflake
• Data Definition Language (DDL)
• Data Manipulation Language (DML)
• Constructing Eicient Queries
• Collation
• Sampling
• Window Functions, Syntax, and Usage
• Group By and Grouping Sets
• Recursive With and Connect By
- Explore
- DataPrepare Data
- Analyze Data
- Visualize Data
- Integrate BI Tools
Basic knowledge of SQL is required