Ga naar content
Zoek op onderwerpen, blogs, diensten etc.

Querying Snowflake with SQL

3 dagen

Description

In the training "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.

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.

Beschikbare datums

Er zijn momenteel geen geplande datums beschikbaar. Neem contact op voor de mogelijkheden.