Data · Available on Amazon

SQL on Real Data by Kai London

Learn SQL by querying realistic datasets, from simple selects to joins, aggregation and window functions.

What the book covers

Querying basics

Selecting, filtering and sorting.

Joins and aggregation

Combining tables and summarising results.

Window functions

Ranking, running totals and comparisons.

Real-world habits

Readable, testable queries.

DataKai London

Who it is for

Analysts and developers learning SQL.

About the author

Professor Kai London — CISSP, CISM.

An internationally recognised cybersecurity executive, board advisor and Founder & CEO of Quantum AI Systems Security LLC, writing at the convergence of AI, governance and operational resilience. Honorary Professor and Researcher at UCL.