Essential hands-on training to enhance your Snowflake skills

WHAT TO EXPECT

Ascent: Foundations is a complimentary, 1-day hands-on workshop, designed for new Snowflake users.  It’s your chance to expand your working knowledge of the platform by immersing yourself in the Snowflake Data Cloud for a full day.

Coffee and light breakfast snacks will be available upon arrival, and lunch will be provided to all attendees.

WHO SHOULD ATTEND

Snowflake Ascent: Foundations has been designed for Data Engineers, Data Scientists, Database Administrators and Data Architects who are new to Snowflake.

It’s not for those who have already undertaken Snowflake Fundamentals, or have a SnowPro Core Certification.

COURSE PREREQUISITES 

  • Bring your own laptop and charger
  • Previous Data Warehouse knowledge is assumed

AGENDA

  • Introduction to Snowflake
  • Identity and Access
    Predefined Roles
    Warehouse visibility
  • Data Containers
    Creating and Dropping Databases and Schemas
    Working with Show Commands
  • Tables, Data Types and Loading Data
    Creating Tables
    Using SQL to insert Data
  • Worksheets and Warehouses
    Working with Worksheets
  • File Formats and the Load Wizard
    Prepare data for loading
    Loading data using the Wizard
  • Staging Data
    Snowflake Stages
    Copy Into Command
  • Data Storage Structures
    Data Modeling
  • Intro to Semi Structured Data
    Querying Semi-Structured Data
  • Nested Semi Structured Data
    Loading nested Semi Structured Data

Essential hands-on training to enhance your Snowflake skills

WHAT TO EXPECT

Ascent: Foundations is a complimentary, 1-day hands-on workshop, designed for new Snowflake users.  It’s your chance to expand your working knowledge of the platform by immersing yourself in the Snowflake Data Cloud for a full day.

Coffee and light breakfast snacks will be available upon arrival, and lunch will be provided to all attendees.

WHO SHOULD ATTEND

Snowflake Ascent: Foundations has been designed for Data Engineers, Data Scientists, Database Administrators and Data Architects who are new to Snowflake.

It’s not for those who have already undertaken Snowflake Fundamentals, or have a SnowPro Core Certification.

COURSE PREREQUISITES 

  • Bring your own laptop and charger
  • Previous Data Warehouse knowledge is assumed

AGENDA

  • Introduction to Snowflake
  • Identity and Access
    Predefined Roles
    Warehouse visibility
  • Data Containers
    Creating and Dropping Databases and Schemas
    Working with Show Commands
  • Tables, Data Types and Loading Data
    Creating Tables
    Using SQL to insert Data
  • Worksheets and Warehouses
    Working with Worksheets
  • File Formats and the Load Wizard
    Prepare data for loading
    Loading data using the Wizard
  • Staging Data
    Snowflake Stages
    Copy Into Command
  • Data Storage Structures
    Data Modeling
  • Intro to Semi Structured Data
    Querying Semi-Structured Data
  • Nested Semi Structured Data
    Loading nested Semi Structured Data

Save Your Spot!

Marina Del Rey Marriott

4100 Admiralty Way, Marina Del Rey, CA 90292

August 13th, 2024 | 9:30am-2:30pm PT