Simple play icon Course

Performing Data Analytic Tasks with Snowflake

by Warner Chaves

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.

About the author

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 ... more

Ready to upskill? Get started