SQL for Data Analysis

27 January, 2025Amsterdam, The Netherlands

2 days
In Person

Unlock the power of data with SQL – the ultimate data management system! Learn to wield SQL like a pro, querying your data to unveil invaluable insights. Our course takes you on a journey through essential querying and data analysis techniques, empowering you to navigate databases effortlessly. Elevate your data analysis game and master the intricacies of SQL. Join us for a transformative experience in boosting your skills and confidence!

Book this training

Book now

Looking to upskill your team(s) or organization?

Rozaliia will gladly help you further with custom training solutions.

Get in touch

Duration

2 days

Time

09:00 – 17:00

Language

English

Lunch

Included

Certification

No

Level

Foundation

What will you learn?

After the training, you will be able to:

Explain what a SQL is as language and database management system

Perform different kinds of joins – such as LEFT JOIN and INNER JOIN – to combine data from different locations

Query data using statements such as SELECT, WHERE, GROUP BY and CASE WHEN, to gather key insights from data

Apply efficient SQL practices – such as common table expressions (CTEs) – to improve code readability and workflow

Program

  • What is SQL and why should you use it?
  • Overview of database principals.
  • Querying Data using KEY words.
  • Creating new columns with calculations.
  • Grouping data for using aggregates or counting rows.
  • Primary and foreign keys.

This training is for you if:

Your company uses SQL for data and you want to become empowered to analyse it yourself

You are a data analyst, or aspiring to be one, and you want to learn SQL

You have some experience with SQL and want improve SQL performance and be more confident

You want to learn the ins and outs of SQL

This training is not for you if:

You want to learn how to use Python to explore data (see Python for Data Analysis)

You already know SQL and you want to learn dbt (see dbt Learn)

You want to tell a compelling story with data visualisation (see Data Storytelling)

You do not use SQL, nor will use it in the next year

Why should I follow this training?

Learn the fundamentals of the go-to query language for SQL

Learn with hands-on real life examples – learn today apply tomorrow!

Gather insight from the data that your team currently uses

What else
should I know?

After registering for this training, you will receive a confirmation email with practical information. A week before the training, the trainer will get in touch to ask you about any requirements you may have and any pre-course tasks you will need to do.

See you soon!

Course information

You need a laptop to take part in this training

You will be given access to an existing data warehouse with data in it

All literature and course materials are included in the price.

Meet the trainer

Lucy Sheppard 

Meet Lucy Sheppard, trainer at Xebia Data. Lucy is a data science trainer and teaches many Python courses as well as dbt Learn.

Lysanne van Beek

Lysanne is a Data Science Educator at Xebia Data and loves making courses as accessible as possible. With over 1,000 hours of training experience and over 750 students taught, she’ll make sure you get the most out of your training.

Also interesting for you

View all training courses
dbt Learn

In partnership with dbt Labs, we offer you the dbt Learn training course. Upgrade your dbt (data build tool) skills now.

Lucy Sheppard 

Data Engineering
dbt
dbt labs
3 days
Virtual

Next:

10 Mar, 2025

From:

€1005

View training
Data Storytelling

Create compelling visuals and engaging data stories that inform, entertain, and drive action.

Lucy Sheppard 

Data Analytics
Data Visualization
2 days
In Person

Next:

11 – 12 Dec, 2024

From:

€1465

View training
Certified Analytics Translation

Learn how to identify, develop, and execute AI use cases in our Certified Analytics Translation training course.

Steven van Duin

Analytics Translation
Data Analytics
2 days
In Person

Next:

16 – 17 Dec, 2024

From:

€1570

View training
Power BI in a Day

Learn how to turn your data sources into immersive visuals using Microsoft Power BI.

Lysanne van Beek

Data Analytics
Data Visualization
Microsoft
PowerBI
1 day
Virtual

Next:

26 Nov, 2024

From:

€645

View training
Data Science with Python (Certified)

Dive into the world of data science through data analysis and machine learning. Sign up for Data Science with Python (Certified).

Lucy Sheppard 

Data Science
Python
3 days
In Person

Next:

4 Nov, 2024

From:

€2145

View training

Can’t find the course you’re looking for? There’s more!