Library › Book 15Get the book on Leanpub →

SQL and Database Testing: Query Your Way to Quality

🎯 Interview Q&A 97 AI API SQL Playwright Security Performance Mobile Accessibility CI/CD Git Linux Agile Strategy Career

The bugs live in the data. From your first SELECT to migration testing, NoSQL, and GDPR-compliant masking — with exercises all the way.

Chapter 1 is free. Locked chapters show their outline — read everything with a subscription, or own the book via Leanpub.

01freePart I: SQL EssentialsYour First SELECT -- Reading the Source of Truth20 sections 02🔒Part I: SQL EssentialsFiltering and Sorting -- Finding the Needle in the Haystack17 sections 03🔒Part I: SQL EssentialsJOINs -- Connecting the Dots Across Tables17 sections 04🔒Part I: SQL EssentialsGROUP BY and Aggregation -- Seeing the Big Picture16 sections 05🔒Part I: SQL EssentialsSubqueries and CTEs -- Queries Within Queries16 sections 06🔒Part I: SQL EssentialsINSERT, UPDATE, DELETE -- Manipulating Test Data18 sections 07🔒Part I: SQL EssentialsTransactions -- The Safety Net16 sections 08🔒Part II: Database TestingConstraints -- The Database's Built-In Test Suite19 sections 09🔒Part II: Database TestingSchema Migrations -- Testing the Riskiest Deployment14 sections 10🔒Part II: Database TestingStored Procedures and Triggers -- Testing Hidden Logic16 sections 11🔒Part III: Beyond SQLNoSQL Fundamentals -- Beyond Relational Tables13 sections 12🔒Part III: Beyond SQLData Masking and Anonymization -- Compliance by Design19 sections 13🔒Part IV: Putting It All TogetherCapstone Project -- The Complete Database Test Suite12 sections 14🔒Part IV: Putting It All TogetherAppendix A: Practice Database Schemas10 sections 15🔒Part IV: Putting It All TogetherAppendix B: 100 SQL Exercises8 sections 16🔒Part IV: Putting It All TogetherAppendix C: Glossary1 sections

Tile view built with Bookatlas — our open-source engine for turning markdown books into zoomable tile atlases.