SQL for Data Analysis
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.
Diego Teunissen
Data and AI Training Advisor
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 coursesIn partnership with dbt Labs, we offer you the dbt Learn training course. Upgrade your dbt (data build tool) skills now.
Create compelling visuals and engaging data stories that inform, entertain, and drive action.
Learn how to identify, develop, and execute AI use cases in our Certified Analytics Translation training course.
Share quality data insights with Microsoft Power BI
