Snowflake for Data Science and Data Engineering – 2024

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

A compact course on Snowflake data platform and Snowflake SQL

1. Snowflake Setup

1. Sign up for a free account

2. Snowsight tour - Overview

3. Snowsight tour - Dashboards

4. Snowsight tour - Worksheets

5.1 context functions.zip

5. Context functions and Account Info

2. Core Concepts

1. Snowflake architecture

2.1 virtual warehouses.zip

2. Virtual Warehouses

3. Snowflake Core Concepts.html

3. Snowflake SQL

1. Snowflake SQL, Snowflake Scripting, SnowSQL

2. SQL Statement Types

3.1 ddl.zip

3. DDL Statements

4.1 column constraints.zip

4. Column Constraints

5.1 dml.zip

5. DML Statements

6. Snowflake SQL.html

4. Access Control and DCL Statements

1. Access Control in Snowflake

2.1 access control.zip

2. System-defined and Custom Roles

3.1 access control.zip

3. Users and additional DCL statements

4.1 access control.zip

4. Best Practices in Access Control

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

5. Load Data to Snowflake

1. Load overview

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

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

4.1 stages.zip

4. Stage Objects

5.1 aws integration.zip

5.2 IAM Policies.txt

5. Option 1 - Connect to AWS by Storage Integration

6.1 aws integration.zip

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

7.1 customer 10.csv

7.2 transformation.zip

7. Load with Transformation

8. Load Data to Snowflake.html

6. DQL statements

1.1 query syntax.zip

1. Query Syntax

2.1 joins.zip

2. Joins

3.1 aggregation.zip

3. Aggregation

4. Window functions Concepts

5.1 window functions.zip

5. Window functions Cumulative and Sliding Window Frames

6.1 window functions.zip

6. More Window Functions

7.1 common table expressions.zip

7. Common Table Expressions

8.1 set operators.zip

8. Set operators

9.1 session variables.zip

9. Session Variables and SELECT INTO

10.1 pivot and unpivot.zip

10. Pivot and Unpivot

11. Query Syntax & Window Functions.html

7. Data Types and Common Functions

1.1 strings.zip

1. Strings

2.1 numbers.zip

2. Numbers

3.1 date time timestamp.zip

3. Date, Time, Timestamp

4.1 scalar functions overview.zip

4. Scalar Functions Overview - Conditional Functions

5.1 conversion functions.zip

5. Conversion Functions

6.1 string functions.zip

6. String Functions

7.1 numeric functions.zip

7. Numeric Functions

8.1 temporal functions.zip

8. Temporal Functions

9. Data Types and Common Functions.html

8. Data Recovery

1. Retention Period and Fail-safe - Theory

2.1 time travel and data retention period.zip

2. Time Travel and Data Retention Period

3. Data Recovery Quiz.html

9. Secure Data Sharing

1. Listing, Marketplace, Direct Share - Theory

2.1 creating direct share.zip

2. Creating Direct Share

3.1 secure views.zip

3. Secure Views

4. Secure Data Sharing Quiz.html

10. Stored Procedures

1.1 snowflake scripting.zip

1. Snowflake Scripting

2.1 stored procedures.zip

2. Stored Procedures

3.1 resultsets and cursors.zip

3. Resultsets and Cursors

4.1 error handling.zip

4. Error Handling

5.1 stored procedures using python.zip

5. Store Procedures Using Python

6. Store Procedures.html

11. Tasks

1. Tasks - Theory

2.1 tasks.zip

2. Tasks

3.1 dag of tasks.zip

3. DAG of Tasks

4. Snowflake Tasks.html

12. Streams

1. Streams - Theory

2.1 consuming streams.zip

2. Consuming Streams

3.1 stream behavior and additional tips.zip

3. Stream Behavior and Additional Tips

4.1 streams and tasks.zip

4. Streams and Tasks

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

45,900 تومان

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

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

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

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