Welcome to this new series where we dive into the world of SQL, the essential language for managing and querying databases. Whether you’re a beginner, want to refresh your knowledge, or just want to understand why SQL is everywhere in tech, you’re in the right place.

The videos of this course are in French. Turn on YouTube’s auto-translated subtitles if needed: every chapter below is fully written in English.

The program

Here’s what we’ll cover, chapter by chapter:

  1. What is SQL? Why this language matters so much in modern database management, then installing MySQL, one of the most popular database management systems.
  2. Managing databases: creating, deleting, renaming and switching between them.
  3. Managing tables: creating, modifying and linking them, then inserting, updating and deleting data.
  4. Querying data with SELECT: filtering, sorting, grouping and calculating.
  5. Advanced SQL: subqueries, for more powerful queries.
  6. Advanced SQL: joins, to combine data from several tables.
  7. Hands-on exercises, in two parts, to put everything into practice.

The goal: by the end of the course, you’ll walk away with real hands-on SQL experience.

What’s Next

In the next chapter, we answer the question: what is SQL, and why does it matter so much? Then we install MySQL.


This is Chapter 1 of the SQL from Zero to Pro course. Follow along to learn SQL with MySQL, from the basics to joins.