SYLLABUS
SQL Fundamentals
A training introducing professionals to SQL and relational databases. Participants learn how to write queries, filter and aggregate data, join tables and analyse business datasets, finishing with a collaborative capstone project in BigQuery.
They are already training their teams with Le Wagon.
SQL Fundamentals
- Understand the role of SQL in data analysis and data manipulation.
- Learn how relational databases, tables, rows and keys work.
- Write basic queries using SELECT, WHERE, ORDER BY and LIMIT.
- Aggregate data with GROUP BY, HAVING, COUNT, AVG and SUM.
- Combine data using different types of SQL joins.
- Use subqueries, set operations and arrays in SQL.
- Work with BigQuery and SQLite.Apply SQL skills to a real-world group capstone project.
Immediate results thanks to a practice-oriented pedagogy.
Experience rapid skill development with hands-on training from industry experts and see immediate results as your team applies new skills directly to your projects.
Benefit from the experience of bootcamp n°1.
Get immediately usable skills thanks to 100% live learning in cohorts. Above all, it's practical: 80% of the bootcamp consists of hands-on application.
Learn from the best experts in Tech.
Choose the best teachers for your teams. They provide individual, personalised support and the progress of each employee is monitored in real time.
Aim for excellence in just a few days.
Aim for excellence by learning from your own data and from content that is contextualised to your company's challenges, whatever the subject.
Deploy at scale and with complete flexibility.
Train your employees anywhere in the world and at your own pace, online, on your premises or on one of our campuses.
"The Wagon has been an incredible adventure. Through this experience, I have learned so much about the Tech industry with the most qualified faculty and staff, a very large alumni network and resources that are extremely helpful when you are starting out in Tech.”
consulting, Software specialist.
Renault Group
SQL Fundamentals
- Understand the role of SQL in data analysis and data manipulation.
- Learn how relational databases, tables, rows and keys work.
- Write basic queries using SELECT, WHERE, ORDER BY and LIMIT.
- Aggregate data with GROUP BY, HAVING, COUNT, AVG and SUM.
- Combine data using different types of SQL joins.
- Use subqueries, set operations and arrays in SQL.
- Work with BigQuery and SQLite.Apply SQL skills to a real-world group capstone project.
Training actions: