Live Instructor-Led Training Learn from the Architect

Instructor-led sessions for Snowflake engineers, architects, and data teams

Who Should Attend?

This course is ideal for:

  • Snowflake Data Engineers, Analysts, and Architects

  • Project teams launching or scaling Snowflake workloads

  • Managers looking to align teams on Snowflake best practices

Whether you’re launching a new Snowflake environment or struggling with performance and cost control, this course provides immediate, practical value.

Why This Course is Different

Learn What Really Works

Forget the theory - this course shares real-world strategies not found in the documentation, based on 100+ Snowflake multi-terabyte deployments.

Go Beyond “What” - Learn Why

Master Snowflake through deep dives, case studies, and proven best practices that explain how to do it better.

Real-World Practice with 30+ Labs

Practice every concept with guided labs, full SQL scripts, results analysis, and clear expected outcomes.

Curriculum

  1. Snowflake Architecture and Overview

  2. Snowflake compute services and costs including options to scale up and scale out

  3. Snowflake Editions & the Object Hierarchy

  4. Data Storage, Time Travel and Clones

  5. Transactional Vs. Analytic Workloads and SQL Support

  6. Batch Data Loading Best Practices

  7. Continuous Data Loading using Snowpipe

  8. ETL/ELT Pipelines using Streams, Tasks, and Dynamic Tables

  9. Performance Tuning, including Caching and understanding the Query Profile

  10. Data Access Management and Role-Based Access Control

Download Course Summary

View Sample Module

Curriculum Overview

Format and Delivery

  • Duration: 3 Days

  • Delivery: Live via Zoom or on-site, at the customer's request.

  • Group Size: 16 Maximum.

  • Features: Exercises, Walk-throughs and live Q&A.

  • Bonus: 200+ Page eBook on Snowflake Best Practices

Choose between public group sessions or private team workshops. All sessions are interactive and focused on real-world performance, cost optimization, and design techniques.

What Others Say

  • “John's expertise and knowledge of Snowflake is fantastic, and the technical topics within the course were clearly and simply articulated"

    Matthew Kenny - Managing Consultant

  • “I would absolutely recommend this course, John was happy to tailor the course to fit the needs for our business"

    Kyle Reading - Senior Consultant.

  • John undoubtedly ranks among the top experts in the world. He has significantly amplified our capabilities in achieving Snowflake cost savings and his impact has been nothing short of remarkable."

    Pradnesh Patel - Founder & CEO

  • “I love it how he uses simple examples to explain even the most complicated problems”.

    Head of Technology - Climate Arc

  • "John is a great educator able to translate complex concepts into easy-to-follow tutorials"

    Kent Graziano - Snowflake Chief Technical Evangelist

  • Excellent. John provided a high level summary of all the key Snowflake components, its capabilities, without going into too much detail that it is overwhelming"

    Management Consultant

Schedule - Q3 - 2025

Upcoming Public Sessions:

  • June 16th (Full)

  • June 30th

  • July 14th

  • August 11th

  • August 25th

  • September 1st

Private Team Training:

Available on request

Contact us to discuss availability.

Previous Clients

Pricing

  • Public Training: £1,900 per participant

  • Private Teams: Online (Zoom) or on-site*

  • Discounts: Available for larger teams

* Face-to-face (On-Site) teaching, is the most effective way to learn.

We’ll therefore come to your offices provided there’s a minimum of just three participants.

Ready to Get Started? Request Availability

About the Training

  • 1. We will teach you Best Practices based on real-world experience.


    2. Your instructor isn’t just a trainer — they’re a seasoned Snowflake Solution Architect who has advised global enterprises on high-performance data platforms.

    3. In addition to a 200-page eBook to accompany the course, you’ll get a two-hour follow-up Zoom call to answer questions.

  • This course is designed for users at all levels. It assumes no pre-existing knowledge, but builds from fundamentals to deeper architectural insights and best practices not found in typical documentation.

  • Yes. For dedicated teams, we will work with you in advance to tailor the training around your Snowflake environment, challenges, and priorities.

Logistics & Delivery

  • Sessions can be run live over Zoom or delivered in person at your office. All sessions are interactive, with Q&A, screen sharing, and real-time demos.

  • On-site sessions require a minimum of 3 attendees. For virtual Zoom delivery, we can accommodate individuals or full teams.

  • The most common format is delivery over three working days, although we can be flexible over timing. We can accommodate individuals or full teams.

Instructor & Interaction

FAQs

  • John Ryan, a former Snowflake Solutions Architect with experience across 100+ Snowflake deployments. All sessions are delivered live — no subcontractors or junior trainers.

  • Absolutely. Sessions are interactive, and there’s always time for Q&A, scenario-based discussions, or walkthroughs of specific problems.

Booking & Payment

  • Contact us to confirm availability and confirm your booking by credit card.

  • Pricing is per participant. We offer volume discounts for larger teams or multi-session engagements. Contact us for details.