How to Talk to Tables - A clear guide to reading, writing, and understanding SQL

How to Talk to Tables is a clear, practical SQL ebook for beginners who want to understand what they are doing, not just copy commands and hope the database behaves.

The book teaches SQL step by step using two running examples: a movie streaming app and a music festival database.

Each chapter explains one idea in plain language, then gives exercises to help you practise, check your results, and understand what each query is actually doing.

You will learn how to create tables, read data with SELECT, filter and sort results, work with NULL, use functions, create calculated columns, summarise data, join tables, change data safely, design better databases, and use reusable SQL tools such as views, stored procedures, triggers, and events.

The book also covers common mistakes, indexes, transactions, locks, and mini projects that bring the skills together.

Ideal for learners who have forgotten SQL, struggled with joins, or want a simple but thorough explanation without jargon, filler, or motivational confetti.