Snowflake[A-Z] Zero To Hero Masterclass(Core+Sql+Api+Visual)

Snowflake Masterclass launched in SEP 2020, Highest CONTENT HOURS to make you EXPERT on Snowflake Datawarehouse concepts

What you'll learn

Core Snowflake Concepts

Advanced Concepts such as Time Travel, Fail Safe, Caching, etc.

Detailed Overview of Snowflake WebUI

SQL - Beginner to Advanced

Snowflake API for Python

Automate Snowflake tasks using Python

Connect Snowflake Data with Tableau and create visualizations

Connect Snowflake Data with PowerBI and create visualizations

Frequent Updates about Snowflake functionalities

WILL BE HELPFUL TO GO FOR CERTIFICATION

Requirements

Access to a computer with an internet connection.

Determination

Description

UPSKILL YOURSELF  WITH THIS MASTERCLASS!************************************************************************************************************SnowPro Core Certification Practice Test added- This will help you understand the examination pattern- Will boost your confidence before attempting the actual examination************************************************************************************************************This course is launched in SEPTEMBER 2020 with motive to make you Master on Snowflake Data Warehouse core concepts as well as its APIs, connectors, SQL, etc. This course will also help you to get certified on Snowflake.This course is providing HIGHEST NUMBER OF CONTENT HOURS to cover each and every aspect related to Snowflake.In couple of days, this course is marked as "Best Seller" course by Udemy because of:1.) course content2.) students feedback3.) students engagement4.) prompt instructor responses on QnA5.) proportion of number of new enrollments as compared to other courses*****************************************************************************************************************************–––––––––––- TAKE THIS COURSE WITH MONEY-BACK GUARANTEE OF 30 DAYS –––––––––––-*****************************************************************************************************************************Snowflake is an in-demand cloud Data Warehouse. It solves most of the problems such as scalability, maintenance and downtime which we used to face with traditional data warehouses. Using its Modern Architecture and Massive Parallel Processing (MPP) power, many complex problems can be solved within minutes. These days, Data Analysts/Data Scientists/Data Engineers are adopting Snowflake to avoid any maintenance and to pay what they use. Because of its elasticity, they spend less time finding insights from the data stored in Snowflake.–––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––This course is specially designed for people who are looking forward to learn Snowflake. It does not matter if you are working as a Data Analyst/Data Scientists/Data Engineer/Programmer/BI Expert or as a Student, Data is everywhere so there is a need to process voluminous data to perform day-to-day tasks.I have tried to include all aspects to perform operations on Snowflake such as:1.) Snowflake Core concepts2.) Snowflake Advanced Concepts:        - Time Travel        - Fail Safe        - Zero-Copy Cloning        - Data Sharing        - Query History        - Resource Monitors        - Caching        - Micro-Partitioning3.) Working with Snowflake APIs using Python4.) Use Tableau with Snowflake for Visualizations4.) Use PowerBI with Snowflake for Visualizations6.) Snowflake SQL - Beginner to Expert LevelA lot of companies are adopting Snowflake as their Data Warehouse and migrating data from disparate sources to it. Because of Snowflake's architecture, companies are saving their costs as Snowflake separates storage and compute costs. Also, you have to pay for what you use on Snowflake. There is no overhead cost on top of it.Along with this, companies get a lot of advantages with respect to setting up Snowflake. - They just have to create Snowflake account- No hardware setup is required- No software is required to run snowflake- No installation is needed- Users does not need to bother about their infrastructure, Snowflake takes care of it perfectly by themselves.- Snowflake provides default security on data such as encryption of data at rest and in transit.And many more….You will get downloadable one-stop-shop for all the resources used in this Masterclass–––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––********************   By end of this course, you will be able to work as an Snowflake Expert   ********************–––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\I am sure you would enjoy learning Snowflake with me. :)In case you don't then you can take benefit of 30 days money-back guarantee within first 30 days and i would be happy to refund your money.////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////About Me:I am Kashish Gakkar, a Senior Data Engineer holding more than 7years of experience. I have experience on various skills and technologies related to:        - ETL        - Data Warehousing        - Data Science/Analytics        - Business Intelligence        - Big Data        - Cloud Technologies : AWS & AZURE        - Programming Expertise : Python, SAS, etc.––––- HAPPY LEARNING & KEEP GROWING ––––-

Overview

Section 1: Introduction

Lecture 1 Know your Instructor

Lecture 2 Introduction to Snowflake

