SnowflakeAZ Zero to Hero MasterclassCoreSQLAPIVisual
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
Course Information:
Udemy | English | 17h 57m | 5.97 GB
Created by: Kashish Gakkar
You Can See More Courses in the Developer >> Greetings from CourseDown.com