Go to content
We are the #1 Microsoft partner of the Netherlands

Querying Snowflake with SQL

3 days


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.


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.

Available dates

There are currently no scheduled dates available. Please contact us for options.