SNOWFLAKE ASCENT

Essential hands-on training to begin your data journey.

The Westin Calgary (320 4 Ave SW.)

October 7

8:15 A.M. MST

SAVE YOUR SEAT

WHERE
The Westin Calgary
320 4 Ave SW
Calgary, AB T2P 2S6

WHAT TO EXPECT

Snowflake Ascent is a step-by-step live and free, Data Cloud training conference delivered by Snowflake’s technical instructors. Our instructors will outline the Data Cloud architecture including data warehousing, data lakes, data engineering, data science, data applications and data sharing. The instructor-led hand-on labs will show you how to set-up your instance and accelerate your ability to unify, integrate, and share previously siloed data with virtually unlimited scale and concurrency. You will be able to follow the training with your free-trial account and have your questions answered.

Complete the workshop and earn a Data Warehouse Hands On Essentials badge to print, or display on your social profiles!

WHO SHOULD ATTEND

Snowflake Ascent has been designed for individuals with limited experience using Snowflake looking to get-started and accelerate their knowledge with the Data Cloud – including IT managers, Data Architects, Engineers, Scientists, Administrators and Developers

YOU WILL LEARN HOW TO

Set-up and Navigate the Snowflake User Interface
Create Database and Compute Resources
Create Stages and Roles
Load and Share Data Securely
Manage Performance

COURSE PREREQUISITES

A Snowflake Community account (sign up here)
A Snowflake free-trial account (sign up here)
Students are requested to create an Enterprise Edition trial account on AWS – Region = Canada (Central)

AGENDA (MST)

START TIME SESSION DETAILS

8:15 AM - 9:00 AM

Registration & Breakfast

9:00 AM - 9:15 AM

Welcome & Course Set-Up

9:15 AM - 10:00 AM

Introduction to Snowflake

This section will outline the Snowflake platform, starting with What is The Data Cloud, an end to end on the architecture including core workloads – data warehousing, data lakes, data engineering, data science, data applications and data sharing. You will learn how to set-up a trial account, how to navigate between the classic UI and the new Snowsight UI, and what is an Account URL.

10:00 AM - 10:20 AM

Module 1: Identity and Access with Snowflake

This section will outline the basic predefined roles in Snowflake, you will learn about roles and how they relate to both database and warehouse visibility.

10:20 AM - 10:40 AM

Module 2: Data Containers

In this section, you will learn about creating databases, dropping and creating schemas, how to create a worksheet and run code as well as how to use the SHOW commands.

10:40 AM - 11:00 AM

Break

11:00 AM - 11:20 AM

Module 3: Tables, Data Types and Loading Data

In this section, you will learn about tables and data types, and how to create tables using SQL including how to insert data into a new table.

11:20 AM - 11:40 AM

Module 4: Worksheets and Warehouses

In this section, you will learn what worksheets and warehouses are and how you can use them to write and execute queries.

11:40 AM - 12:00 PM

Module 5: File Formats and the Load Wizard

In this section, you will learn how to prepare data for loading, how to massage it prior to load and how to set up file formats, how to load tables using the Load Wizard and then view the newly inserted data.

12:00 PM - 12:30 PM

Module 6: Staging Data

In this section, you will learn what a Snowflake stage object is and how it is used in the data loading process. You will also learn how to use the LIST command to discover the contents of a stage and how to use the COPY INTO statement to load data into a table from a stage.

12:30 PM - 1:15 PM

Lunch Break

1:15 PM - 1:35 PM

Module 7: Data Storage Structures

In this section, you will learn how to model data effectively in Snowflake so you can create and populate data storage structures that will give you the answers you need.

1:35 PM - 1:55 PM

Module 8: Intro to Semi-Structured Data

In this section, you will learn the basics of how Snowflake natively supports the storage and querying of semi-structured data.

1:55 PM - 2:15 PM

Module 9: Nested Semi-Structured Data

In this section, you will load and query nested semi-structured data.

2:15 PM - 2:25 PM

Journey to Snowflake Certification

This section will bring all of the module components together and outline your path Snowflake Certification.

2:25 PM - 3:00 PM

Modules Conclusion and Extended Q&A

Technical Instructor

Eric Wong

Technical Instructor
Snowflake