Snowflake for Data Science and Data Engineering - 2024

Focused View

Kasper Peysepar,Yuan Guo

6:54:21

15 View

1. Snowflake Setup

1. Sign up for a free account.mp4

02:43

2. Snowsight tour - Overview.mp4

03:35

3. Snowsight tour - Dashboards.mp4

04:43

4. Snowsight tour - Worksheets.mp4

05:21

5.1 context functions.zip

5. Context functions and Account Info.mp4

05:26

2. Core Concepts

1. Snowflake architecture.mp4

08:39

2.1 virtual warehouses.zip

2. Virtual Warehouses.mp4

07:26

3. Snowflake Core Concepts.html

3. Snowflake SQL

1. Snowflake SQL, Snowflake Scripting, SnowSQL.mp4

04:17

2. SQL Statement Types.mp4

02:22

3.1 ddl.zip

3. DDL Statements.mp4

15:37

4.1 column constraints.zip

4. Column Constraints.mp4

10:12

5.1 dml.zip

5. DML Statements.mp4

14:34

6. Snowflake SQL.html

4. Access Control and DCL Statements

1. Access Control in Snowflake.mp4

06:34

2.1 access control.zip

2. System-defined and Custom Roles.mp4

11:02

3.1 access control.zip

3. Users and additional DCL statements.mp4

05:57

4.1 access control.zip

4. Best Practices in Access Control.mp4

04:45

5. Extend the default Snowflake Role Hierarchy System with Customer Roles.html

5. Load Data to Snowflake

1. Load overview.mp4

03:30

2.1 customer 10 pipe.csv

2.2 customer 50.csv

2.3 customer 50.zip

2.4 load using ui.zip

2. Load using the UI.mp4

05:45

3.1 bulk load-copy into.zip

3.2 customer 10 and 2 bads.csv

3.3 customer 10 pipe.csv

3.4 customer 50.csv

3.5 customer 50.zip

3.6 customer 51 100.csv

3. Bulk load - COPY INTO.mp4

15:52

4.1 stages.zip

4. Stage Objects.mp4

05:57

5.1 aws integration.zip

5.2 IAM Policies.txt

5. Option 1 - Connect to AWS by Storage Integration.mp4

11:44

6.1 aws integration.zip

6. Option 2 - Connect to AWS by IAM User Credentials.mp4

03:16

7.1 customer 10.csv

7.2 transformation.zip

7. Load with Transformation.mp4

07:30

8. Load Data to Snowflake.html

6. DQL statements

1.1 query syntax.zip

1. Query Syntax.mp4

04:33

2.1 joins.zip

2. Joins.mp4

11:22

3.1 aggregation.zip

3. Aggregation.mp4

10:27

4. Window functions Concepts.mp4

03:39

5.1 window functions.zip

5. Window functions Cumulative and Sliding Window Frames.mp4

12:00

6.1 window functions.zip

6. More Window Functions.mp4

08:07

7.1 common table expressions.zip

7. Common Table Expressions.mp4

08:08

8.1 set operators.zip

8. Set operators.mp4

02:23

9.1 session variables.zip

9. Session Variables and SELECT INTO.mp4

02:14

10.1 pivot and unpivot.zip

10. Pivot and Unpivot.mp4

04:22

11. Query Syntax & Window Functions.html

7. Data Types and Common Functions

1.1 strings.zip

1. Strings.mp4

07:27

2.1 numbers.zip

2. Numbers.mp4

10:07

3.1 date time timestamp.zip

3. Date, Time, Timestamp.mp4

14:50

4.1 scalar functions overview.zip

4. Scalar Functions Overview - Conditional Functions.mp4

09:01

5.1 conversion functions.zip

5. Conversion Functions.mp4

04:42

6.1 string functions.zip

6. String Functions.mp4

07:03

7.1 numeric functions.zip

7. Numeric Functions.mp4

02:59

8.1 temporal functions.zip

8. Temporal Functions.mp4

06:02

9. Data Types and Common Functions.html

8. Data Recovery

1. Retention Period and Fail-safe - Theory.mp4

02:01

2.1 time travel and data retention period.zip

2. Time Travel and Data Retention Period.mp4

10:41

3. Data Recovery Quiz.html

9. Secure Data Sharing

1. Listing, Marketplace, Direct Share - Theory.mp4

06:38

2.1 creating direct share.zip

2. Creating Direct Share.mp4

10:29

3.1 secure views.zip

3. Secure Views.mp4

04:28

4. Secure Data Sharing Quiz.html

10. Stored Procedures

1.1 snowflake scripting.zip

1. Snowflake Scripting.mp4

05:23

2.1 stored procedures.zip

2. Stored Procedures.mp4

07:07

