Snowflake – The Complete Masterclass (2023 Edition)

Focused View

Nikolai Schuler

13:59:55

46 View

01 - Introduction

001 Welcome!.mp4

00:35

002 Course Outline.mp4

02:51

003 How to benefit best from the course.mp4

04:25

004 AllCourseSlides.pdf

004 All course slides & resources.html

004 All-resources.zip

02 - Getting started

001 Sign up for free trial.mp4

03:24

002 Login to account.mp4

02:50

003 Create-a-database.txt

003 Getting to know the interface.mp4

07:05

004 Snowflake architecture.mp4

07:59

005 Setting up warehouse.mp4

06:14

006 Setting up warehouse using SQL.mp4

06:16

007 Scaling policy.mp4

07:00

008 Exploring tables & databases.mp4

07:56

009 Loading data in snowflake.mp4

04:30

009 Loading-data.txt

03 - Snowflake architecture

001 What is a data warehouse.mp4

07:10

002 Cloud computing.mp4

03:57

003 Snowflake editions.mp4

04:49

004 Snowflake pricing.mp4

08:46

005 Monitor Usage.mp4

07:06

006 Roles in snowflake.mp4

05:57

04 - Loading data

001 Loading methods.mp4

02:44

002 Understanding stages.mp4

03:36

003 Create-Stage.txt

003 Creating stage.mp4

05:54

004 COPY command.mp4

07:48

004 COPY-Command.txt

005 Transforming data.mp4

08:00

005 Transforming-data.txt

006 More transformations.mp4

05:13

006 More-transformations.txt

007 Copy option ON ERROR.mp4

09:56

007 Copy-options-ON-ERROR.txt

008 FileFormat.xlsx

008 File format object.mp4

12:43

008 File-Format.txt

009 Summary.mp4

02:53

05 - Copy options

001 Understanding copy options.mp4

01:20

002 VALIDATION MODE.mp4

09:42

002 VALIDATION-MODE.txt

003 Rejected-records.txt

003 Working with rejected records.mp4

07:51

004 SIZE LIMIT.mp4

03:07

004 SIZE-LIMIT.txt

005 RETURN FAILED ONLY.mp4

02:59

005 RETURN-FAILED-ONLY.txt

006 TRUCATECOLUMNS.txt

006 TRUNCATECOLUMNS.mp4

03:42

007 FORCE.mp4

03:09

007 FORCE.txt

008 Load history.mp4

05:24

008 Load-history.txt

06 - Loading unstructured data

001 High-level steps.mp4

02:11

002 Our data.mp4

03:49

002 hr-data.zip

003 Create-Stage-Load-raw-JSON-1.txt

003 Creating stage & raw file.mp4

03:46

004 Parse-Analyze-JSON-2.txt

004 Parsing JSON.mp4

04:48

005 Handling nested data.mp4

07:01

005 Handling-nested-data-JSON-3.txt

006 Dealing with hierarchy.mp4

08:14

006 Dealing-with-hierarchy-JSON-4.txt

007 Insert final data.mp4

03:09

007 Insert-the-final-data-JSON-5.txt

008 Parquet-data-1.txt

008 Querying PARQUET data.mp4

10:25

008 daily-sales-items-top105.zip

009 Loading PARQUET data.mp4

04:08

009 Parquet-data-2.txt

009 daily-sales-items-top105.zip

07 - Performance optimization

001 Performance in Snowflake.mp4

04:23

002 Create dedicated virtual warehouse.mp4

04:53

003 Dedicated-VW.txt

003 Implement dedicated virtual warehouse.mp4

06:43

004 Scaling up.mp4

03:30

005 Scaling out.mp4

07:00

005 Scaling-Out.txt

006 Caching - Theory.mp4

01:45

007 Caching.txt

007 Maximize Caching.mp4

04:42

008 Clustering - Theory.mp4

08:36

009 Clustering.txt

009 Clustering - Practice.mp4

05:50

08 - Loading from AWS

001 Sign up for free trial.mp4

02:23

002 Creating S3 bucket.mp4

03:39

003 Upload files in S3.mp4

03:53

003 musical-instruments-5.zip

003 netflix-titles.csv

004 Creating policy.mp4

05:31

005 Create-Storage-integration.txt

005 Creating integration object.mp4

07:54

006 Loading from S3.mp4

06:56

006 Load-data-from-S3.txt

007 Handle JSON.mp4

10:53

007 Handling-JSON.txt

09 - Loading from Azure

001 Sign up for free trial.mp4

04:02

002 Create a storage account.mp4

05:03

003 Create a container.mp4

03:32

003 carmodels.zip

003 world-happiness-report-2021.csv

004 Create integration object.mp4

08:30

004 Create-Integration.txt

005 Create stage object.mp4

02:38

005 Create-Stage.txt

006 Load CSV file.mp4

04:34

006 Load-CSV.txt

007 Load JSON file.mp4

07:28

007 Load-JSON.txt

10 - Loading from GCP

