Querying Data with Snowflake

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

In this course, you’ll learn how to query data in Snowflake using various query constructs and built-in functions - like Scalar, Aggregate, Analytic, Window, Table & Semi-structured functions - to clean up, transform, and analyze data.

1. Course Overview

1. Course Overview

2. Querying with Snowflake Getting Started

1. Introduction and Course Outline

2. Setting up Snowflake Environment

3. Understanding Querying Options

4. Using SnowSQL to Query Data

5. Exploring Data Using Snowsight

6. Summary

3. Performing Common SQL Operations

1. Module Overview

2. Using Common Scalar Functions

3. Working with Subqueries & Common Table Expressions

4. Performing Operations on Multiple Datasets

5. Writing Dynamic Queries with Variables, Identifiers & Filters

6. Querying Information Schema in Snowflake

7. Summary

4. Working with Aggregate and Analytic Functions

1. Module Overview

2. Using Common Aggregate Functions

3. Performing Window Operations

4. Using Rank-related Functions

5. Using Window Frames

6. Working with Group By Extensions

7. Summary

5. Querying Semi-structured Data

1. Module Overview

2. Understanding Semi-structured Options

3. Querying JSON Data

4. Working with Objects

5. Working with Arrays

6. Summary

6. Time Travel and Query Performance

1. Module Overview

2. Protecting Data Using Time Travel

3. Improving Query Performance

4. Summary

235,000 تومان

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

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

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

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