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!
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
- 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:
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
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!
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
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 youView all training courses
In partnership with dbt Labs, we offer you the dbt Learn training course. Upgrade your dbt (data build tool) skills now.
Unlock the power of data with SQL – the ultimate data management system!
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