Lecture 3 Create Free Snowflake Account

Lecture 4 Download Resources for this course

Section 2: Deep Dive into Snowflake

Lecture 5 Different Roles in Snowflake

Lecture 6 Explore - Databases, Schemas and Tables

Lecture 7 Snowflake Architecture

Lecture 8 Virtual Warehouses (Compute Engine) - Intro

Lecture 9 Virtual Warehouses - Standard vs Economy Scaling policy

Section 3: Snowflake Pricing

Lecture 10 Snowflake Pricing - Overview

Lecture 11 What are Snowflake Credits

Lecture 12 Snowflake Editions

Lecture 13 Serverless Features cost

Lecture 14 Storage Cost

Lecture 15 Choose Storage type wisely

Lecture 16 Check storage cost for different regions

Lecture 17 Virtual Warehouses - Compute Cost

Lecture 18 Cloud Services Cost

Lecture 19 Data Transfer Cost

Lecture 20 Check consumed CREDITS on your account

Lecture 21 Queries to check consumption

Lecture 22 Optimization Methods to reduce cost

Section 4: Resource Monitors - Track Compute Consumption

Lecture 23 Resource Monitors - Introduction

Lecture 24 Properties of Resource Monitor

Lecture 25 Actions or Triggers of Resource Monitors

Lecture 26 Suspension or Resumption

Lecture 27 Detailed Example - How Resource Monitors work

Lecture 28 Create a Resource Monitor using WebUI

Lecture 29 SQL queries to Create Resource Monitor

Section 5: Micro-Partitioning in Snowflake

Lecture 30 Partitioning in Traditional Data Warehouses

Lecture 31 Partitioning in Snowflake - Micro Partitioning

Lecture 32 Advantages of Micro-Partitioning

Lecture 33 Structure of Micro-Partition

Lecture 34 Query Processing in Snowflake

Section 6: Clustering in Snowflake

Lecture 35 Clustering Introduction

Lecture 36 Clustering Keys

Lecture 37 Clustering Metadata

Lecture 38 Clustering Depth

Lecture 39 Automatic Re-clustering

Section 7: Query History & Caching

Lecture 40 Query History

Lecture 41 Detailed Lab - Query History

Lecture 42 SQL Queries to fetch Query History

Lecture 43 Caching in Snowflake

Lecture 44 Caching - Detailed using Examples

Lecture 45 Lab - Results Cache

Section 8: Jump into Code

Lecture 46 Worksheets - Databases, Schemas, Tables, etc.

Lecture 47 Setting up Context/Parameters for worksheet

Lecture 48 Run first SQL statement

Lecture 49 More about Worksheet's Results section

Section 9: Load data from AWS (Amazon Web Services)

Lecture 50 Create Free AWS Account

Lecture 51 What is AWS s3 and how to create buckets under it

Lecture 52 What is IAM (Identity & Access Management)

Lecture 53 Create an IAM Group

Lecture 54 Create IAM User

Lecture 55 Create AWS IAM Role

Lecture 56 Upload data to AWS s3 using web console

Lecture 57 Load Data - 1st Step | Create Table Schema

Lecture 58 Load Data - 2nd Step | Create Integration object - 1

Lecture 59 Load Data - 2nd Step | Create Integration object - 2

Lecture 60 Loading CSV Data to snowflake using COPY command

Lecture 61 Load Complete CSV data from S3

Lecture 62 Load Parquet data - Part 1

Lecture 63 Load Parquet data - Part 2

Lecture 64 View Stages and File formats

Lecture 65 Load JSON Data from AWS S3

Section 10: Snowpipe - Continuous Data Ingestion Service

Lecture 66 Introduction to Snowpipe

Lecture 67 Load CSV Data from s3 using Snowpipe

Lecture 68 Load PARQUET Data from s3 using Snowpipe

Lecture 69 Load JSON Data from s3 using Snowpipe

Section 11: Load data from Microsoft Azure

Lecture 70 Load data from Azure - Overview

Lecture 71 Create Azure Trial Account - FREE

Lecture 72 Azure Infrastructure Hierarchy

Lecture 73 Create storage account

Lecture 74 Load data on Azure data lake

Lecture 75 Create integration and stage objects

Lecture 76 Load CSV data from Azure data lake

Lecture 77 Load Parquet data from Azure

Section 12: Different Types of Tables

Lecture 78 Different Types of Tables

Lecture 79 Create Permanent & Transient Database

Lecture 80 Create Permanent & Transient Schema

