Snowflake cloud data warehouse Master class. (Udemy.com)

Master snowflake cloud data-warehouse from real time expert.

( 80 Reviews )

Created by: Pradeep H C

Produced in 2021

What you will learn

Snowflake architecture in detail.
How data processing happens in snowflake.
Secure data sharing in snowflake.
Understand different caching layers in snowflake.
Continues data load using snowpipe.
Clustering tables in snowflake and how it works under the hood.
Load data and unload data from AWS , GOOGLE and AZURE cloud
Snowflake internal stage and external stages.
Snowflake data sampling and its importance.
Detail overview about, snowflake clone , failsafe and data retention.
Unique features of Snowfalke ( time travel , undrop , table swap)
Scheduling using Tasks
Streams in snowflake
Materialized views
Best practices in snowflake
Snowpro certification compatible.

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 84 / 100

Course Description

This course is result of my over 4 years of experience working with snowflake. Snowflake is a fantastic tool to handle huge volumes of data. You can load , query and export and run transactional queries on TB's and PB's of data easily.
You don't have to worry about infrastructure setup, security , performance , tuning , Garbage collection , node failures etc etc... if you have already worked with Spark with EMR or with Data bricks you will be amazed by snowflake performance and simplicity.
But there is a catch, if you are not fully aware of how things works in snowflake, you will easily loose control and end up writing costly queries and end up using many of snowflake features wrongly.
I mentioned costly queries because snowflake is build for performance.
Costly queries and wrong design decisions in snowflake will sky rocket your snowflake bill. I have made lot of such mistakes and learned from those mistakes.
This course is an effort to walk you through such experiences so that you don't end up doing same mistakes which i did!!!
Few things can only be learned by experience you can't find them in documentations this course will expose such details to you.
Hope you join me in this journey...................
The course is broadly divided into 3 modules,Module#1 Lectures------------>: 38 Real time Demos----->: 11 Assignments--------->: 10 Quiz------------------>: 6 This module will concretize snowflake fundamental concepts and architecture. By the end of this module you will be having very strong foundation about snowflake.
Module#2 Lectures------------>: 46 Real time Demos----->: 31 Assignments--------->: 11 Quiz------------------>: 2 In this module i will walk you through, different techniques and options to load and unload data in snowflake. By the end of this module, you will be having great confidence in using COPY command and different data processing objects in snowflake.
Module#3 Lectures------------>: 45 Real time Demos----->: 35 Quiz------------------>: 3 In this module, we closely evaluate important features of snowflake. This module helps you to understand, how each feature works under the hood. Through this knowledge you will be in a better position to decide, when to use the feature and when not to use the snowflake features.
High level overview of all modules with sections details is given below,In module#1, > Snowflake environment setup. > Snowflake architecture. > Snowflake caching , micro-partitions, clusters. > Snowflake clustering deep dive. > Snowflake virtual warehouse layer. > Performance tuning and DB characteristics.
In module#2, > Loading data in snowflake. > Loading data using internal stage. > Load data from aws s3. > Load data from google gcs. > Load data from Azure. > Copy command options. > Working with copy command. > Assignments.
In module#3, > Snowpipe in snowflake. > Data sharing in snowfalke. > Time travel. > Fail safe. > Clone feature. > Data sampling. > Tasks in snowflake. > Streaming in snowflake. > Continuous data load. > Materialized views.
Who this course is for:
Developers planning to learn snowflake database.
Architects who want to understand best practices followed while using snowflake database.

Time: 11.5h

Instructor Details

Pradeep H C

4.2 Rating
80 Reviews

Pradeep has over 7 years of experience working in ETL and data warehousing.
He has great expertise on Snowflake enterprise database, Python, AWS cloud services(EC2,EMR,S3,LAMBDA,KINESIS) Hadoop, Talend and Informatica.
He has great experience in building data pipelines and building data products and services for customers by using advanced analytics.
He has good knowledge on data science and big data technologies. Currently he is working on building data pipelines using spark.

Kubernetes Certified Application Developer (CKAD) with Tests

Kubernetes Certified Application Developer (CKAD) with Tests (2021)
4.9 (312 Reviews)

- Provider: Udemy
- Time: 9.5h

$11.99

Angel Oracle Card Reader Course; Become the Oracle

Angel Oracle Card Reader Course; Become the Oracle (2021)
4.9 (288 Reviews)

- Provider: Udemy
- Time: 3.5h

$11.99

Cisco CCENT Packet Tracer Ultimate labs: ICND1 Exam prep lab

Cisco CCENT Packet Tracer Ultimate labs: ICND1 Exam prep lab (2021)
4.9 (121 Reviews)

- Provider: Udemy
- Time: 14h

$11.99

Microsoft Access Networking 2: Maximum Security

Microsoft Access Networking 2: Maximum Security (2021)
4.9 (68 Reviews)

- Provider: Udemy
- Time: 2.5h

$11.99

Oracle 12c Multitenant Architecture Administration

Oracle 12c Multitenant Architecture Administration (2021)
4.9 (53 Reviews)

- Provider: Udemy
- Time: 10.5h

$11.99

Certified Kubernetes Administrator (CKA) with Practice Tests

Certified Kubernetes Administrator (CKA) with Practice Tests (2021)
4.8 (312 Reviews)

- Provider: Udemy
- Time: 18h

$11.99

All it & software courses

Reviews

4.2

80 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Bhaskar on 11/22/2020

Good course for SNowflake beginners

By Ferenc Mantfeld on 11/8/2020

Accent was very difficult to follow. The up-accent of almost every sentence, turning it into a question (example "so now we have the? interface!") is particularly annoying. A friend of mine said that this is how schools are taught in India. Great, but this is not aimed at tudent in India.
Not enough opportunity to practice anything being taught at all. The instructor knew his material, but was not adept at transfering that knowledge. I would not recommend this class, but would probably hire the instructor into my team as a technical person

By cindy Cleaveland on 11/8/2020

I love the detail and explanation.

By Mittal on 11/8/2020

As compare to other course, I found this great. Here are key points I really liked:
1. Instead of just working with a CSV file, the trainer used data min in GBs so that we can see the real performance and optimizations.
2. Instead of just slides for deep concepts, he reproduced the various error scenarios, cache scenarios etc to show how exactly things are happening.
3. Very good explanation of clustering, performance optimization, query profiling etc.

By KALYANAKANNAN DHAKSHINAMOORTHI on 10/22/2020

Not able to view code

By Vinodkumar Muraleedharan Nair on 10/20/2020

good content and proper explanation with examples

By Srinivas Pambala on 10/15/2020

good sessions

By DVijaya Kameshwari on 10/1/2020

Yes, but for someone who is a bit new to AWS, Azure, Dockers and Python...some of these names might be a bit scary and confusing !

By Sunny Sharma on 9/26/2020

This is a really good course that helped me develop a broader, deeper understanding of the whole of Snowflake. I want to personally thank Pradeep for putting in an extraordinary amount of detail into this course and I look forwards to continuing my Snowflake journey with him.

By Professional Development ProDev on 9/25/2020

I have completed till data loading to aws. It is good and in detail.

By Simon Pullagura on 9/21/2020

yes

By Igor Garlowski on 9/10/2020

quite confusing especially the quiz questions, you have put some solid work to make them clear otherwise these just confuse. your job is to teach not to test me in the most tricky way so I have to think for 30s "what does he want..."