3.1 resultsets and cursors.zip

3. Resultsets and Cursors.mp4

06:57

4.1 error handling.zip

4. Error Handling.mp4

05:55

5.1 stored procedures using python.zip

5. Store Procedures Using Python.mp4

04:53

6. Store Procedures.html

11. Tasks

1. Tasks - Theory.mp4

02:25

2.1 tasks.zip

2. Tasks.mp4

12:34

3.1 dag of tasks.zip

3. DAG of Tasks.mp4

09:03

4. Snowflake Tasks.html

12. Streams

1. Streams - Theory.mp4

05:34

2.1 consuming streams.zip

2. Consuming Streams.mp4

11:00

3.1 stream behavior and additional tips.zip

3. Stream Behavior and Additional Tips.mp4

07:53

4.1 streams and tasks.zip

4. Streams and Tasks.mp4

05:07

5. Streams.html

13. To be deleted Snowpipe

1. Snowpipe.html

2. Benefit from Information Schema.html

3. Access History.html

14. To be deleted Semi-structured Data Types

1. Variant.html

2. Array.html

3. JSON.html

4. XML.html

5. Flatten Function.html

15. To be deleted Snowflake Dashboards

1. Create dashboards.html

2. Data Visualization.html

3. Share worksheets.html

16. To be deleted Introduction

1. Why learn Snowflake.html

2. Course resources and tips.html

3. Roles.html

4. SQL under the hood.html

5. Random sampling.html

6. Extend the default Snowflake Role Hierarchy System with Customer Roles.html

Description

A compact course on Snowflake data platform and Snowflake SQL

What You'll Learn?

Learn Snowflake SQL commands, functions, and data types
Learn Snowflake architecture and core concepts
Learn advanced Snowflake features and performance optimization
Learn development skills for building Data Pipelines using Snowflake

Who is this for?

For a wide range of professionals using Snowflake. Data Engineers, Data Scientists, Data Analysts, Software Developers are to name a few roles this course can help excel in their jobs.

What You Need to Know?

This course accommodates all levels of experience, and covers the Snowflake skills from the ground up. Data Warehousing and Programming background helps with faster learning, but is not required.

More details

Description
This course is for:

Software developers (Data Engineers, ETLÂ developers, backend developers, etc.) who need to build modern data applications using Snowflake.
Data Scientists (and other analytical roles of Data Analysts, Business Intelligence developers, etc.) who need to build data models and AIÂ applications using Snowflake.
None-ITÂ Analysts who want to query Snowflake and derive insight from residing data.
Managers and business directors who need to understand the technical and maintenance aspects of switching to an Snowflake platform.
Hard-working students who want to learn SQLÂ in a principled manner and want to write clean code.

My co-instructor and IÂ have put our Data Engineering, Data Modeling, and Software Development backgrounds into creating this course that beyond teaching Snowflake features, it covers fundamental SQL topicsÂ from the ground up.

We cover topics including but not limited to this list:

Snowflake:

Snowsight tour
Snowflake SQL
Snowflake Scripting
Stored Procedures using SQL and Python
Error handling
Data recovery
Time travel
Zero-copy cloning
Snowflake architecture
Streams
Tasks
DAG of tasks
Access control
Manage custom roles and users
Secure Data Sharing
Storage integrations
Creating IAMÂ roles and users to connect to AWS
Stage types (internal stages of named, user, and table types, and external stages)
Load during transformations
Table functions
Context functions

SQL:

DDLÂ statements in Snowflake
Data types in Snowflake
Referential integrity enforcement
Scalar functions with common functions to work with
String data types
Temporal data types
Numeric data types
Context functions
Window functions
Common Table Expressions
Aggregations
Joins
Set operators
Pivot and Unpivot

And we constantly add new topics to the course to keep it the most comprehensive Snowflake video tutorial on Udemy.
Who this course is for:
For a wide range of professionals using Snowflake. Data Engineers, Data Scientists, Data Analysts, Software Developers are to name a few roles this course can help excel in their jobs.

User Reviews

Rating

average 0

Total votes0

Focused display

Data Science

Kasper Peysepar

Instructor's Courses

As a Data Engineer and Architect, I have helped large companies engineer petabyte-scale data platforms. I want to share my knowledge to help smart individuals like yourself enjoy a faster and smoother learning experience in working with data. I am Kasper Peysepar, and I am glad that you are here and might give me a chance to add something to your knowledge!

Yuan Guo

Instructor's Courses

With 9 years of industry software development experience and specializing in OLTP and OLAP development with real world business applications, I've served as a Web Architecture & Data Platform Engineer at a leading mobile data and analytics company in the past 4 years and currently work as a software engineer at a Fortune 500 company. Pleasure to connect with you on Udemy.

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.