Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Pluralsight

Querying Data with Snowflake

via Pluralsight

Overview

Prepare for a new career with $100 off Coursera Plus
Gear up for jobs in high-demand fields: data analytics, digital marketing, and more.
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.

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.

Taught by

Mohit Batra

Reviews

4.5 rating at Pluralsight based on 32 ratings

Start your review of Querying Data with Snowflake

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.