Querying Snowflake with SQL

Description

In the training "Querying Snowflake SQL for data analysts" we cover Snowflake SQL, the query and design language for Snowflake. We focus on making analyzes in SQL, and preparing, linking and enriching datasets for use within other analysis tools. From the broad experience of data analysis, the trainer shares examples, and has numerous "puzzles" ready that help to really understand SQL better. We conclude with the very powerful concepts of windowing , ranking , subqueries and CTEs (Common Table Expressions) . As a data analyst you can efficiently perform and solve all kinds of analyzes with this.

Audience

This course is aimed at data analysts, data engineers and data scientists who want to support their work in Snowflake by leveraging the power of SQL for advanced data analytics.

Skills gained

After this three-day training you will be able to:

• Use SnowSQL
• Write SELECT statements to retrieve columns from one or more tables
• Join tables using JOIN statements (and really understand what's happening)
• Sort and filter data
• Use built-in SQL functions to analyze data
• Grouping and aggregating (summarizing) datasets
• Structure complex SQL queries with Common Table Expressions
• Sort and use Windowing and Ranking functions
• Transform datasets using Pivot and Unpivot

Prerequisites

No specific prior knowledge is required for the training "Snowflake SQL for data analysts". Do you doubt your prior knowledge? Then please contact us!

Course outline

• Introducing SQL
• Using the SELECT statement
• Sort, Filter with WHERE, unique values and the TOP/LIMIT/FETCH clause
• Really understand JOIN: INNER, OUTER and CROSS
• Subqueries
• Advanced subqueries
• Functions
• Aggregate (SUM, MIN, MAX) and GROUP BY
• Filter with HAVING and QUALIFY
• Table Expressions
• Common Table Expressions (CTEs)
• Windowing and ranking functions
• Pivot and Unpivot

Course material

In the training "Snowflake SQL for data analysts" we use material, exercises and puzzles that we have developed ourselves at Wortell Smart Learning. We make sure that you receive all the necessary material on time.