Register now

SNOWFLAKE ASCENT

Essential hands-on training to begin your data journey.

Virtual Event
5 September
9:00 AM–3:00 PM IST
September 5

SAVE YOUR SEAT

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.


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 

  • Follow the steps to enrol for the “Snowflake Ascent Workshop”
  • 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

START TIME SESSION DETAILS
09:00 AM – 9:10 AM IST
Welcome Note
9:10 AM – 9:40 AM IST
Introduction to Snowflake and Course Set-up

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.

9:40 AM – 10:00 AM IST
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:00 AM – 10:20 AM IST
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:20 AM – 10:40 AM IST
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.

10:40 AM – 10:55 AM IST
Break
10:55 AM – 11:15 AM IST
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:15 AM – 11:35 AM IST
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.

11:35 AM – 12:05 PM IST
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:05 PM – 1:05 PM IST
Lunch Break
1:05 PM – 1:25 PM IST
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:25 PM – 1:45 PM IST
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:45 PM – 2:15 PM IST
Module 9: Nested Semi-Structured Data

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

2:15 PM – 2:45 PM IST
Journey to Snowflake Certification

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

2:45 PM – 3:00 PM IST
Modules Conclusion and Wrap Up!

Technical Instructors

Hemant Pangam

Technical Instructor
Snowflake

Hemant Pangam

Technical Instructor
Snowflake

Ravi Gurbaxani

Manager Delivery
Snowflake