001 Sign up for free trial.mp4

02:31

002 Create a bucket.mp4

03:24

002 carmodels.zip

002 world-happiness-report-2021.csv

003 Create integration object.mp4

04:15

003 Create-integration-object.txt

004 Create stage.mp4

02:02

004 Create-stage.txt

005 Query & load data.mp4

03:40

005 Query-Load-data.txt

006 Unload data.mp4

05:06

006 Unload-data.txt

11 - Snowpipe

001 What is Snowpipe.mp4

02:45

002 High-level steps.mp4

02:20

003 Creating stage.mp4

03:50

003 Setting-up-stage-and-pipe.txt

003 employee-data-1.csv

004 Create-pipe.txt

004 Creating pipe.mp4

03:29

005 Configure pipe & notifications.mp4

05:49

005 employee-data-2.csv

006 Error handling.mp4

09:12

006 Error-handling.txt

006 employee-data-3.csv

006 employee-data-4.csv

007 Manage pipes.mp4

07:52

007 Manage-pipes.txt

12 - Snowpipe for Azure

001 High-level steps.mp4

03:05

002 Create stage & storage integration.mp4

07:55

002 Create-Stage-and-integration.txt

003 Create notification integration.mp4

07:57

003 Create-notification-Integration.txt

004 Create pipe and load data.mp4

05:56

004 Create-Pipe.txt

004 word-happiness-report-2021.csv

13 - Time Travel

001 Using time travel.mp4

09:58

001 Using-time-travel.txt

002 Restoring data.mp4

10:49

002 Restoring-in-time-travel.txt

003 UNDROP tables.mp4

08:35

003 Undrop.txt

004 Retention time.mp4

07:01

005 Time travel cost.mp4

04:07

005 Time-travel-cost.txt

14 - Fail Safe

001 Understanding Fail Safe.mp4

05:02

002 Fail Safe storage.mp4

05:38

002 Fail-Safe-Storage.txt

15 - Types of tables

001 Different table types.mp4

08:59

002 Permanent tables & databases.mp4

05:46

002 Permanent-tables.txt

003 Transient tables & databases.mp4

07:08

003 Transient-tables.txt

004 Temporary tables & databases.mp4

05:14

004 Temporary-tables.txt

16 - Zero-Copy Cloning

001 Understanding Zero-Copy Cloning.mp4

05:40

002 Cloning tables.mp4

03:36

002 Cloning-tables.txt

003 Cloning schemas & databases.mp4

05:10

003 Cloning-Schemas-Databases.txt

004 Cloning with time travel.mp4

05:11

004 Cloning-using-time-travel.txt

005 Swapping tables.mp4

04:36

17 - Data Sharing

001 Understanding data sharing.mp4

03:13

002 Using data sharing.mp4

07:52

002 Using-data-sharing.txt

003 Create share through the interface.mp4

05:24

004 Sharing with non-snowflake users.mp4

02:10

005 Create-reader-account.txt

005 Creating a reader account.mp4

04:45

006 Creating a database from share.mp4

04:31

007 Set up users for share.mp4

04:23

008 Share-entire-DB-or-schema.txt

008 Sharing database & schema.mp4

05:05

009 Secure vs. normal view.mp4

07:34

009 Secure-view.txt

010 Sharing a secure view.mp4

03:00

010 Sharing-views.txt

18 - Data Sampling

001 Why data sampling.mp4

03:24

002 Methods of data sampling.mp4

02:52

003 Data-Sampling.txt

003 Sampling data Hands-on.mp4

07:15

19 - Scheduling Tasks

001 Understanding tasks.mp4

01:29

002 Creating tasks.mp4

05:04

002 Creating-Tasks.txt

003 Using CRON.mp4

06:22

003 Using-CRON.txt

004 Understand tree of tasks.mp4

02:18

005 Creating trees of tasks.mp4

06:20

005 Creating-tree-of-tasks.txt

006 Calling a stored procedure.mp4

04:47

006 Task-with-stored-procedure.txt

007 Task history & error handling.mp4

06:08

007 Task-history.txt

008 Tasks with condition.mp4

04:56

20 - Streams

001 Understanding streams.mp4

07:22

002 INSERT operation.mp4

08:00

002 Insert.txt

003 UPDATE operation.mp4

06:48

003 Update.txt

004 DELETE operation.mp4

05:07

004 Delete.txt

005 Process all data changes.mp4

08:17

005 Process-all-data-changes.txt

006 Combine streams & tasks.mp4

05:04

006 Streams-tasks.txt

007 Types of streams.mp4

06:11

007 Types-of-stream.txt

008 Changes clause.mp4

05:49

008 Change-clause.txt

21 - Materialized Views

001 Understand materialized views.mp4

02:23

002 Create-materialized-view.txt

002 Using materialized views.mp4

06:06

003 Refresh materialized views.mp4

03:26

003 Refresh-in-materialized-views.txt

004 Maintenance costs.mp4

02:44

