Featured resource
2025 Tech Upskilling Playbook
Tech Upskilling Playbook

Build future-ready tech teams and hit key business milestones with seven proven plays from industry leaders.

Check it out
  • Course
    • Libraries: If you want this course, consider one of these libraries.
    • Data

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.

Mohit Batra - Pluralsight course - Querying Data with Snowflake
Mohit Batra
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.

Table of contents

About the author
Mohit Batra - Pluralsight course - Querying Data with Snowflake
Mohit Batra

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.

Get access now

Sign up to get immediate access to this course plus thousands more you can watch anytime, anywhere.

Get started with Pluralsight