Course curriculum
-
-
Orientation (MUST WATCH FIRST!)
-
The EVEREST Guide
-
Snowflake Overview
-
A word or two on the Snowflake Web UIs
-
Introduction to the Snowflake Classic Web UI
-
-
-
Architecture Introduction
-
The Snowflake Architecture
-
The Snowflake Partner Ecosystem
-
Real-world use case: Legal and General
-
-
-
How Does Snowflake Store Data?
-
Data Loading
-
Loading and Unloading Data (AWS S3)
-
Configuring an External Stage in Azure
-
Continuous Loading using Snowpipe
-
Real-world use case: Canva
-
-
-
Streams & Tasks
-
Snowpipe Streaming
-
Dynamic Tables
-
Real-world use case: Sainsburys Data Movement
-
-
-
Introduction to Data Protection in Snowflake
-
Cloning
-
Time Travel
-
Data Replication and Failover
-
Replicating Account Objects
-
-
-
Roles and the Role Hierarchy
-
Managing PII Data and Dynamic Masking Policies
-
User and Application Authentication
-
Networking and Private Connectivity
-
Row Access Policy
-
Data Classification
-
Advanced Security Features
-
Trust Center
-
Real-world use case: Sainsburys
-

About this course
- 78 lessons
- 12.5 hours of video content
What makes Mastering Snowflake different?
The community is at the heart of everything we do. Get exclusive access to me and my team for the support you need to achieve your goals!
-
How anyone can test drive Snowflake
$600 creditsDetailed instructions on how to redeem your fully functioning Snowflake trial including $600 of credits, where to find it and what options to select.
-
SnowPro Core Study Guide Companion
$60 valueGet your hands on the SnowPro Core Study Guide top rated Amazon e-book and supercharge your career by starting your Snowflake journey!
-
Live group consultancy calls!
Regular calls with Adam & guest speakersGet the support you need to reach your goals by asking any questions around Snowflake, the program materials, certification, interview guidance or anything else!
Pricing options
Explain how different pricing options might be valuable to different segments of your audience.
-
$1,995.00 / year
Regular price
-
$1,995.00
Lifetime access
What do our members have to say?
“I found the Mastering Snowflake program to be well organised in its delivery. The data engineering aspects of the program were rounded out by modules on data governance, data sharing and data protection that gave the course a whole-of-data-management feel. The industry case studies really helped to bring the technical content to life. I'm looking forward to implementing best-in-class data governance practices using Snowflake in the future.”

“The Mastering Snowflake program really helped me grasp the concepts of Snowflake from a beginner's perspective. My favorite part of the program was the delivery of the core content, specifically the in-depth, hands on demos, along with a nice forum to ask questions and learn from Adam and other members. I really learnt a huge amount of valuable information. I am looking forward to continuing to participate in the live Q&A consulting calls in the coming weeks.”

“I took the course and it has everything to help me in Mastering the Snowflake - 10 Modules covering the entire spectrum of Snowflake, Scripts to practice each topic and the practice test to ace the Snowpro certification. It is very well organized. It not only helped me to learn Snowflake in detail. It also helped me to pass the Snowpro Certification. A great course for anyone who wants to Master Snowflake.”

“For me, the Mastering Snowflake program has provided a valuable experience to date. I have gained a better understanding of the pros and cons of certain features of Snowflake (like Snowpipe continuous file loading, MV refreshes, Tasks etc that use Snowflake Managed warehouses or “serverless”), and how they are used and how they may result in “hidden charges” that customers sometimes don’t understand. A pleasant surprise of joining this program was meeting the other members and listening to their journey with Snowflake”

“I found it tremendous value it brings to students who wanted to learn modern architecture of Snowflake. There are sample codes provided as a part of course which will help in real world , no need to write from scratch. Course has been designed in a proper way that will also help student to get certification which I am planning to do in any case. Thank you Adam for wonderful compilation and wish you all success.”

“The Mastering Snowflake program is very well organized and you (Adam) deliver it very nicely. The course materials/ppts are very easy for understanding concepts. The Advanced Performance Tuning part was very precise with hands-on examples which makes it easy to understand the topics. My favourite part of the LinkedIn group was that all members are very experienced and ready to help each other with their questions/answers.”

“As a direct result from becoming a member of the Mastering Snowflake program I was able to very quickly apply what I learnt to my day-to-day job. Specifically, I used some of the ideas on how to set up/group warehouses and the best practice to assign user roles. One example here is that user roles were not used properly, with technical personnel using accountadmin. Once I recognised this as bad practice based thanks to the program, we revoked the accountadmin role and set up custom roles to immediately reduce the business risk. Additionally, I was able to fine tune and improve our configuration of virtual warehouses to find a better balance between performance and cost.”

“Not coming from the cloud background, overall costing and credit expense is something which is to be taken care of is something I found very good. It'll be interesting to go for Snowflake Data Engineer certifications and even plan for Architect certification if things go well. Also, many things I got to understand really well in the course, especially about roles and security of the snowflake and ways to implement them in the real world, the ways to obfuscate the data on the fly. The content is so well optimized that not only it makes your concepts about snowflake very clear but also it makes you imagine proactively about different ways to implement stuff in Snowflake.”

“Adam Morton's Mastering Snowflake program was a key factor in my passing the Snowflake Snowpro Core Certification on the first attempt. His structured approach, comprehensive material and engaging style simplifies learning the material in an enjoyable manner. The hands-on labs and code samples reinforce the instruction enabling improved retention. I heartily recommend Mastering Snowflake.”

“Adam's program goes beyond just preparing you for the test; it instills a comprehensive understanding of Snowflake as a leading cloud data warehouse. Thanks to his program, I not only passed the SnowPro Core Certification with ease but also gained practical knowledge to design, develop, and manage secure, scalable Snowflake solutions effectively. Adam's program is a blend of expert knowledge and real-world applicability, making it invaluable for anyone looking to excel in this field. I highly recommend Adam Morton's 'Mastering Snowflake' to anyone aiming to achieve mastery over Snowflake technologies and drive significant business objectives. His program is a game-changer in the world of data warehousing.”

Our Everest Guide
Follow our 'EVEREST' roadmap to achieve real success and SUPERCHARGE your career!
-
Make base camp: Understand the fundamentals well. Walk before you run!
-
Scale the Wall: Anticipate the common challenges and ensure you’re equipped to avoid them!
-
Reach the Summit: The air is thinner here and less people make this far. Enter the rarefied environment and stand out from the crowd.
I'm Adam Morton

Adam Morton
Snowflake Data Superhero
[email protected]However, at that point in time, Adam found it difficult to find valuable, relevant content he could consume today and apply tomorrow. It was a time-consuming task to research and test what worked well and what didn’t. Snowflake has new and innovative features, dictating a change of approach and a departure from the traditional mindset required to work with the data warehouse technologies which predated it.
Following several highly visibility roles over the years, which included Head of Data for a FTSE 100 Insurer, he accumulated a wealth of valuable, real-world experiences designing and implementing enterprise-scale Snowflake deployments across the UK, Europe, and Australia.
As a byproduct of overcoming several business and technical challenges along the way, Adam found a formula that works. A lot of these experiences formed the basis for Adam to be endorsed as an internationally recognized leader in his field as he was awarded a Global Talent Visa by the Australian Government in 2019.
Today, Adam is on a mission to help as many IT professionals as possible escape dead-end jobs and supercharge their careers by breaking into cloud computing using Snowflake.