Snowflake – The Complete Masterclass (2022 Edition)

Master Snowflake & cloud data warehouse from the ground up

What you'll learn

Master all fundamentals & advanced topics

Helpful for snowflake certification

Build professional-quality understanding of Snowflake

Understand the entire Snowflake workflow from end-to end

Apply your knowlegde in assignments & quizzes hands-on

Learn from top-rated instructor and professional BI developer

Requirements

Laptop with access to the internet & motivation to learn

Basic knowledge of SQL is helpful

Description

Do you want to upgrad your skills and learn how to professionally work in Snowflake?In this course you will – step by step – learn everything that is important in Snowflake!Become a master in Snowflake and learn everything from scratch!Why should you take this course?✓ Understand everything from scratch – step by step, very structured and practice-oriented✓ Learn all the important features – know when and how to use them properly✓ Clear explanations and very systematic – theory & practice✓ Practice everything hands-on – practice & test your knowledge in quizzes & assignmentsWhat is in this course?In this course you will learn everything you need to master Snowflake!This course is giving you the chance to systematically master the everything you need to know in Snowflake!✓ Master all the fundamentals✓ Master also all the advanced topics✓ Learn the best practices hands-on✓ Apply what you’ve learnt in a lot of assignemnts & quizzes✓ Personal support whenever you have questionsThis course is right for you if…… you have never worked with Snowflake and want to learn how to master everything hands-on in just one course…. OR you have already some basic knowledge and want to dive deeper and become more advanced in the whole universe of Snowflake.This is the one course that covers everything you need to Master Snowflake.Enroll now to get life long access and master Snowflake!

Overview

Section 1: Introduction

Lecture 1 Welcome!

Lecture 2 Course Outline

Lecture 3 How to benefit best from the course?

Lecture 4 All course slides & resources

Section 2: Getting started

Lecture 5 Sign up for free trial

Lecture 6 Login to account

Lecture 7 Getting to know the interface

Lecture 8 Snowflake architecture

Lecture 9 Setting up warehouse

Lecture 10 Setting up warehouse using SQL

Lecture 11 Scaling policy

Lecture 12 Exploring tables & databases

Lecture 13 Loading data in snowflake

Section 3: Snowflake architecture

Lecture 14 What is a data warehouse?

Lecture 15 Cloud computing

Lecture 16 Snowflake editions

Lecture 17 Snowflake pricing

Lecture 18 Monitor Usage

Lecture 19 Roles in snowflake

Section 4: Loading data

Lecture 20 Loading methods

Lecture 21 Understanding stages

Lecture 22 Creating stage

Lecture 23 COPY command

Lecture 24 Transforming data

Lecture 25 More transformations

Lecture 26 Copy option: ON_ERROR

Lecture 27 File format object

Lecture 28 Summary

Section 5: Copy options

Lecture 29 Understanding copy options

Lecture 30 VALIDATION_MODE

Lecture 31 Working with rejected records

Lecture 32 SIZE_LIMIT

Lecture 33 RETURN_FAILED_ONLY

Lecture 34 TRUNCATECOLUMNS

Lecture 35 FORCE

Lecture 36 Load history

Section 6: Loading unstructured data

Lecture 37 High-level steps

Lecture 38 Our data

Lecture 39 Creating stage & raw file

Lecture 40 Parsing JSON

Lecture 41 Handling nested data

Lecture 42 Dealing with hierarchy

Lecture 43 Insert final data

Lecture 44 Querying PARQUET data

Lecture 45 Loading PARQUET data

Section 7: Performance optimization

Lecture 46 Performance in Snowflake

Lecture 47 Create dedicated virtual warehouse

Lecture 48 Implement dedicated virtual warehouse

Lecture 49 Scaling up

Lecture 50 Scaling out

Lecture 51 Caching - Theory

Lecture 52 Maximize Caching

Lecture 53 Clustering - Theory

Lecture 54 Clustering - Practice

Section 8: Loading from AWS

Lecture 55 Sign up for free trial

Lecture 56 Creating S3 bucket

Lecture 57 Upload files in S3

Lecture 58 Creating policy

Lecture 59 Creating integration object

Lecture 60 Loading from S3

Lecture 61 Handle JSON

Section 9: Loading from Azure

Lecture 62 Sign up for free trial

Lecture 63 Create a storage account

Lecture 64 Create a container

Lecture 65 Create integration object

Lecture 66 Create stage object

Lecture 67 Load CSV file

Lecture 68 Load JSON file

Section 10: Loading from GCP

Lecture 69 Sign up for free trial

Lecture 70 Create a bucket

Lecture 71 Create integration object

Lecture 72 Create stage

Lecture 73 Query & load data

Lecture 74 Unload data

Section 11: Snowpipe

Lecture 75 What is Snowpipe?

Lecture 76 High-level steps

Lecture 77 Creating stage

Lecture 78 Creating pipe

Lecture 79 Configure pipe & notifications

Lecture 80 Error handling

Lecture 81 Manage pipes

Section 12: Time Travel

