Register now

Ascent:
Snowflake Platform Training

Snowflake Free Trial to SnowPro Associate: Platform Certification

22 September
9 Modules
Sands Expo & Convention Centre
Singapore
22 Sept | 1:00 PM - 5:30 PM

SAVE YOUR SEAT

Earn Your Entry-Level AI Data Professional Certification and Gain a Competitive Edge in the AI Data Cloud!

WHAT TO EXPECT

Snowflake Ascent: Platform Training is a free, half-day, in-person, step-by-step workshop delivered by Snowflake’s Certified Instructors. As part of our 1 Million Minds + 1 Platform initiative, you’ll learn foundational knowledge of Snowflake’s data engineering capabilities via lectures, demos and hands-on labs.

You’ll receive a virtual Snowflake completion certificate that verifies that you have completed the course. You will also receive an exclusive offer on Snowflake Training and Certification.

WHO SHOULD ATTEND

Snowflake Ascent: Platform Training has been designed for individuals with limited experience using Snowflake who want to get started and accelerate their knowledge of the AI Data Cloud—including IT managers, Data Architects, Engineers, Scientists, Administrators, and Developers.

This is an entry level course and is not intended for individuals who have already completed the Snowflake Fundamentals course or hold a SnowPro Certification or higher. If that’s you, check out Snowflake’s full course catalogue here.

COST TO ATTEND: FREE

 

YOU WILL LEARN HOW TO

  • Set up and navigate the Snowflake user interface, emphasizing Snowflake Notebooks.
  • Create database and compute resources.
  • Create stages.
  • Load and leverage shared data securely.
  • Call Snowflake Cortex LLM functions to provide generative AI capabilities on your data in Snowflake.

COURSE PREREQUISITES

  • Basic database knowledge
  • Bring your own laptop and charger

YOU’LL LEAVE WITH

  • Practical Snowflake Experience
  • A completion certificate to showcase your skills
  • A free exam voucher to obtain the ‘SnowPro Associate: Platform Certification’ if you complete the course and course survey. (Please be advised that government and public sector employees will receive a certificate of completion only)

DELIVERY FORMAT

The workshop is delivered in-person by Snowflake Certified Instructors.

AGENDA

START TIME SESSION DETAILS
1:00 PM - 1:30 PM
Registration
1:30 PM - 1:45 PM
Snowflake Introduction
1:45 PM - 2:05 PM
Module 1: Interacting with Snowflake

• Snowsight User Interfaces
• Snowflake Notebook Capabilities
• Running SQL Cells
• Running Python Cells
• Python Variable Substitution

2:05 PM - 2:25 PM
Module 2: Identity & Access

• Create a New Database
• Explore your Database
• Databases and Schemas
• Transfer Ownership
• Object Access by Role

2:25 PM - 2:55 PM
Module 3: Database Object Hierarchy

• Snowsight Object Browsers
• How to Run Your Code
• SHOW Commands
• Query Data in Snowflake

2:55 PM - 3:15 PM
Module 4: Tables, DataTypes and Loading Data

• Create a Table
• Locate Tables
• View Table Definitions
• Insert Data
• SELECT and LIMIT

3:15 PM - 3:35 PM
Module 5: Warehouses and Context

• What is a Virtual Warehouse in Snowflake?
• Virtual Warehouse Sizing Recommendations
• Resizing Virtual Warehouses
• Context Settings

3:35 PM - 4:00 PM
Module 6: The Load Wizard and Snowflake Marketplace

• Alternatives to the INSERT Statement
• Load Data From a File
• View Table Data
• Clone a Table
• Snowflake Marketplace
• Private Sharing with Data Exchange

4:00 PM - 4:20 PM
Module 7: Check Your Code

• Use INFORMATION_SCHEMA to Query Metadata
• Check Your Lab Work
• Access Query History in Snowsight
• Use Time Travel

4:20 PM - 4:45 PM
Module 8: Stages & Semi-Structured Data

• Use the LIST Command
• Use the COPY INTO Command to Load Data
• Data Loading Tips and Tricks
• Work With Semi-structured Data

4:45 PM - 5:10 PM
Module 9: Unstructured Data and Cortex LLM Functions

• Unstructured Data
• Directory Tables
• Introducing Snowflake Cortex AI
• PARSE_DOCUMENT Function
• Text Extraction Workflow
• CLASSIFY_TEXT Function
• Streamlit in Snowflake

5:10 PM - 5:30 PM
Wrap-Up and Q&A
5:30 PM - 5:35 PM
Closing

Speakers

Edmondo Rosini

Director, Education Sales, APJ
Snowflake

Alick Li

Technical Instructor
Snowflake

Hwee Yee Lim

Technical Instructor
Snowflake

WHEN & WHERE

Sands Expo & Convention Centre
Roselle Jr 4711 (Level 4), 10 Bayfront Ave, Singapore 018956
22 Sept | 1:00 PM - 5:30 PM
Register now