Simple play icon Course
Skills Expanded

Query Data with Snowflake

by Pinal Dave

Learn how to efficiently query and manipulate data in Snowflake. This course will teach you to write SQL queries, join tables, use subqueries, and perform data aggregation in Snowflake.

What you'll learn

Data manipulation and querying are crucial for extracting valuable insights from your data.

In this course, Query Data with Snowflake, you’ll gain the ability to efficiently query and manipulate data in Snowflake.

First, you’ll explore how to write basic SQL queries, including SELECT statements and the WHERE clause, to retrieve and filter data.

Next, you’ll discover how to sort and limit query results using the ORDER BY and LIMIT clauses, and how to combine multiple filtering conditions using logical operators.

Finally, you’ll learn how to join data from multiple tables, use subqueries, and perform data aggregation with GROUP BY and aggregate functions.

When you’re finished with this course, you’ll have the skills and knowledge of Snowflake needed to write efficient SQL queries and perform advanced data manipulation.

About the author

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 22 years of hands-on experience. He holds a Master of Science degree and numerous database certifications. Pinal has authored 14 SQL Server database books and 75 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.

Ready to upskill? Get started