Tags
Language
Tags
June 2025
Su Mo Tu We Th Fr Sa
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30 1 2 3 4 5
    Attention❗ To save your time, in order to download anything on this site, you must be registered 👉 HERE. If you do not have a registration yet, it is better to do it right away. ✌

    ( • )( • ) ( ͡⚆ ͜ʖ ͡⚆ ) (‿ˠ‿)
    SpicyMags.xyz

    Snowflake – The Complete Masterclass (2022 Edition)

    Posted By: ELK1nG
    Snowflake – The Complete Masterclass (2022 Edition)

    Snowflake – The Complete Masterclass (2022 Edition)
    Last updated 12/2022
    MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
    Language: English | Size: 5.15 GB | Duration: 15h 39m

    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