Snowflake Business User
Duration
1 Day
Level
Basic Level
Design and Tailor this course
Official Course
Overview
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.
Audience
Business users
Prerequisites
Basic knowledge of SQL is required
Curriculum
• 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
Duration
1 Day
Level
Basic Level
Design and Tailor this course
Official Course
