Snowflake – The Complete Masterclass (2023 Edition)

سرفصل های دوره

Master Snowflake & cloud data warehouse from the ground up

01 - Introduction

001 Welcome!

002 Course Outline

003 How to benefit best from the course

004 AllCourseSlides.pdf

004 All course slides & resources.html

004 All-resources.zip

02 - Getting started

001 Sign up for free trial

002 Login to account

003 Create-a-database.txt

003 Getting to know the interface

004 Snowflake architecture

005 Setting up warehouse

006 Setting up warehouse using SQL

007 Scaling policy

008 Exploring tables & databases

009 Loading data in snowflake

009 Loading-data.txt

03 - Snowflake architecture

001 What is a data warehouse

002 Cloud computing

003 Snowflake editions

004 Snowflake pricing

005 Monitor Usage

006 Roles in snowflake

04 - Loading data

001 Loading methods

002 Understanding stages

003 Create-Stage.txt

003 Creating stage

004 COPY command

004 COPY-Command.txt

005 Transforming data

005 Transforming-data.txt

006 More transformations

006 More-transformations.txt

007 Copy option ON ERROR

007 Copy-options-ON-ERROR.txt

008 FileFormat.xlsx

008 File format object

008 File-Format.txt

009 Summary

05 - Copy options

001 Understanding copy options

002 VALIDATION MODE

002 VALIDATION-MODE.txt

003 Rejected-records.txt

003 Working with rejected records

004 SIZE LIMIT

004 SIZE-LIMIT.txt

005 RETURN FAILED ONLY

005 RETURN-FAILED-ONLY.txt

006 TRUCATECOLUMNS.txt

006 TRUNCATECOLUMNS

007 FORCE

007 FORCE.txt

008 Load history

008 Load-history.txt

06 - Loading unstructured data

001 High-level steps

002 Our data

002 hr-data.zip

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

003 Creating stage & raw file

004 Parse-Analyze-JSON-2.txt

004 Parsing JSON

005 Handling nested data

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

006 Dealing with hierarchy

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

007 Insert final data

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

008 Parquet-data-1.txt

008 Querying PARQUET data

008 daily-sales-items-top105.zip

009 Loading PARQUET data

009 Parquet-data-2.txt

009 daily-sales-items-top105.zip

07 - Performance optimization

001 Performance in Snowflake

002 Create dedicated virtual warehouse

003 Dedicated-VW.txt

003 Implement dedicated virtual warehouse

004 Scaling up

005 Scaling out

005 Scaling-Out.txt

006 Caching - Theory

007 Caching.txt

007 Maximize Caching

008 Clustering - Theory

009 Clustering.txt

009 Clustering - Practice

08 - Loading from AWS

001 Sign up for free trial

002 Creating S3 bucket

003 Upload files in S3

003 musical-instruments-5.zip

003 netflix-titles.csv

004 Creating policy

005 Create-Storage-integration.txt

005 Creating integration object

006 Loading from S3

006 Load-data-from-S3.txt

007 Handle JSON

007 Handling-JSON.txt

09 - Loading from Azure

001 Sign up for free trial

002 Create a storage account

003 Create a container

003 carmodels.zip

003 world-happiness-report-2021.csv

004 Create integration object

004 Create-Integration.txt

005 Create stage object

005 Create-Stage.txt

006 Load CSV file

006 Load-CSV.txt

007 Load JSON file

007 Load-JSON.txt

10 - Loading from GCP

001 Sign up for free trial

002 Create a bucket

002 carmodels.zip

002 world-happiness-report-2021.csv

003 Create integration object

003 Create-integration-object.txt

004 Create stage

004 Create-stage.txt

005 Query & load data

005 Query-Load-data.txt

006 Unload data

006 Unload-data.txt

11 - Snowpipe

001 What is Snowpipe

002 High-level steps

003 Creating stage

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

003 employee-data-1.csv

004 Create-pipe.txt

004 Creating pipe

005 Configure pipe & notifications

005 employee-data-2.csv

006 Error handling

006 Error-handling.txt

006 employee-data-3.csv

006 employee-data-4.csv

007 Manage pipes

007 Manage-pipes.txt

12 - Snowpipe for Azure

001 High-level steps

002 Create stage & storage integration