Lecture 81 Create Temporary, Permanent & Transient Table

Lecture 82 Convert Table to a Different type

Section 13: Time Travel - Work with history of Objects

Lecture 83 What is Time Travel - Detailed

Lecture 84 Set & Alter Retention Time Property

Lecture 85 Query Historical Results

Lecture 86 Clone Historical Objects

Lecture 87 Restore the Dropped Objects [IMP]

Section 14: Fail Safe - A Recovery Area

Lecture 88 What is Failsafe - Detailed Overview

Lecture 89 Check Failsafe Storage Consumption

Section 15: Tasks In Snowflake - Scheduling Service

Lecture 90 Introduction to Tasks

Lecture 91 What is a Tree of Tasks

Lecture 92 How to implement a Standalone Task

Lecture 93 Detailed Lab on Tree of Tasks

Lecture 94 Call Stored Procedures using Tasks

Lecture 95 Check Tasks History

Section 16: Snowflake Streams - Change Data Capture(CDC)

Lecture 96 Introduction to Streams

Lecture 97 How Streams work under the hood

Lecture 98 Capture & Process INSERT Operations

Lecture 99 Capture & Process UPDATE Operations

Lecture 100 Capture & Process DELETE Operations

Lecture 101 How streams work within a Transaction

Section 17: Zero-Copy Cloning

Lecture 102 What is Zero-Copy Cloning

Lecture 103 Clone Database, Pipes, Streams, Tasks & Stages

Lecture 104 Clone Schema & Tables

Lecture 105 DML changes in Cloned table

Lecture 106 Cloning Table Storage Metrics

Lecture 107 Cloning Using Time Travel

Lecture 108 Swap the Tables

Section 18: Secure Data Sharing

Lecture 109 Secure Data Sharing - Section Overview

Lecture 110 Data Sharing - Definition

Lecture 111 Provider and Consumer Accounts

Lecture 112 Allowed list of objects to Share

Lecture 113 How Data Sharing works on Snowflake

Lecture 114 Data Sharing - Architecture

Lecture 115 Create First share - Hands On

Lecture 116 Share data with other Snowflake accounts

Lecture 117 Consume shared data on Consumer accounts

Lecture 118 Cloning on Shared Databases

Lecture 119 More on Consuming data from Shares

Lecture 120 Adding or removing consumer accounts from shares

Lecture 121 Revoke and Grant privilege to consumer accounts

Lecture 122 Drop Shares

Section 19: Materialized Views on Snowflake

Lecture 123 SQL Views - Refresher

Lecture 124 Materialized Views - Introduction

Lecture 125 Materialized Views - When to create

Lecture 126 Materialized Views - Advantages

Lecture 127 Materialized Views - Limitations

Lecture 128 Materialized Views - Hands On

Lecture 129 Important Metadata Columns

Lecture 130 When MVs becomes Invalid

Lecture 131 Materialized Views - Refresh History

Lecture 132 Materialized Views - Clustering and ReClustering

Section 20: Secure Views on Snowflake

Lecture 133 Secure Views - Introduction

Lecture 134 Secure Views - Hands On (Part 1)

Lecture 135 Secure Views - Hands On (Part 2)

Lecture 136 Fetch metadata information about Views

Section 21: *** Mini Project - Setup Row Level Security ***

Lecture 137 Understand the Requirements

Lecture 138 Set up Users and Custom Roles

Lecture 139 Grant Privileges to custom Roles

Lecture 140 Apply Row-Level Security

Lecture 141 Test Row-Level Security

Section 22: Security - Dynamic Data Masking: Column level security

Lecture 142 Data Masking - Introduction

Lecture 143 Data Masking - Detailed overview

Lecture 144 Data Masking - Hands on

Lecture 145 Recreate and Unset Masking Policy

Lecture 146 Apply Masking policies on Views

Lecture 147 Alter Masking Policies

Section 23: Snowflake Partner Connect

Lecture 148 Introduction to Partner Connect

Lecture 149 Know about available Tools

Lecture 150 Start Free Trial for Matillion ETL

Section 24: Snowflake SQL - DDL (Data Definition Language)

Lecture 151 Intro to Snowflake SQL

Lecture 152 Intro to Data Definition Language (DDL)

Lecture 153 Create Virtual Warehouse

Lecture 154 Create Database, Schema & Table

Lecture 155 Create File Format and Stage object

Lecture 156 Create Views

Lecture 157 Alter Virtual Warehouse

