This program was developed with the assistance of leading Data experts and will notably enable you to:
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
Claire Gouze
Head of Data
Bettina Hermant
Senior Machine Learning Engineer
Partie 1 - Fondamentaux du langage SQL
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.
Partie 2 - Requêtes SQL avancées
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.
Why choose On train over other types of training?
How do you select your trainers?
What are the financing options for training programs?
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
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
