• This course is designed for anyone interested to get started with using Snowflake – Developers, DBA, Architects.

• Basic knowledge of relational databases and SQL.

Course Outline:

1. Introduction to Cloud and Data Warehouse
   1. Cloud computing development & service models
   2. What is Data Warehouse & Why is it used?
2. Introduction to Snowflake
   1. What is Snowflake?
   2. Snowflake history
   3. Data Warehouse as a Service
   4. Cloud Platforms and Regions
   5. Snowflake Editions
   6. Lab: Creating Snowflake Account
3. Snowflake Architecture
   1. Understanding Snowflake 3-Tier Architecture
   2. Data Storage
   3. Query Processing
   4. Cloud Services
   5. Lab: Examine Snowflake Web UI
4. Understanding Snowflake Objects
   1. Connecting to Snowflake
   2. Understanding Snowflake Roles
   3. Virtual Warehouses
   4. Database Objects
   5. Lab: Create Warehouse, Database objects
5. Structured Data Ingestion
   1. Structured Data Ingestion
   2. Data Staging
   3. Bulk load from Cloud Storage
   4. Query Data
   5. Lab: Data Ingestion
6. Data Sharing
   1. Overview of Data Sharing
   2. Zero Clone Copying
   3. Cloning Database, Schema, Tables
   4. Lab: Clone Database

Training material provided:

Yes (Digital format)

Hands-on Lab: Instructions will be provided to set up a free tier snowflake account.