002 Create-Stage-and-integration.txt

003 Create notification integration

003 Create-notification-Integration.txt

004 Create pipe and load data

004 Create-Pipe.txt

004 word-happiness-report-2021.csv

13 - Time Travel

001 Using time travel

001 Using-time-travel.txt

002 Restoring data

002 Restoring-in-time-travel.txt

003 UNDROP tables

003 Undrop.txt

004 Retention time

005 Time travel cost

005 Time-travel-cost.txt

14 - Fail Safe

001 Understanding Fail Safe

002 Fail Safe storage

002 Fail-Safe-Storage.txt

15 - Types of tables

001 Different table types

002 Permanent tables & databases

002 Permanent-tables.txt

003 Transient tables & databases

003 Transient-tables.txt

004 Temporary tables & databases

004 Temporary-tables.txt

16 - Zero-Copy Cloning

001 Understanding Zero-Copy Cloning

002 Cloning tables

002 Cloning-tables.txt

003 Cloning schemas & databases

003 Cloning-Schemas-Databases.txt

004 Cloning with time travel

004 Cloning-using-time-travel.txt

005 Swapping tables

17 - Data Sharing

001 Understanding data sharing

002 Using data sharing

002 Using-data-sharing.txt

003 Create share through the interface

004 Sharing with non-snowflake users

005 Create-reader-account.txt

005 Creating a reader account

006 Creating a database from share

007 Set up users for share

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

008 Sharing database & schema

009 Secure vs. normal view

009 Secure-view.txt

010 Sharing a secure view

010 Sharing-views.txt

18 - Data Sampling

001 Why data sampling

002 Methods of data sampling

003 Data-Sampling.txt

003 Sampling data Hands-on

19 - Scheduling Tasks

001 Understanding tasks

002 Creating tasks

002 Creating-Tasks.txt

003 Using CRON

003 Using-CRON.txt

004 Understand tree of tasks

005 Creating trees of tasks

005 Creating-tree-of-tasks.txt

006 Calling a stored procedure

006 Task-with-stored-procedure.txt

007 Task history & error handling

007 Task-history.txt

008 Tasks with condition

20 - Streams

001 Understanding streams

002 INSERT operation

002 Insert.txt

003 UPDATE operation

003 Update.txt

004 DELETE operation

004 Delete.txt

005 Process all data changes

005 Process-all-data-changes.txt

006 Combine streams & tasks

006 Streams-tasks.txt

007 Types of streams

007 Types-of-stream.txt

008 Changes clause

008 Change-clause.txt

21 - Materialized Views

001 Understand materialized views

002 Create-materialized-view.txt

002 Using materialized views

003 Refresh materialized views

003 Refresh-in-materialized-views.txt

004 Maintenance costs

004 Maintenance-costs.txt

005 When to use materialized views

006 Limitations

22 - Dynamic Data Masking

001 Understanding data masking

002 Create-masking-policy.txt

002 Creating a masking policy

003 Unset & replace policy

003 Unset-replace-policy.txt

004 Alter an existing policy

004 Alter-existing-policies.txt

005 Real life examples

005 Real-life-examples.txt

23 - Access Management

001 Key concepts

002 Roles overview

003 ACCOUNTADMIN

004 ACCOUNTADMIN.txt

004 ACCOUNTADMIN in practice

005 SECURITYADMIN

006 SECURITYADMIN.txt

006 SECURITYADMIN in practice

007 SYSADMIN

007 SYSADMIN.txt

008 SYSADMIN.txt

008 SYSADMIN in practice

009 Custom roles

010 Custom roles in practice

010 Custom-roles.txt

011 USERADMIN

012 USERADMIN.txt

012 USERADMIN in practice

013 PUBLIC

24 - Visualization - Power BI & Tableau

001 Data Visualization

002 Download & install Power BI

003 Connect Power BI & Snowflake

004 Working in Power BI

005 Download & install Tableau

006 Connect Tableau & Snowflake

25 - Partner Connect - Connecting other tools

001 Connecting to other tools

002 Connect to ETL tool

26 - Best Practises

001 Best practices

002 Virtual warehouses

003 Table design

004 Monitoring

004 Monitoring-Resources.txt

005 Retention period

27 - Bonus

001 Bonus lecture.html

179,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy