Register now

Ascent:
Snowflake Platform Training

Snowflake Free Trial to SnowPro Associate: Platform Certification

13 August
9 Modules
ICC Sydney
Sydney
August 13

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, full-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

GOVERNMENT EMPLOYEES: Please be advised that Snowflake will be providing food and beverage with an approximate market value of $150 AUD and a gift valued at $25 AUD at this event. By accepting the food and beverage and/or gift, you are confirming that you are not prohibited or otherwise restricted from doing so by virtue of your government employment. If you are unable to accept the food/beverage gratuitously, please contact [email protected]

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.

DELIVERY FORMAT

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

AGENDA

START TIME SESSION DETAILS
8:30 AM
Registration Opens
9:00 AM
Welcome & Introductions
9:15 AM
Account set up and login
9:35 AM
Module 1: Interacting with Snowflake

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

10:05 AM
Module 2: Identity & Access

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

10:35 AM
Break
11:05 AM
Module 3: Database Object Hierarchy

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

11:35 AM
Module 4: Tables, DataTypes and Loading Data

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

12:05 PM
Module 5: Warehouses and Context

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

12:35 PM
Lunch Break
1:15 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

1:45PM
Module 7: Check Your Code

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

2:05 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

2:25 PM
Break
2:45 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

3:15 PM
Journey to Snowflake Certification & Close

You have completed your ascent! We’ll wrap up with a quick summary, take you through how you can obtain the training completion badge and share how you can get SnowPro Associate: Platform Certification.

3:45 PM
Session Close

Speakers

Marcus Southam

Senior Technical Instructor
Snowflake

Victor Isakov

Senior Technical Instructor
Snowflake

Edmondo Rosini

Director, Education Sales, APJ
Snowflake

Glenn McPherson

Regional Vice President, Australia
Snowflake

WHEN & WHERE

International Convention Centre Sydney
Meeting Room C4.4, Level 4,
14 Darling Dr, Sydney NSW 2000, Australia
August 13
Register now