Expert Instructor Led Training
Key Features
Expertise Where It's Critical
We don't use "trainers” (however skilled). 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 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.
Downloadable eBooks
In addition to classroom discussion and hands-on practice, all our courses include fully downloadable eBooks to reinforce learning. These include in-depth discussion of more complex topics and descriptions of Snowflake's best practices for solving real-world customer problems.
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)
Our Unique Approach:
1: Pictures
If, like me, you've sat through endless poorly designed presentations, you'll be happy to know that these include hand-drawn illustrations to explain concepts backed by Snowflake customer case studies, genuine insights, and real-world experience.
If you're curious about my presentation style, see my blog site at https://articles.analytics.today.
2: 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 diagrams to help build confidence and learn by doing.
3: Quiz Questions
Multiple-choice quiz questions to test your undestanding and demonstrate knowledge and skills.
4: Downloadable eBooks
If you're lucky, most training courses give you 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 eBooks to provide a deep dive into more complex subjects, sharpen your understanding, and highlight Best Practices.
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
