Snowflake Cortex Masterclass Hands-On
- Description
- Curriculum
- FAQ
- Reviews
IMPORTANT: This course requires an INTERMEDIATE level and it may NOT be for you if you just recently started with Snowflake and/or Data Science, relational databases, with SQL and/or Python programming. It occasionally deals with advanced notions that are not explained here. Check the minimum Requirements for this course, and the “What this course is NOT about” section below, before buying this course!
What is Snowflake Cortex
-
Snowflake got heavily involved into AI and ML only in the past two years. I know, because I’ve been around since the beginning. In Jan 2021 I was selected by them as a “Snowflake Data Superhero”. And in my last two years alone I passed many DS and ML certification exams (see below).
-
In mid-2023 they came up with Snowpark ML. Then with some built-in ML-powered functions, about regression and classification. The new Model Registry from Snowpark ML – added in Jan 2024 – allows now end-to-end ML on the platform.
-
You’ll see side-by-side data science experiments I will present to you “the old way”, on Snowflake. Many of them with integrations with ChatGPT (about which I talked in detail in another course of mine). To compare them now with the new LLM functions, as Snowflake decided to host their own Large Language Models.
-
Most of these (and other features yet to come) are now presented under the Snowflake Cortex umbrella.
What you will learn
-
High-level picture of the new Snowflake Cortex AI & ML platform.
-
Detailed views on each of the Snowflake Cortex areas.
-
How ML experiments were done on Snowflake before Cortex.
-
How ML experiments can be implemented today with the Snowpark ML APIs, part of Snowflake Cortex.
-
End-to-end Machine Learning with Snowpark ML and its Model Registry.
-
How to use the new regression and classification ML-powered classes and functions, in Snowflake Cortex.
-
How to call the new LLM functions from Snowflake Cortex, and compare them with ChatGPT.
-
What to expect from Snowflake Copilot and other incoming Snowflake features in Cortex.
-
What was the roadmap and what are the future plans of Snowflake for Snowflake Cortex or in the AI & ML areas.
What this course is NOT about
-
I will not teach you data science and machine learning here from ground up. You are expected to have some basic knowledge about ML, DL, LLMs…
-
I will not teach you about many other areas in Snowflake. You are expected to have basic knowledge of Snowflake and data warehouses in general.
-
I will not teach programming in Python or SQL. It’s a hands-on course and you are expected to have some basic knowledge in this area. However, I may come-up with some small Streamlit apps, but I’ll keep everything simple and easy to understand.
-
This will not cover EVERYTHING you can do as data science in Snowflake. While you will see experiments “the old way” with scikit-learn, or integrations with ChatGPT, these are not part of Cortex! We have to limit mostly to Snowflake Cortex, as that’s a huge platform.
-
While Snowpark Container Services are also very new and they also target mostly ML and DL experiments (especially the new containers with GPUs), there will not be enough time to go deeper in detail. And this is also a very specialized and more difficult platform to understand. I may come up later on with a more advanced course on SPCS, but for now this course does not require such an advanced level of preparation.
Who I am
-
The only world-class expert from Canada selected for the Snowflake Data Superhero program in 2021.
-
SnowPro Certification SME (Subject Matter Expert) – many SnowPro exam questions have been created by me.
-
Passed four SnowPro certification exams to date (with no retakes): Core, Architect, Data Engineer, Data Analyst.
-
Specialized in Snowflake for the past few years: I worked for Snowflake Partner companies. I served dozens of clients in this capacity or as an independent consultant. Today I share my knowledge with highly specialize courses on Snowflake.
A few of my latest Data Science and Machine Learning certifications
-
AWS Certified in Machine Learning
-
Microsoft Azure Data Scientist Associate
-
Microsoft Azure AI Engineer Associate
-
Microsoft Azure AI Fundamentals
-
TensorFlow Developer Certificate
-
Alteryx Machine Learning Fundamentals Certified
-
Dataiku ML Practitioner Certified
-
Dataiku MLOps Practitioner Certified
-
Neo4j Graph Data Science Certified
-
TigerGraph Graph Algorithms for Machine Learning
This course truly offers a complete coverage of the new Snowflake Cortex, and my intention is to update it frequently. Enroll today, and keep this course forever!
-
1This course might NOT be right for you if...Video lesson
-
2Course Structure and ContentVideo lesson
-
3Welcome to This CourseVideo lesson
-
4All About This Course (FAQ Post)Text lesson
-
5SnowPro Snowflake Certifications: Added Material!Video lesson
-
6Roadmap to Snowflake CortexVideo lesson
-
7Quick Tips: SQL Query Without Typing SQLVideo lesson
-
8Related Features and TechnologiesVideo lesson
-
9Overview of Snowflake CortexVideo lesson
-
10Quick Tips: TRANSLATE LLM FunctionVideo lesson
-
11Quick Checkpoint: About ...Quick CheckpointsVideo lesson
-
12Test Your KnowledgeQuiz
-
13About this SectionVideo lesson
-
14Quick Tips: Correlation HeatmapVideo lesson
-
15Introduction: Machine Learning BasicsVideo lesson
-
16Introduction: ML Pipeline PhasesVideo lesson
-
17Introduction: ML Pipeline ArchitecturesVideo lesson
-
18Quick Checkpoint: What if You Already Know All This?Video lesson
-
19Data Collection: Time Series GenerationVideo lesson
-
20Data Collection: Make Regression/ClassificationVideo lesson
-
21Data Collection: Generate Random Data for Regression ProblemQuiz
-
22Data Collection: Realistic Fake Data GenerationVideo lesson
-
23Data Collection: Data AccessVideo lesson
-
24Data Collection: Data SplitVideo lesson
-
25Data Collection: OverviewVideo lesson
-
26Quick Tips: Fake but Realistic Data GenerationVideo lesson
-
27Data Exploration: OverviewVideo lesson
-
28Data Exploration: Correlation Matrix HeatmapVideo lesson
-
29Data Exploration: Extract a Value from a Correlation MatrixQuiz
-
30Data Exploration: Pandas ProfilingVideo lesson
-
31Quick Checkpoint: About Pandas ProfilingVideo lesson
-
32Data Wrangling: OverviewVideo lesson
-
33Data Wrangling: Feature Engineering with Pandas DataFrameVideo lesson
-
34Data Wrangling: Data Preprocessing with TransformersVideo lesson
-
35Data Wrangling: Data Preprocessing with PipelineVideo lesson
-
36Quick Checkpoint: About Basic ML on DatasetsVideo lesson
-
37Quick Tips: SUMMARIZE LLM FunctionVideo lesson
-
38Model Training: OverviewVideo lesson
-
39Model Training: RegressionVideo lesson
-
40Model Training: ClassificationVideo lesson
-
41Model Validation: Manual Hyperparameter OptimizationVideo lesson
-
42Model Validation: Manual Cross-ValidationVideo lesson
-
43Model Validation: GridSearchCV for RegressionVideo lesson
-
44Model Validation: RandomizedSearchCV for ClassificationVideo lesson
-
45Quick Checkpoint: About Model ValidationVideo lesson
-
46Model Evaluation: Performance Metrics for RegressionVideo lesson
-
47Model Evaluation: Performance Metrics for ClassificationVideo lesson
-
48Model Serving: Save/Load the Trained Model FileVideo lesson
-
49Quick Tips: Signup for a Free Snowflake Trial AccountVideo lesson
-
50Test Your KnowledgeQuiz
External Links May Contain Affiliate Links read more