What you will learn during this training
What you will learn during this training
What you will learn during this training
What you will learn during this training
What you will learn during this training
What you will learn during this training
This program was developed with the assistance of leading Data experts and will notably enable you to:
Our Expert Trainers
Our Expert Trainers
Our Expert Trainers
Our Expert Trainers
Our Expert Trainers
Our Expert Trainers
Employed at the most innovative companies on the market, they will deliver their best methods to you and share their successes as well as their failures.
Andy Barakat
Lead Data Engineer
Andy Barakat
Lead Data Engineer
Andy Barakat
Lead Data Engineer
Andy Barakat
Lead Data Engineer
Andy Barakat
Lead Data Engineer
Andy Barakat
Lead Data Engineer
Claire Gouze
Head of Data
Claire Gouze
Head of Data
Claire Gouze
Head of Data
Claire Gouze
Head of Data
Claire Gouze
Head of Data
Claire Gouze
Head of Data
Bettina Hermant
Senior Machine Learning Engineer
Bettina Hermant
Senior Machine Learning Engineer
Bettina Hermant
Senior Machine Learning Engineer
Bettina Hermant
Senior Machine Learning Engineer
Bettina Hermant
Senior Machine Learning Engineer
Bettina Hermant
Senior Machine Learning Engineer
Program Type
Program Type
SECTION 1
Explore the use of subqueries to conduct more complex analyses within a main query
Introduction to tables, columns, rows, and primary/foreign keys.
Extracting specific data using the SELECT command.
Refining query results with precise conditions.
Data Organization and Sorting
Ranking of results according to various criteria.
Use of SUM, AVG, and COUNT for basic calculations.
Grouping of results to analyze overall trends.
[WORKSHOP]
Hands-on Group Workshop
Participants will connect to a fictitious database to execute simple SQL queries, apply WHERE and ORDER BY clauses, and group data using GROUP BY to address a given business scenario.
SECTION 2
Combine and enhance data
Data association from multiple tables using INNER JOIN and LEFT JOIN
Development of subqueries for conducting complex analyses.
In-depth calculations to extract key statistics.
Data Analysis and Visualization
Enhancing query performance for large datasets.
Explaining insights extracted from data.
Customizing analysis to meet specific business needs.
[WORKSHOP]
Hands-on Group Workshop
Participants will work on a more complex dataset requiring joins and advanced aggregation functions to address business questions. They will present their results and explain their query choices and analyses.
5
/5
"I found the balance between theory and practice to be ideal, along with constructive feedback. Additionally, sharing each person's work allows us to see how information can be highlighted."
Romane, Project Manager for Customer Care Europe at Chanel
5
/5
"I found the balance between theory and practice to be ideal, along with constructive feedback. Additionally, sharing each person's work allows us to see how information can be highlighted."
Romane, Project Manager for Customer Care Europe at Chanel
5
/5
"I found the balance between theory and practice to be ideal, along with constructive feedback. Additionally, sharing each person's work allows us to see how information can be highlighted."
Romane, Project Manager for Customer Care Europe at Chanel
5
/5
"I found the balance between theory and practice to be ideal, along with constructive feedback. Additionally, sharing each person's work allows us to see how information can be highlighted."
Romane, Project Manager for Customer Care Europe at Chanel
5
/5
"I found the balance between theory and practice to be ideal, along with constructive feedback. Additionally, sharing each person's work allows us to see how information can be highlighted."
Romane, Project Manager for Customer Care Europe at Chanel
Our Training Formats
Our Training Formats
Tailor-made programs, 100% adapted to your business needs and proficiency level.
Mentoring - Individual Training
An individual program lasting between 4 and 6 weeks
Learn more
Mentoring - Individual Training
An individual program lasting between 4 and 6 weeks
Learn more
Mentoring - Individual Training
An individual program lasting between 4 and 6 weeks
Learn more
Mentoring - Individual Training
An individual program lasting between 4 and 6 weeks
Learn more
Mentoring - Individual Training
An individual program lasting between 4 and 6 weeks
Learn more
Mentoring - Individual Training
An individual program lasting between 4 and 6 weeks
Learn more
Corporate Workshop - Group Training
A collective journey of 3 to 10 people
Learn more
Corporate Workshop - Group Training
A collective journey of 3 to 10 people
Learn more
Corporate Workshop - Group Training
A collective journey of 3 to 10 people
Learn more
Corporate Workshop - Group Training
A collective journey of 3 to 10 people
Learn more
Corporate Workshop - Group Training
A collective journey of 3 to 10 people
Learn more
Corporate Workshop - Group Training
A collective journey of 3 to 10 people
Learn more
Conferences & Learning Event
Inspiring and impactful conferences
Learn more
Conferences & Learning Event
Inspiring and impactful conferences
Learn more
Conferences & Learning Event
Inspiring and impactful conferences
Learn more
Conferences & Learning Event
Inspiring and impactful conferences
Learn more
Conferences & Learning Event
Inspiring and impactful conferences
Learn more
Conferences & Learning Event
Inspiring and impactful conferences
Learn more
E-learning Courses
Transform your team with our online training programs
Learn more
E-learning Courses
Transform your team with our online training programs
Learn more
E-learning Courses
Transform your team with our online training programs
Learn more
E-learning Courses
Transform your team with our online training programs
Learn more
E-learning Courses
Transform your team with our online training programs
Learn more
E-learning Courses
Transform your team with our online training programs
Learn more
4.8
/5
"The blend between professional experience and 'theory' is very interesting and makes the sessions more practical and dynamic."
Stéphanie, Head of Data Protection at Société Générale
4.8
/5
"The blend between professional experience and 'theory' is very interesting and makes the sessions more practical and dynamic."
Stéphanie, Head of Data Protection at Société Générale
4.8
/5
"The blend between professional experience and 'theory' is very interesting and makes the sessions more practical and dynamic."
Stéphanie, Head of Data Protection at Société Générale
4.8
/5
"The blend between professional experience and 'theory' is very interesting and makes the sessions more practical and dynamic."
Stéphanie, Head of Data Protection at Société Générale
4.8
/5
"The blend between professional experience and 'theory' is very interesting and makes the sessions more practical and dynamic."
Stéphanie, Head of Data Protection at Société Générale
Frequently Asked Questions
Frequently Asked Questions
Why choose On train over other types of training?
Why choose On train over other types of training?
Why choose On train over other types of training?
Why choose On train over other types of training?
Why choose On train over other types of training?
Why choose On train over other types of training?
How do you select your trainers?
How do you select your trainers?
How do you select your trainers?
How do you select your trainers?
How do you select your trainers?
How do you select your trainers?
What are the financing options for training programs?
What are the financing options for training programs?
What are the financing options for training programs?
What are the financing options for training programs?
What are the financing options for training programs?
What are the financing options for training programs?
What is On train's teaching method?
What is On train's teaching method?
What is On train's teaching method?
What is On train's teaching method?
What is On train's teaching method?
What is On train's teaching method?
SQL Language
4.7
5 out of
658
meetings
Tailored by experts working in the most innovative companies in the market, our SQL courses provide you with a comprehensive and practical experience to discover the basics of SQL language and learn how to manage databases.
Customize this training theme
Customize this training theme
Customize this training theme
Customize this training theme
Customize this training theme
Learn from the top industry experts, current leaders
Custom training tailored to your specific objectives
Practice with real cases from your sector and your industry
Custom format individual/workshops/collective in-person/remote
Your tailor-made training, delivered by experts currently working in leading tech and AI companies.
Training Programs
Formats
Copyright © 2025 OnTrain
Your tailor-made training, delivered by experts currently working in leading tech and AI companies.
Training Programs
Copyright © 2025 OnTrain
Your tailor-made training, delivered by experts currently working in leading tech and AI companies.
Copyright © 2025 OnTrain
Your tailor-made training, delivered by experts currently working in leading tech and AI companies.
Copyright © 2025 OnTrain
Your tailor-made training, delivered by experts currently working in leading tech and AI companies.
Training Programs
Copyright © 2025 OnTrain
Your tailor-made training, delivered by experts currently working in leading tech and AI companies.
Copyright © 2025 OnTrain