SQL for Data Analysis

SQL

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!

Looking to upskill your team(s) or organization?

Diego will gladly help you further with custom training solutions.

Get in touch

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 using aggregates or to count rows
  • Primary & 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 900 hours of training experience and over 500 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:

5 Jun, 2024

From:

€1045

View training
SQL for Data Analysis

Unlock the power of data with SQL – the ultimate data management system!

SQL
View training
Data Storytelling

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

Lysanne van Beek

Data Analytics
Data Visualization
2 days
Virtual

Next:

27 – 30 May, 2024

From:

€1310

View training
Certified Analytics Translation

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

Tennyson Wu

Analytics Translation
Data Analytics
2 days
Virtual

Next:

14 – 17 May, 2024

From:

€1415

View training
Power BI in a Day

Share quality data insights with Microsoft Power BI

Tennyson Wu

Data Analytics
Data Visualization
Microsoft
PowerBI
1 day
Virtual

Next:

25 Apr, 2024

From:

€645

View training

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