Training On Demand

Why Choose Analytics Today?

Comprehensive Coverage

Master the art of loading, transforming, and querying data on Snowflake, focusing on practical applications and real-world scenarios.

Proven Techniques. Real-World Case Studies

Gain advanced insights and expert techniques featuring real-world case studies from Fortune 500 enterprises to elevate your skills from beginner to Snowflake expert.

Expert Guidance on Best Practices

Become a Snowflake expert with guidance from a former Senior Solution Architect at Snowflake UK, focusing on performance, cost optimization, and best practices.

What’s included

Top Quality Training

Each class is a video session hosted by John Ryan, providing expert Snowflake advice, deep insights and recommended best practices.

Hands-On Exercises

Web-based Hands-on labs with step-by-step guidance to build confidence.

Exclusive eBooks

eBooks help reinforce learning, discuss complex topics, and explain Snowflake best practices based on real-world experience with Fortune 500 companies.

My Unique Approach:

1: Show. Don’t Tell.

Each lesson includes beautifully hand-drawn images an animations to illustrate complex concepts. The entire course includes 400+ Drawings and 200+ high quality images.

2: Hands-on Exercises

While watching a demonstration is helpful, there’s no substitute for hands-on experience. Each module therefore includes step-by-step instructions with example source code, diagrams and explanations to help build confidence and learn by doing not just watching..

3: Quiz Questions

Quiz questions are a proven technique to help students build confidence and retain knowledge. Therefore, modules include multiple-choice quiz questions complete with answers and full explanations to test your understanding and demonstrate knowledge and skills.

4: Exclusive eBook Collection

PowerPoint slides are useless as a reference material and some people learn by reading in addition to doing. Therefore modules are backed by a comprehensive set of eBooks which provide a deep-dive into more complex subjects, to help improve your understanding and highlight Best Practices.

Meet Your Instructor

Hi there!  As one of the founding Solution Architects at Snowflake UK, I’ve had the privilege to help and advise numerous Fortune 500 enterprises on designing, deploying, and tuning this incredible technology. 

Having left Snowflake, I'm now delighted to share my knowledge and experience to help advance your career. 

I have a passion for teaching and love explaining complex concepts in plain English.  

I’m here to share exclusive insights and best practices to accelerate your understanding from beginner to Snowflake expert..

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)

Subjects Include:

  1. Snowflake Architecture and Overview

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

  3. Snowflake Editions & Object Hierarchy (Accounts, Databases & Schemas)

  4. Data Storage, Time Travel and Clones

  5. Transactional Vs. Analytic Workloads and Snowflake SQL Support

  6. Fast & Efficient Batch Data Loading Best Practices

  7. Lightning Fast Continuous Loading using Snowpipe & Streaming

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

  9. Maximizing Performance, including caching, query tuning and the Query Profile

  10. Securing data access with Role-Based Access Control

Course Curriculum

Accelerate your Career - Enroll Today

Coming Soon

Next
Next

Instructor-Led Training