Querying Data with Snowflake

Focused View

Mohit Batra

1:56:01

80 View

1. Course Overview

1. Course Overview.mp4

01:22

2. Querying with Snowflake Getting Started

1. Introduction and Course Outline.mp4

01:11

2. Setting up Snowflake Environment.mp4

04:46

3. Understanding Querying Options.mp4

02:26

4. Using SnowSQL to Query Data.mp4

06:27

5. Exploring Data Using Snowsight.mp4

06:46

6. Summary.mp4

01:17

3. Performing Common SQL Operations

1. Module Overview.mp4

00:44

2. Using Common Scalar Functions.mp4

11:58

3. Working with Subqueries & Common Table Expressions.mp4

04:40

4. Performing Operations on Multiple Datasets.mp4

08:32

5. Writing Dynamic Queries with Variables, Identifiers & Filters.mp4

04:06

6. Querying Information Schema in Snowflake.mp4

02:29

7. Summary.mp4

01:20

4. Working with Aggregate and Analytic Functions

1. Module Overview.mp4

00:35

2. Using Common Aggregate Functions.mp4

03:14

3. Performing Window Operations.mp4

06:34

4. Using Rank-related Functions.mp4

06:48

5. Using Window Frames.mp4

07:09

6. Working with Group By Extensions.mp4

03:00

7. Summary.mp4

01:25

5. Querying Semi-structured Data

1. Module Overview.mp4

00:30

2. Understanding Semi-structured Options.mp4

02:33

3. Querying JSON Data.mp4

07:30

4. Working with Objects.mp4

02:55

5. Working with Arrays.mp4

04:17

6. Summary.mp4

01:23

6. Time Travel and Query Performance

1. Module Overview.mp4

00:25

2. Protecting Data Using Time Travel.mp4

05:06

3. Improving Query Performance.mp4

03:28

4. Summary.mp4

01:05

Description

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.

What You'll Learn?

Snowflake is one of the most popular cloud data platforms. It allows data storage, data processing, and analytics at a massive scale, with extremely less administrative effort. And one of the key areas is to effectively query the data. In this course, Querying Data with Snowflake, you’ll learn how to use various query constructs and built-in functions in Snowflake, to clean up, transform, and analyze data. First, you’ll learn about different querying options in Snowflake and how to explore data using SnowSQL and Snowsight. Then, you’ll discover how to perform common SQL operations - like using Scalar functions, working with subqueries and CTEs, using joins and set operations, building dynamic queries, and using table functions. Next, you’ll see how to work with various aggregate and analytic functions, including windows, rank-related, and window frame functions and working with various group by extensions. Finally, you’ll see the data protection lifecycle, and how to protect the data using time travel and some quick tips to improve query performance. By the end of this course, you’ll have the knowledge and skills, to Query Data with Snowflake, by using various query constructs and built-in functions.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Data Science

Data Analysis

Mohit Batra

Instructor's Courses

Mohit is a Data Engineer, a Microsoft Certified Trainer (MCT) and a consultant. Mohit has 15+ years of extensive experience in architecting large scale Business Intelligence, Data Warehousing and Big Data solutions with companies like Microsoft and some leading investment banks. As an expert in his field, Mohit has often shared his knowledge in Azure, Spark, SQL Server and Power BI at various public forums and as a corporate trainer. Mohit truly loves to teach and enjoys producing high-quality, engaging learning materials for his sessions. In his free time, Mohit loves to read, enjoys photography and music.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.