Expert Instructor Led Training
Key Features
Expertise Where It's Critical
Your instructor will be an experienced Snowflake Solution Architect with prior teaching experience who can handle tough questions and provide genuine insights and customer case studies.
Hands-On Experience
In addition to top-quality presentations and class discussions, all sessions include extensive hands-on experience with guided labs, including step-by-step guidance complete with a short quiz to help to build confidence.
Library of eBooks
In addition to classroom discussion and hands-on practice, all our courses include a library of eBooks to reinforce learning. These include in-depth discussion of more complex topics and descriptions of Snowflake's recommended best practices for solving real-world customer problems.
Duration: 3 Days
Method: Remote (On-site by Request)
Curriculum
Snowflake Architecture and Overview
Snowflake compute services and costs including options to scale up and scale out
Snowflake Editions & the Object Hierarchy
Data Storage, Time Travel and Clones
Transactional Vs. Analytic Workloads and SQL Support
Batch Data Loading Best Practices
Continuous Data Loading using Snowpipe
ETL/ELT Pipelines using Streams, Tasks, and Dynamic Tables
Performance Tuning, including Caching and understanding the Query Profile
Data Access Management and Role-Based Access Control
Mastering Snowflake: Fundamentals, Insights and Best Practices
Meet Your Instructor: John Ryan
With over 30 years of experience designing and deploying Data Warehouse systems, John became one of the founding Solution Architects for Snowflake UK. During his tenure, he had the privilege of advising numerous Fortune 500 enterprises, helping them design, deploy, and optimize cutting-edge Snowflake solutions.
John later transitioned to the Snowflake Training & Education team, where he combined his real-world expertise with a passion for teaching to develop customer-focused training programs. His mission was to bridge the gap between technical mastery and practical application, enabling Snowflake customers to achieve their goals more effectively.
Known for his ability to explain complex concepts in plain English, John is dedicated to sharing exclusive insights, proven strategies, and best practices that empower teams to progress from beginners to Snowflake experts—all while accelerating their understanding of this transformative technology.
View the Schedule
Questions?
Our Unique Approach:
Learn by Doing: Hands-on Labs
While some people learn by watching, there's no better way to really understand a technology than trying it out.
For this reason, we include hands-on labs with step-by-step instructions, example source code, and further details and diagrams to help build confidence and learn by doing.
Show Don’t Tell
If, like me, you've sat through endless poorly designed presentations, you'll be happy to know that these include hand-drawn visual illustrations to explain concepts backed by Snowflake customer case studies, genuine insights, and real-world experience.
Library of Exclusive eBooks
If you're lucky, your training course will share a copy of the slides to remind you of what was covered, but this is a pretty ineffective way of helping you review your learning.
For this reason, our course subjects are backed by a library of exclusive eBooks to provide a deep dive into more complex subjects, sharpen your understanding, and highlight Best Practices.
Test Your Understanding
The training includes interactive quiz questions complete with answers and explanations to test your understanding and demonstrate knowledge and skills.
View the Schedule
Questions?
Testimonials
“John is a great educator and speaker who knows how to share knowledge. I love it how he uses simple examples to explain even the most complicated problems”.
★★★★★
Lukasz Mastalerz (Data Architect)
“John is an incredibly knowledgeable and skilled data warehouse consultant, architect, designer, analyst, and engineer. A great writer and educator able to translate complex concepts into easy-to-follow tutorials and articles".
★★★★★
Kent Graziano. (Strategic Advisor: Snowflake)
Previous Clients
