Summit 2020 #LETITSNOW19
Summit 2020 #LETITSNOW19

Snowflake Essentials Training

(The Snowflake Essentials Training Course has sold out)

Learning the Basics

Learn the essentials of Snowflake and data warehousing in this pre-conference classroom training. Pass the test to earn a badge of completion.

Essentials Training begins with the most basic tasks such as logging in – switching user role, and navigating within the WebUI – and moves quickly to creating databases, warehouses, file formats and other objects. Training will be very hands-on with short system demonstrations, hands-on practice questions, interface simulations and exercises carried out in a live Snowflake account. We recommend this course as a first step toward an end-to-end, beginner-to-expert selection of offerings.

The training is geared to those who are new to data warehousing or Snowflake, and will provide you with the skill set you need to participate in other labs provided throughout the Summit. Attendees can utilize this class to start their journey to become a Snowflake expert!

REGISTER NOW

 

SNOWFLAKE ESSENTIALS TRAINING

Morning Session

Topics during the morning session feature short, live demos, simulations, practice questions and hands-on exercises in a live Snowflake account.

  • Exploring User Roles
  • Setting Your Role
  • Database and Data
  • Object Navigation
  • Locating Privilege Information
  • Exploring and Previewing Data
  • Creating a Warehouse
  • Configuring a Warehouse
  • Setting a Worksheet’s Context
  • Creating a Database
  • Creating a Table
  • Creating a File Format
  • Loading a table from the WebUI using a File Format
  • Transforming Data with Functions
  • Loading Saved SQL Scripts

Afternoon Session

Topics in the afternoon session include expert presentations and hands-on exercises.

 

Afternoon Expert Presentations

  • Time-Travel
  • Cloning
  • The Snowflake Partner Connect Ecosystem
  • The Data-sharing Marketplace
  • Sem-Structured Data

Afternoon Hands-On Exercises

  • Partner-Enabled Data Loading
  • Outbound Data Sharing
  • Inbound Data Sharing

 

This is a pre-Summit training course, held Monday, June 3, and is tailored towards those new to Snowflake and data warehousing. (Fees apply)