Snowflake Masterclass [Real time demos+Best practices+Labs]

What you’ll 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
  • Loading unstructured data.
  • 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.

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———>: 14

Quiz——————>: 2

  •     In this module i will walk you through, different techniques and options to load and unload datain snowflake.
  •     By the end of this module, you will be having great confidence in using COPY command anddifferent 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.

> Loading unstructured data

In module#3,

> Snowpipe in snowflake.

> Data sharing in snowflake.

> 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.
Note: 100% OFF Udemy coupon codes are valid for maximum 3 days only. Look for "ENROLL NOW" button at the end of the post.
Disclosure: This post may contain affiliate links and we may get small commission if you make a purchase. Read more about Read more about Affiliate disclosure here.
Deal Score0

Udemy Popular Instructors: Rob Percival | Phil Ebiner | 365 Careers | Chris Haroun | Colt Steele | Jose Portilla | Kirill Eremenko | Maximilian Schwarzmüller | Ben Tristem | Daragh Walsh | Evan Kimbrell | Dr. Angela Yu | Laurence Svekis | Start-Tech Academy | Mike Wheeler | Joeel & Natalie Rivera | Stephane Maarek | Hadelin de Ponteves | Tim Buchalka | Scott Duffy | Valentin Despa | Mohsen Hassan | Jaysen Batchelor | Jason Dion | KodeKloud Training | Stephen Grider | Daniel Walter Scott | Rahul Shetty | Andrei Neagoie | in28Minutes Official | Mauricio Rubio | Leila Gharani | Chris Croft | Lawrence M. Miller | Steve Ballinger | Eshant Garg | Juan Gabriel Gomila Salas | Alexander Hagmann | CADCIM Technologies | Sandeep Kumar ­ | Neil Cummings | Denis Panjuta | Tarek Roshdy | Minerva Singh | Matthew Barnett | Siva Prasad | Dr Karen E Wells | Graham Nicholls | Kain Ramsay |

Courses by Top Universities and Institutions: Google Cloud | Stanford University | Deeplearning.ai | University of Michigan | University of Illinois | IBM | Johns Hopkins University | Northwestern University | University of Minnesota | HSE University | Duke Univercity | New York Institute of Finance | Rice University | University of Washington | Yale University |
Course Coupon Club
Logo