Performing Data Analytic Tasks with Snowflake

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

Snowflake offers a deep and wide feature set for data analytic tasks. This course will teach you how to perform common tasks such as data sampling, result approximation, compose queries with CTEs, views, subqueries, analytical functions and more.

1. Course Overview

1. Course Overview

2. Data Sampling and Approximation

1. Data Sampling

2. Demo - Generating Data Samples

3. Approximations

4. Demo - Working with Approximation Functions

5. Module Summary

3. Querying Through Views

1. Views

2. Demo - Creating Views

3. Common Table Expressions

4. Demo - Working with CTEs and CONNECT BY

5. Scripting Database Objects

6. Module Summary

4. Composing Complex Datasets

1. Joins, Subqueries, and Set Operators

2. Demo - Joins, Subqueries, and Set Operators

3. Advanced Group By

4. Demo - Working with Advanced Group By

5. Execution Plans

6. Demo - Reading Execution Plans

7. Module Summary

5. Using Built-in Analytical Functions

1. Analytical Functions

2. Demo - Analytical Function Examples

3. Window Functions

4. Demo - Working with Window Functions

5. Module Summary

139,000 تومان

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

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

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

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