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?
Getting Started with Snowflake
Understanding Snowflake's architecture.
Using warehouses effectively. Exploring key features and foundational security principles.
Designing your Snowflake Solution
9 Table Types - When to use what?
Loading Data into Snowflake-Working with stages and file formats.
Performing data transformations during data loading. Streaming and near-real-time analytics.
Handling Semi-Structured Data
Using variant columns to manage semi-structured data. Working with arrays and objects. Flattening and unwrapping nested data structures.
Advanced SQL Features in Snowflake
Mastering window functions.
Exploring unique SQL capabilities in Snowflake.
Creating UDFs and Stored Procedures
SQL Stored procedures. UDF & UDTF. Snowflake UDFs and stored procedures limitations.
Dynamic Data Masking and Access Control
Implementing dynamic data masking and policies. Using row-level security (RLS) and tagging for data governance.
Empowering Data Scientists with Snowflake
Leveraging Snowflake’s Data Science capabilities, including integration with Python and ML functions.
Streamlit & Native Apps
Different methods of developing and deploying apps. First steps with Streamlit.
Leveraging LLMs and Document AI in Snowflake
Exploring Snowflake’s integration with large language models (LLMs) and Document AI, document processing. Cortex Analyst & Advanced AI-driven analytics.
Query optimization - Understanding query profiler
A walkthrough of Snowflake’s query profiler, how to interact with it, and how to interpret its metrics and flow.
Cost control and optimization technique
Controlling costs and budgets using Snowsight.
Tagging objects and queries. Cost analytics using Arctica.ai.
Recently Certified Snowflake Experts
