Performing Data Analytic Tasks with Snowflake

Focused View

Warner Chaves

1:29:36

81 View

1. Course Overview

1. Course Overview.mp4

01:06

2. Data Sampling and Approximation

1. Data Sampling.mp4

03:39

2. Demo - Generating Data Samples.mp4

05:35

3. Approximations.mp4

03:09

4. Demo - Working with Approximation Functions.mp4

11:18

5. Module Summary.mp4

00:37

3. Querying Through Views

1. Views.mp4

03:20

2. Demo - Creating Views.mp4

05:38

3. Common Table Expressions.mp4

03:04

4. Demo - Working with CTEs and CONNECT BY.mp4

07:04

5. Scripting Database Objects.mp4

03:11

6. Module Summary.mp4

00:36

4. Composing Complex Datasets

1. Joins, Subqueries, and Set Operators.mp4

04:00

2. Demo - Joins, Subqueries, and Set Operators.mp4

08:11

3. Advanced Group By.mp4

00:49

4. Demo - Working with Advanced Group By.mp4

03:07

5. Execution Plans.mp4

00:35

6. Demo - Reading Execution Plans.mp4

05:09

7. Module Summary.mp4

00:27

5. Using Built-in Analytical Functions

1. Analytical Functions.mp4

01:45

2. Demo - Analytical Function Examples.mp4

06:27

3. Window Functions.mp4

02:17

4. Demo - Working with Window Functions.mp4

07:51

5. Module Summary.mp4

00:41

Description

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.

What You'll Learn?

The Snowflake Cloud Data Platform is a great choice to build a data analysis platform to empower your organization to make better decisions. In this course, “Performing Data Analytic Tasks with Snowflake” you’ll learn to perform common data analytic tasks to be ready to tackle your next project and produce better and faster data insights.

First, you’ll explore Snowflake’s data sampling and approximation capabilities. Next, you’ll discover common ways to compose complex queries though joins, CTEs and subqueries. Finally, you’ll learn how to use Snowflake’s most useful built-in analytical and window functions.

When you’re finished with this course, you’ll have the skills and knowledge of data analytic tasks needed to build your next data solution.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Data Science

Database Programming

Warner Chaves

Instructor's Courses

Warner is a SQL Server Certified Master, MVP, and Solutions Architect at Pythian, a global Canada-based company specializing in data and infrastructure services. A brief stint in .NET programming led to his early DBA formation, working for enterprise customers in Hewlett-Packard's ITO organization. From HP he transitioned to his current position at Pythian, managing multiple clients of different sizes and industries. He leads a highly-talented team of data professionals that keep things running smooth and innovate with all kinds of data solutions. When he's not working out of his office in Ottawa, Ontario, he can be found on the sandy beaches of his home country of Costa Rica.

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.