Advanced Course
Snowflake Intro for Data Practitioners
A new course for data analysts and data engineers to discover Snowflake
Course Duration
2 Day Course
Designed for
Data Analysts & Data Engineers
Class Size
Tailor-made groups, also available for individuals
Instructors
senior professionals from Vision.bi
Is it for me?
If you are a data analyst or data engineer, this is the fastest way to get an overview of Snowflake, plus hands-on experiences through our workshops, taught by senior
professionals who will share best practices, business examples and more.
Who is teaching the course?
The course is taught by senior professionals fromVision.bi, a boutique data and analytics consultancy thatcombines technical and business expertise to deliver data solutions that help businesses grow.
How do I register?
Courses are held for groups, and they can be done in person or online. Register your interest here and we will get back to you with information on the next available dates.
What will I learn?
How to work with Snowflake
Architecture overview, using warehouses, main features, basic security concepts.
How to load data into Snowflake
working with stages, file formats, performing data manipulations while loading.
How to work with Semi-Structured data
using variant data columns, working with arrays and objects, flattening and unwinding arrays.
Ingestion methods
data ingestion recipes and common scenarios.
Working with window functions
(and other cool SQL features)
window functions overview and SQL functions that are unique to Snowflake.
How to write UDFs and procedures
writing custom functions and integrating Python code within Snowflake.