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