Ascent: Snowflake
Platform Training

Your path from beginner to SnowPro Associate: Platform Certification

April Sessions

Virtual

9:30am–1:30pm IST

IMPORTANT NOTE BEFORE REGISTRATION:

Click on the “Waitlist” button for the specific training session that you wish to attend. **Do not add Waitlist to multiple trainings.

This action will register your interest and add you to the waitlist. Further instructions on your enrollment status will be provided in due course.

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

WHAT TO EXPECT

Learn the power of Data Platform and AI capabilities with a step-by-step course to get started with the Snowflake AI Data Cloud. This hands-on training empowers you to integrate, share, and activate previously siloed data with limitless scalability and concurrency, enabling you to uncover data-driven insights faster in your work right now.

WHO SHOULD ATTEND

This training is recommended for individuals who:
Ideal for those with little to no experience with Snowflake who are looking to begin their journey with the AI Data Cloud and upgrade their skills

This course is designed for beginners and is not intended for those who have already completed the Snowflake Fundamentals course or hold a SnowPro certification or higher. If you have already obtained certification or completed basic training and are interested in more in-depth education, please explore our full catalog of Snowflake training courses here!

COURSE PREREQUISITES

Join the Snowflake Community: Please register at the Snowflake Community site to enroll in the training class.
Enroll in the class in the Snowflake Training Site: Log-in with Community Account and please check the available times and languages that suit you and enroll for your preferred class in the class catalog
Ensure you have a laptop and stable Zoom access for the training webinar

YOU WILL LEARN HOW TO

Set up and navigate the Snowflake user interface using Snowflake Notebooks.
Create databases and compute resources.
Create stages for data loading.
Securely load and utilize shared data.
Generate AI capabilities on your Snowflake data by calling Snowflake Cortex LLM functions
Please find a more detailed schedule below on this page

WHAT YOU WILL LEARN

Hands-on Experience with Snowflake and Start Your Journey to an AI Data Skillset
A Certificate of Completion
Get Certified Instantly. Complete the 4-hour deep dive and pass our final assessment to earn your Snowflake University Platform Skills Badge, the perfect credential to showcase your hands-on mastery on LinkedIn

Don’t just take our word for it. Here’s what people say:

"This beginner friendly hands-on session is a great start for people who want to learn a versatile cloud tool snowflake. This session gave an understanding of how cloud storage compute works and how to integrate other data sources and develop LLM scripts. Overall this session is a great start for whoever wants to start their journey in Snowflake."

Chandana Samineni

Senior Data Engineer

"If you're serious about passing the SnowPro Associate certification, this is the training you need.

It gave me the essential foundation and clarity so I wasn't just guessing on exam day. A genuine must-have for any aspiring Snowflake professional."

Biswajit Das

Technical Lead

AGENDA

START TIME SESSION DETAILS

9:30 am - 10:00 am

10:00 am - 10:10 am

Welcome and Introduction

10:10 am - 10:15 am

Snowflake Overview

10:15 am - 10:35 am

Module 1: Interacting With Snowflake

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

10:35 am - 10:55 am

Module 2: Identity and Access

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

10:55 am - 11:25 am

Module 3: Database Object Hierarchy

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

11:25 am - 11:45 am

Module 4: Tables, Data Types, and Loading Data

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

11:45 am - 12:05 pm

Module 5: Virtual Warehouses and Context

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

12:05 pm - 12:30 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

12:30 pm - 12:50 pm

Module 7: Check Your Code

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

12:50 pm - 1:15 pm

Module 8: Stages and 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

1:15 pm - 1:40 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

1:40 pm - 1:50 pm

Wrap-up and Q&A

1:50 pm - 2:00 pm

Closing Remarks