Lecture 82 Using time travel

Lecture 83 Restoring data

Lecture 84 UNDROP tables

Lecture 85 Retention time

Lecture 86 Time travel cost

Section 13: Fail Safe

Lecture 87 Understanding Fail Safe

Lecture 88 Fail Safe storage

Section 14: Types of tables

Lecture 89 Different table types

Lecture 90 Permanent tables & databases

Lecture 91 Transient tables & databases

Lecture 92 Temporary tables & databases

Section 15: Zero-Copy Cloning

Lecture 93 Understanding Zero-Copy Cloning

Lecture 94 Cloning tables

Lecture 95 Cloning schemas & databases

Lecture 96 Cloning with time travel

Lecture 97 Swapping tables

Section 16: Data Sharing

Lecture 98 Understanding data sharing

Lecture 99 Using data sharing

Lecture 100 Create share through the interface

Lecture 101 Sharing with non-snowflake users

Lecture 102 Creating a reader account

Lecture 103 Creating a database from share

Lecture 104 Set up users for share

Lecture 105 Sharing database & schema

Lecture 106 Secure vs. normal view

Lecture 107 Sharing a secure view

Section 17: Data Sampling

Lecture 108 Why data sampling?

Lecture 109 Methods of data sampling

Lecture 110 Sampling data: Hands-on

Section 18: Scheduling Tasks

Lecture 111 Understanding tasks

Lecture 112 Creating tasks

Lecture 113 Using CRON

Lecture 114 Understand tree of tasks

Lecture 115 Creating trees of tasks

Lecture 116 Calling a stored procedure

Lecture 117 Task history & error handling

Lecture 118 Tasks with condition

Section 19: Streams

Lecture 119 Understanding streams

Lecture 120 INSERT operation

Lecture 121 UPDATE operation

Lecture 122 DELETE operation

Lecture 123 Process all data changes

Lecture 124 Combine streams & tasks

Lecture 125 Types of streams

Lecture 126 Changes clause

Section 20: Materialized Views

Lecture 127 Understand materialized views

Lecture 128 Using materialized views

Lecture 129 Refresh materialized views

Lecture 130 Maintenance costs

Lecture 131 When to use materialized views

Lecture 132 Limitations

Section 21: Dynamic Data Masking

Lecture 133 Understanding data masking

Lecture 134 Creating a masking policy

Lecture 135 Unset & replace policy

Lecture 136 Alter an existing policy

Lecture 137 Real life examples

Section 22: Access Management

Lecture 138 Key concepts

Lecture 139 Roles overview

Lecture 140 ACCOUNTADMIN

Lecture 141 ACCOUNTADMIN in practice

Lecture 142 SECURITYADMIN

Lecture 143 SECURITYADMIN in practice

Lecture 144 SYSADMIN

Lecture 145 SYSADMIN in practice

Lecture 146 Custom roles

Lecture 147 Custom roles in practice

Lecture 148 USERADMIN

Lecture 149 USERADMIN in practice

Lecture 150 PUBLIC

Section 23: Visualization - Power BI & Tableau

Lecture 151 Data Visualization

Lecture 152 Download & install Power BI

Lecture 153 Connect Power BI & Snowflake

Lecture 154 Working in Power BI

Lecture 155 Download & install Tableau

Lecture 156 Connect Tableau & Snowflake

Section 24: Partner Connect - Connecting other tools

Lecture 157 Connecting to other tools

Lecture 158 Connect to ETL tool

Section 25: Best Practises

Lecture 159 Best practices

Lecture 160 Virtual warehouses

Lecture 161 Table design

Lecture 162 Monitoring

Lecture 163 Retention period

Section 26: Getting started (retired)

Lecture 164 Sign up for free trial

Lecture 165 Getting to know the interface

Lecture 166 Classical console view

Lecture 167 Setting up virtual warehouses (retired)

Lecture 168 Exploring tables & databases (retired)

Lecture 169 Loading data in snowflake (retired)

Section 27: Loading data (retired)

Lecture 170 Creating stage

Lecture 171 COPY command (old interface)

Lecture 172 Transforming data (old interface)

Lecture 173 More transformations (old interface)

Lecture 174 Copy options & ON_ERROR (old interface)

Lecture 175 File format object (old interface)

Lecture 176 Summary (old interface)

Section 28: Copy options (retired)

Lecture 177 Working with rejected records (old interface)

Lecture 178 VALIDATION_MODE (old interface)

Lecture 179 RETURN_FAILED_ONLY (old interface)

Lecture 180 SIZE_LIMIT (old interface)

Lecture 181 FORCE (old interface)

Lecture 182 TRUNCATECOLUMNS (old interface)

Lecture 183 Load history (old interface)

Section 29: Bonus

Lecture 184 Bonus lecture

Data Architects & Data Engineers who want to expand their knowledge to new technologies,Database Administrators who want to invest in their skills of working within new cloud technologies,Everyone that wants to learn Snowflake from beginner to advanced,Everyone that wants work with data and wants learn learn about the latest cloud technologies