The ‘Snowflake[A-Z] Zero to Hero Masterclass(Core+SQL+API+Visual)’ course is specially designed for people who are looking forward to learn Snowflake. The course include all aspects to perform operations on Snowflake such as Snowflake Core concepts, Snowflake Advanced Concepts, Working with Snowflake APIs using Python, Tableau with Snowflake for Visualizations, and PowerBI with Snowflake for Visualizations.
The course consists of 225 lectures with 17+ hours of on-demand content. The course is usually available for INR 2,799 on Udemy but you can click on the link and get the ‘Snowflake[A-Z] Zero to Hero Masterclass(Core+SQL+API+Visual)’ for INR 499.
Who all can opt for this course?
- Aspiring data engineers who want to broaden their horizons.
- Data scientists and analysts: to prepare data on Snowflake so that Analytics can be performed on it.
- Everyone interested in learning Snowflake at any level, from beginner to expert.
- Students or any working professionals that want to improve their skills.
Course Highlights
| Key Highlights | Details |
|---|---|
| Registration Link | Apply Now! |
| Price | INR 499 ( |
| Duration | 17.5 Hours |
| Rating | 4.4/5 |
| Student Enrollment | 25,938 students |
| Instructor | Kashish Gakkar |
| Topics Covered | Snowflake, AWS, Snowpipe, Snowflake SQL |
| Course Level | Beginner |
| Total Student Reviews | 4,752 |
Learning Outcomes
- Snowflake Fundamental Ideas.
- Advanced ideas like failsafes, caching, and time travel.
- Overview of the Snowflake WebUI in detail.
- SQL: From Basic to Advanced.
- Python Snowflake API.
- Python can be used to automate Snowflake activities.
- Tableau can be connected to Snowflake Data to produce visualisations.
- Create visuals by connecting Snowflake Data to PowerBI.
- Regular updates on the capabilities of Snowflake.
- Going for certification will be helpful.
Course Content
| S.No. | Module (Duration) | Topics |
|---|---|---|
| 1. | Introduction (12 minutes) | Know your Instructor |
| Introduction to Snowflake | ||
| Create Free Snowflake Account | ||
| Download Resources for this course | ||
| Snowflake Introduction | ||
| 2. | Deep Dive into Snowflake (28 minutes) | Different Roles in Snowflake |
| Explore – Databases, Schemas and Tables | ||
| Snowflake Architecture | ||
| Virtual Warehouses (Compute Engine) – Intro | ||
| Virtual Warehouses – Standard vs Economy Scaling policy | ||
| Deep Dive into Snowflake | ||
| 3. | Snowflake Pricing (44 minutes) | Snowflake Pricing – Overview |
| What are Snowflake Credits | ||
| Snowflake Editions | ||
| Serverless Features cost | ||
| Storage Cost | ||
| Choose Storage type wisely | ||
| Check storage cost for different regions | ||
| Virtual Warehouses – Compute Cost | ||
| Cloud Services Cost | ||
| Data Transfer Cost | ||
| Check consumed CREDITS on your account | ||
| Queries to check consumption | ||
| Optimization Methods to reduce cost | ||
| Snowflake Pricing | ||
| 4. | Resource Monitors – Track Compute Consumption (29 minutes) | Resource Monitors – Introduction |
| Properties of Resource Monitor | ||
| Actions or Triggers of Resource Monitors | ||
| Suspension or Resumption | ||
| Detailed Example – How Resource Monitors work | ||
| Create a Resource Monitor using WebUI | ||
| SQL queries to Create Resource Monitor | ||
| 5. | Micro-Partitioning in Snowflake (20 minutes) | Partitioning in Traditional Data Warehouses |
| Partitioning in Snowflake – Micro Partitioning | ||
| Advantages of Micro-Partitioning | ||
| Structure of Micro-Partition | ||
| Query Processing in Snowflake | ||
| Micro-Partitioning | ||
| 6. | Clustering in Snowflake (18 minutes) | Clustering Introduction |
| Clustering Keys | ||
| Clustering Metadata | ||
| Clustering Depth | ||
| Automatic Re-clustering | ||
| Clustering in Snowflake | ||
| 7. | Query History & Caching (30 minutes) | Query History |
| Detailed Lab – Query History | ||
| SQL Queries to fetch Query History | ||
| Caching in Snowflake | ||
| Caching – Detailed using Examples | ||
| Lab – Results Cache | ||
| Query History and Caching | ||
| 8. | Jump into Code (15 minutes) | Worksheets – Databases, Schemas, Tables, etc. |
| Setting up Context/Parameters for worksheet | ||
| Run first SQL statement | ||
| More about Worksheet’s Results section | ||
| Test your knowledge on Worksheets | ||
| 9. | Load data from AWS (Amazon Web Services) (01 hour 25 minutes) | Create Free AWS Account |
| What is AWS s3 and how to create buckets under it | ||
| What is IAM (Identity & Access Management) | ||
| Create an IAM Group | ||
| Create IAM User | ||
| Create AWS IAM Role | ||
| Upload data to AWS s3 using web console | ||
| Load Data – 1st Step | Create Table Schema | ||
| Load Data – 2nd Step | Create Integration object – 1 | ||
| Load Data – 2nd Step | Create Integration object – 2 | ||
| Loading CSV Data to snowflake using COPY command | ||
| Load Complete CSV data from S3 | ||
| Load Parquet data – Part 1 | ||
| Load Parquet data – Part 2 | ||
| View Stages and File formats | ||
| Load JSON Data from AWS S3 | ||
| Test your knowledge on Copying Data from AWS S3 | ||
| 10. | Snowpipe – Continuous Data Ingestion Service (26 minutes) | Introduction to Snowpipe |
| Load CSV Data from s3 using Snowpipe | ||
| Load PARQUET Data from s3 using Snowpipe | ||
| Load JSON Data from s3 using Snowpipe | ||
| Test your knowledge on Snowpipe | ||
| 11. | Load data from Microsoft Azure (33 minutes) | Load data from Azure – Overview |
| Create Azure Trial Account – FREE | ||
| Azure Infrastructure Hierarchy | ||
| Create storage account | ||
| Load data on Azure data lake | ||
| Create integration and stage objects | ||
| Load CSV data from Azure data lake | ||
| Load Parquet data from Azure | ||
| 12. | Different Types of Tables (22 minutes) | Different Types of Tables |
| Create Permanent & Transient Database | ||
| Create Permanent & Transient Schema | ||
| Create Temporary, Permanent & Transient Table | ||
| Convert Table to a Different type | ||
| Test your knowledge on Types of Tables in Snowflake | ||
| 13. | Time Travel – Work with history of Objects (30 minutes) | What is Time Travel – Detailed |
| Set & Alter Retention Time Property | ||
| Query Historical Results | ||
| Clone Historical Objects | ||
| Restore the Dropped Objects [IMP] | ||
| Test your knowledge on Time Travel | ||
| 14. | Fail Safe – A Recovery Area (12 minutes) | What is Failsafe – Detailed Overview |
| Check Failsafe Storage Consumption | ||
| Test your knowledge on Fail Safe | ||
| 15. | Tasks In Snowflake – Scheduling Service (31 minutes) | Introduction to Tasks |
| What is a Tree of Tasks | ||
| How to implement a Standalone Task | ||
| Detailed Lab on Tree of Tasks | ||
| Call Stored Procedures using Tasks | ||
| Check Tasks History | ||
| Test your knowledge on Tasks in Snowflake | ||
| 16. | Snowflake Streams – Change Data Capture(CDC) (29 minutes) | Introduction to Streams |
| How Streams work under the hood | ||
| Capture & Process INSERT Operations | ||
| Capture & Process UPDATE Operations | ||
| Capture & Process DELETE Operations | ||
| How streams work within a Transaction | ||
| 17. | Zero-Copy Cloning (31 minutes) | What is Zero-Copy Cloning |
| Clone Database, Pipes, Streams, Tasks & Stages | ||
| Clone Schema & Tables | ||
| DML changes in Cloned table | ||
| Cloning Table Storage Metrics | ||
| Cloning Using Time Travel | ||
| Swap the Tables | ||
| Zero-copy Cloning | ||
| 18. | Secure Data Sharing (45 minutes) | Secure Data Sharing – Section Overview |
| Data Sharing – Definition | ||
| Provider and Consumer Accounts | ||
| Allowed list of objects to Share | ||
| How Data Sharing works on Snowflake | ||
| Data Sharing – Architecture | ||
| Create First share – Hands On | ||
| Share data with other Snowflake accounts | ||
| Consume shared data on Consumer accounts | ||
| Cloning on Shared Databases | ||
| More on Consuming data from Shares | ||
| Adding or removing consumer accounts from shares | ||
| Revoke and Grant privilege to consumer accounts | ||
| Drop Shares | ||
| 19. | Materialized Views on Snowflake (34 minutes) | SQL Views – Refresher |
| Materialized Views – Introduction | ||
| Materialized Views – When to create | ||
| Materialized Views – Advantages | ||
| Materialized Views – Limitations | ||
| Materialized Views – Hands On | ||
| Important Metadata Columns | ||
| When MVs becomes Invalid | ||
| Materialized Views – Refresh History | ||
| Materialized Views – Clustering and ReClustering | ||
| 20. | Secure Views on Snowflake (18 minutes) | Secure Views – Introduction |
| Secure Views – Hands On (Part 1) | ||
| Secure Views – Hands On (Part 2) | ||
| Fetch metadata information about Views | ||
| 21. | *** Mini Project – Setup Row Level Security *** (14 minutes) | Understand the Requirements |
| Set up Users and Custom Roles | ||
| Grant Privileges to custom Roles | ||
| Apply Row-Level Security | ||
| Test Row-Level Security | ||
| 22. | Security – Dynamic Data Masking: Column level security (29 minutes) | Data Masking – Introduction |
| Data Masking – Detailed overview | ||
| Data Masking – Hands on | ||
| Recreate and Unset Masking Policy | ||
| Apply Masking policies on Views | ||
| Alter Masking Policies | ||
| Dynamic Data Masking | ||
| 23. | Snowflake Partner Connect (09 minutes) | Introduction to Partner Connect |
| Know about available Tools | ||
| Start Free Trial for Matillion ETL | ||
| Snowflake Partner Connect | ||
| 24. | Snowflake SQL – DDL (Data Definition Language) (01 hour 07 minutes) | Intro to Snowflake SQL |
| Intro to Data Definition Language (DDL) | ||
| Create Virtual Warehouse | ||
| Create Database, Schema & Table | ||
| Create File Format and Stage object | ||
| Create Views | ||
| Alter Virtual Warehouse | ||
| Working with Roles and Users | ||
| Alter Database, Schema and Table | ||
| Drop Statement | ||
| Truncate and Comment | ||
| SQL Data Definition Language | ||
| 25. | Snowflake SQL – DML(INSERT/DELETE/UPDATE) & DQL(Query Language – SELECT) (02 hours 20 minutes) | Keywords to Fetch Data and their precedence |
| SELECT Statement-I | ||
| SELECT Statement-II | ||
| SELECT Statement-III | ||
| Comment your SQL statements | ||
| Operators | ||
| WHERE with AND operator | ||
| WHERE with OR operator | ||
| Arithmetic Operators | ||
| Comparison Operators | ||
| Logical Operators (IN and NOT IN) | ||
| Logical Operators (BETWEEN) | ||
| Logical Operators (LIKE) | ||
| Logical Operators (CONTAINS) | ||
| Distinct Keyword | ||
| Limit and Offset Keywords | ||
| Group By Clause | ||
| Order By Clause | ||
| Having Clause | ||
| SQL Joins – Intro | ||
| Joins Explanation – Detailed | ||
| Insert, Delete and Update Operations | ||
| Joins – Left Join | ||
| Joins – Right, Inner & outer | ||
| Joins – Self Join | ||
| 26. | Snowflake SQL – Sub-queries & Case Statements (34 minutes) | Sub-query Introduction |
| Sub-query with From Clause | ||
| Sub-query with Where Clause | ||
| Sub-query with HAVING | ||
| Joins & Sub-queries — Interview Question* | ||
| CASE Statement – Part 1 | ||
| CASE Statement – Part 2 | ||
| CASE Statement with Order by Clause | ||
| 27. | Snowflake SQL – Set Operators (UNION, UNION ALL, INTERSECT, EXCEPT, MINUS) (16 minutes) | UNION Clause |
| UNION ALL Clause | ||
| INTERSECT Clause | ||
| MINUS and EXCEPT Clause | ||
| 28. | Snowflake SQL – Working with Row Numbers & Information Schema (33 minutes) | Working with Rows Numbers – Sequences |
| Working with Rows Numbers – Identity | ||
| Working with Rows Numbers – Auto Increment | ||
| Working with Rows Numbers – ROW_NUMBER() function | ||
| Metadata tables – Information Schema | ||
| Different ways to make a copy of Table | ||
| 29. | Snowflake SQL – Functions & Transactions (42 minutes) | Functions – Intro |
| Functions – ABS, Ceil, Floor, Coalesce | ||
| Functions – String Functions | ||
| Functions – Date Functions | ||
| Functions – System Functions | ||
| Transaction, Commit and Rollback | ||
| SQL Functions | ||
| 30. | Work with Snowflake’s Python API – Automation stuff (46 minutes) | Download Python and Anaconda |
| Install Python or Anaconda | ||
| IDEs – Jupyter Notebook and Spyder | ||
| Install snowflake-connector-python | ||
| Connect to Snowflake using Python | ||
| How to mask your password | ||
| Store results in a Pandas Dataframe | ||
| 31. | Visualizations – Working with Tableau and Snowflake (10 minutes) | Download Tableau Desktop |
| Connect Tableau with Snowflake | ||
| How to get Tableau License for Free | ||
| 32. | Visualizations – Working with PowerBI and Snowflake (12 minutes) | Download PowerBI Desktop |
| Connect Snowflake with PowerBI | ||
| Create Graphs & Charts | ||
| 33. | Minor Project – 1: Expose Snowflake Data by Creating Python API (20 minutes) | Project Requirements |
| Connecting Snowflake Using Python | ||
| Use Snowflake Parameters for Python Session | ||
| Defining Main function to fetch data | ||
| Create a Flask API | ||
| Test API using Postman | ||
| Create a similar API on your machine and share codes/python scripts | ||
| 34. | BONUS!! – CERTIFICATION PRACTICE TESTS (00 seconds) | Practice Test – SnowPro Core Certification |
| Practice Test – Snowflake Basics |
Resources Required
- Strong desire to learn
- Access to a computer with an internet connection
Featured Review
Sagar Deshpande (4/5) : One of the best course , which I came across in the field of Snowflake..!!
Pros
- Sharath H (5/5) : Helped me to start with snowflake in a guided manner with very good labs and progress on to the details.
- Greeshma Varghese (5/5) : The course was very good and made me understand the concepts
- Gaurav (5/5) : This is a great course, I am a beginner and learned a lot from the course.
- Ajay pratap Singh (5/5) : it is very detailed and very good for someone like me who just started for snowflake learning.
Cons
- Brian Jardine (1/5) : As well as being monotonous and quite frankly boring the speech idiosyncrasies such as pausing after saying a key word is very annoying e.g. “…
- Ahamed Mohammed Hussain (1/5) : Hence it will lead to loss of information as voice is breaking and subtitle is wrong.
- Anonymized User (2/5) : Till now it is very slow to start with, lot of useless content and the transcripts are out of sync
- Shubham Gupta (1/5) : also these is no good example for explanation till now for the monitor resource section.
About the Author
The instructor of this course is Kashish Gakkar who is a Data Engineer. With 4.4 Instructor Rating and 5,280 Reviews on Udemy, Kashish Gakkar offers 3 Courses and has taught 32,182 Students so far.
- Kashish has more than 8 years of experience working in business intelligence, data science, and engineering.
- He tries to broaden his horizons at work by working with various technologies and then assisting others in learning them.
- He is incredibly knowledgeable about several different technologies, including SAS, SQL, Python, Snowflake, AWS cloud services (EC2, DMS, RDS, S3, LAMBDA), Azure Data Factory, Azure Functions, Kafka, and many others.
- His career gave him the possibility to adopt a 360-degree perspective of the data reality, which allowed him to work in the fields of data engineering, data science & analytics, and data reporting.
- He makes sure that the content he uploads is of the highest quality and concentrates on the content that is simple to understand in order to offer the best delivery.
- His love of teaching and technology prompted him to Udemy to assist you all.
- He has already taught more than 15000 students in more than 80 countries, and he is eager to meet you in his courses.
Comparison Table
| Parameters | Snowflake[A-Z] Zero to Hero Masterclass(Core+SQL+API+Visual) | Snowflake Masterclass[stored proc+demos+Best practices+Labs] | Snowflake – The Complete Masterclass (2023 Edition) |
|---|---|---|---|
| Offers | INR 499 ( | INR 455 ( | INR 455 ( |
| Duration | 18 hours | 21 hours | 14 hours |
| Rating | 4.4/5 | 4.5/5 | 4.6/5 |
| Student Enrollments | 25,921 | 16,518 | 53,474 |
| Instructors | Kashish Gakkar | Pradeep H C | Nikolai Schuler |
| Register Here | Apply Now! | Apply Now! | Apply Now! |
Leave feedback about this