Lecture 158 Working with Roles and Users

Lecture 159 Alter Database, Schema and Table

Lecture 160 Drop Statement

Lecture 161 Truncate and Comment

Section 25: Snowflake SQL - DML(INSERT/DELETE/UPDATE) & DQL(Query Language - SELECT)

Lecture 162 Keywords to Fetch Data and their precedence

Lecture 163 SELECT Statement-I

Lecture 164 SELECT Statement-II

Lecture 165 SELECT Statement-III

Lecture 166 Comment your SQL statements

Lecture 167 Operators

Lecture 168 WHERE with AND operator

Lecture 169 WHERE with OR operator

Lecture 170 Arithmetic Operators

Lecture 171 Comparison Operators

Lecture 172 Logical Operators (IN and NOT IN)

Lecture 173 Logical Operators (BETWEEN)

Lecture 174 Logical Operators (LIKE)

Lecture 175 Logical Operators (CONTAINS)

Lecture 176 Distinct Keyword

Lecture 177 Limit and Offset Keywords

Lecture 178 Group By Clause

Lecture 179 Order By Clause

Lecture 180 Having Clause

Lecture 181 SQL Joins - Intro

Lecture 182 Joins Explanation - Detailed

Lecture 183 Insert, Delete and Update Operations

Lecture 184 Joins - Left Join

Lecture 185 Joins - Right, Inner & outer

Lecture 186 Joins - Self Join

Section 26: Snowflake SQL - Sub-queries & Case Statements

Lecture 187 Sub-query Introduction

Lecture 188 Sub-query with From Clause

Lecture 189 Sub-query with Where Clause

Lecture 190 Sub-query with HAVING

Lecture 191 Joins & Sub-queries – Interview Question*

Lecture 192 CASE Statement - Part 1

Lecture 193 CASE Statement - Part 2

Lecture 194 CASE Statement with Order by Clause

Section 27: Snowflake SQL - Set Operators (UNION, UNION ALL, INTERSECT, EXCEPT, MINUS)

Lecture 195 UNION Clause

Lecture 196 UNION ALL Clause

Lecture 197 INTERSECT Clause

Lecture 198 MINUS and EXCEPT Clause

Section 28: Snowflake SQL - Working with Row Numbers & Information Schema

Lecture 199 Working with Rows Numbers - Sequences

Lecture 200 Working with Rows Numbers - Identity

Lecture 201 Working with Rows Numbers - Auto Increment

Lecture 202 Working with Rows Numbers - ROW_NUMBER() function

Lecture 203 Metadata tables - Information Schema

Lecture 204 Different ways to make a copy of Table

Section 29: Snowflake SQL - Functions & Transactions

Lecture 205 Functions - Intro

Lecture 206 Functions - ABS, Ceil, Floor, Coalesce

Lecture 207 Functions - String Functions

Lecture 208 Functions - Date Functions

Lecture 209 Functions - System Functions

Lecture 210 Transaction, Commit and Rollback

Section 30: Work with Snowflake's Python API - Automation stuff

Lecture 211 Download Python and Anaconda

Lecture 212 Install Python or Anaconda

Lecture 213 IDEs - Jupyter Notebook and Spyder

Lecture 214 Install snowflake-connector-python

Lecture 215 Connect to Snowflake using Python

Lecture 216 How to mask your password

Lecture 217 Store results in a Pandas Dataframe

Section 31: Visualizations - Working with Tableau and Snowflake

Lecture 218 Download Tableau Desktop

Lecture 219 Connect Tableau with Snowflake

Lecture 220 How to get Tableau License for Free

Section 32: Visualizations - Working with PowerBI and Snowflake

Lecture 221 Download PowerBI Desktop

Lecture 222 Connect Snowflake with PowerBI

Lecture 223 Create Graphs & Charts

Section 33: Minor Project - 1: Expose Snowflake Data by Creating Python API

Lecture 224 Project Requirements

Lecture 225 Connecting Snowflake Using Python

Lecture 226 Use Snowflake Parameters for Python Session

Lecture 227 Defining Main function to fetch data

Lecture 228 Create a Flask API

Lecture 229 Test API using Postman

Section 34: BONUS!! - CERTIFICATION PRACTICE TESTS

Data Engineers who are looking to expand their horizon,Data Analysts & Data Scientists: To make data ready on snowflake to perform Analytics on it,Any person who is interested to learn Snowflake from Beginner to Expert level,Students or any working professionals who are looking for upskilling themselves