⚡ 100% hands-on: run your queries live

The interactive SQL handbook to pass your technical tests

The Query Book is more than a book. It is a platform connected to a real online database, so you can practise in real time and join the top tier of data analysts. The book is written in French.

Buy the Query Book (in French) ➜ Try the free demo
Interactive demo of the Query Book
Built-in live SQL console ⚡
The key advantage

A real database at your fingertips

No more abstract theory. The Query Book builds a SQL console right into the handbook.

Every chapter is a chance to write and run your own queries on production databases. It is the ultimate training so you never stumble in front of a recruiter in a technical test again.

🚀 Ready for technical tests
📡 Real-time SQL console
🎯 100% business-oriented
⚡

Goal: zero failed technical tests

The data job market is competitive. Companies are not looking for people who "know" SQL, but for people who can "solve problems" with SQL. This book gives you the tools to win.

Your progress

What you will master by the end of the book

A complete set of SQL skills, from SELECT to complex data models.

100%
Hands-on
16
Expert chapters
SQL
Professional level
∞
Access to updates
Table of contents

The full programme

Browse the 16 chapters designed to take you from beginner to expert data analyst.

Chapter 1
Databases
Introduction to the core concepts, basic terminology and storage.
Chapter 2
Transactional & Analytical
OLTP vs OLAP. Introduction to the data warehouse, data lake and lakehouse.
Chapter 3
DBMS
The role of database management systems in the modern company.
Chapter 4
Data Jobs
Analyst, scientist, engineer: understanding the roles and skills.
Chapter 5
First Steps in SQL
Your first queries with SELECT and FROM on real data.
Chapter 6
Working with Fields
Aliases, concatenation and column operations.
Chapter 7
Adding Conditions
Master filtering with WHERE, HAVING and comparison operators.
Chapter 8
Sorting and Limiting
Learn to sort and slice your results with ORDER BY and LIMIT.
Chapter 9
Functions
Introduction to string, date and aggregate functions.
Chapter 10
Grouping
A solid command of GROUP BY for decision-making analysis.
Chapter 11
Joining Multiple Tables
Everything about JOINs: INNER, LEFT, FULL and their use cases.
Chapter 12
Combining Tables
Understand and use UNION vs UNION ALL effectively.
Chapter 13
Data Model
Star and snowflake schemas: structuring for performance.
Chapter 14
CTE vs Subquery
Make your SQL code readable for production environments.
Chapter 15
Summary of Concepts
The ultimate cheat sheet of essential commands and concepts.
Chapter 16
Going Further
Resources and advanced concepts for future seniors.
Kevin Rosamont Prombo
The author

Kevin Rosamont Prombo

My career in data started in 2012. I have worked successively as a statistician, data scientist and data analyst.

Today, I teach at leading institutions (EM Lyon, Université Paris Nanterre) and for companies such as Pernod Ricard and Banque de Luxembourg.

I designed this handbook to break down technical barriers and make SQL accessible to anyone who wants to make data speak.

Special offer

Ready to transform your career with SQL?

Get instant access to the Query Book (in French) and start learning today.

Get the Query Book ➜

Secure payment via Stripe