004 Maintenance-costs.txt

005 When to use materialized views.mp4

04:51

006 Limitations.mp4

01:47

22 - Dynamic Data Masking

001 Understanding data masking.mp4

01:45

002 Create-masking-policy.txt

002 Creating a masking policy.mp4

06:08

003 Unset & replace policy.mp4

06:34

003 Unset-replace-policy.txt

004 Alter an existing policy.mp4

02:29

004 Alter-existing-policies.txt

005 Real life examples.mp4

05:47

005 Real-life-examples.txt

23 - Access Management

001 Key concepts.mp4

06:45

002 Roles overview.mp4

03:17

003 ACCOUNTADMIN.mp4

02:56

004 ACCOUNTADMIN.txt

004 ACCOUNTADMIN in practice.mp4

05:56

005 SECURITYADMIN.mp4

00:43

006 SECURITYADMIN.txt

006 SECURITYADMIN in practice.mp4

05:42

007 SYSADMIN.mp4

01:26

007 SYSADMIN.txt

008 SYSADMIN.txt

008 SYSADMIN in practice.mp4

06:50

009 Custom roles.mp4

01:29

010 Custom roles in practice.mp4

04:59

010 Custom-roles.txt

011 USERADMIN.mp4

01:17

012 USERADMIN.txt

012 USERADMIN in practice.mp4

03:15

013 PUBLIC.mp4

01:44

24 - Visualization - Power BI & Tableau

001 Data Visualization.mp4

01:18

002 Download & install Power BI.mp4

02:55

003 Connect Power BI & Snowflake.mp4

06:10

004 Working in Power BI.mp4

03:02

005 Download & install Tableau.mp4

01:53

006 Connect Tableau & Snowflake.mp4

04:32

25 - Partner Connect - Connecting other tools

001 Connecting to other tools.mp4

02:33

002 Connect to ETL tool.mp4

03:13

26 - Best Practises

001 Best practices.mp4

01:40

002 Virtual warehouses.mp4

05:10

003 Table design.mp4

06:24

004 Monitoring.mp4

05:11

004 Monitoring-Resources.txt

005 Retention period.mp4

03:47

27 - Bonus

001 Bonus lecture.html

Description

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

Who is this for?

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

What You Need to Know?

Laptop with access to the internet & motivation to learn

Basic knowledge of SQL is helpful

More details

Description
Do you want to upgrade your skills and learn how to work with Snowflake professionally?
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 & assignments

What 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 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 learned in a lot of assignments & quizzes
âœ“ Personal support whenever you have questions

This 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 already have 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 lifelong access and master Snowflake!

Not provided by, affiliated with, or sponsored by Snowflake Inc.
Who this course is for:
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

User Reviews

Rating

average 0

Total votes0

Focused display

Data Science

Nikolai Schuler

Instructor's Courses

Are you thinking about pursuing a career as a Data Analyst or Data Scientist?Do you ever think that your career could take a leap forward if you would have more knowledge and skills in the world of data? Perhaps you are even feeling overwhelmed by the number of courses available or by the fact that your life is already too full to concentrate on one more course?I am Nikolai Schuler, I am a data scientist and BI consultant, and I have been there too... A few years ago I noticed that the world of data benefits from many new tools and technologies. However, I also realized that it is extremely difficult to get trained in the field: Practical courses with real quality content are rare and are often structured in such a way that they are incompatible with a working life full of other tasks and activities. While going through hours of research and training, I came up with the idea of creating a course that would offer extremely valuable content but that would be at the same time easy to follow due to its structure. My goal is to help as many people as possible to pursue their desired career in this new Digital Age by enabling them to upgrade their data analysis skills. I am proud to say that I am heading in the right direction as my courses have already found their audience in over 170 countries and received thousands of positive feedbacks.I am super excited about equipping you with the skillset to master Data Science and Data Analytics! If you are looking for quality AND approachable training, then jump onboard! I am really looking forward to leveling up your IT skills.-- German version --In meiner Arbeit als Data Scientist sehe ich, dass in der heutigen Zeit neue Tools riesige Vorteile bringen und sie nicht mehr wegzudenken sind. Allerdings sehe ich auch, dass es nicht immer leicht ist, sich neben der täglichen Arbeit in diese neuen Tools einzuarbeiten.Mir selbst ist es auch schwer gefallen Kurse zu finden, die einerseits qualitativ hochwertig und andererseits verständlich und gut strukturiert sind.Aus diesem Grund habe ich mich dazu entschlossen, selbst strukturierte und praxisorientierte Kurse zu erstellen.Da ich sowohl für einfache Anwender als auch für Datenspezialisten Einweisungen in Power BI und anderen Tools gebe, bin ich einerseits technischer Spezialist, habe aber andererseits auch ein gutes Gefühl für die, die nicht die reinen Datenspezialisten sind.Mir zu überlegen, wie man das Wissen wirklich sinnvoll und verständlich vermitteln kann, ist das, was mir dabei Freude macht.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.