Library › Book 15Get the book on Leanpub →
SQL and Database Testing: Query Your Way to Quality
🎯 Interview Q&A 97AIAPISQLPlaywrightSecurityPerformanceMobileAccessibilityCI/CDGitLinuxAgileStrategyCareer
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 Truth02🔒Part I: SQL EssentialsFiltering and Sorting -- Finding the Needle in the Haystack03🔒Part I: SQL EssentialsJOINs -- Connecting the Dots Across Tables04🔒Part I: SQL EssentialsGROUP BY and Aggregation -- Seeing the Big Picture05🔒Part I: SQL EssentialsSubqueries and CTEs -- Queries Within Queries06🔒Part I: SQL EssentialsINSERT, UPDATE, DELETE -- Manipulating Test Data07🔒Part I: SQL EssentialsTransactions -- The Safety Net08🔒Part II: Database TestingConstraints -- The Database's Built-In Test Suite09🔒Part II: Database TestingSchema Migrations -- Testing the Riskiest Deployment10🔒Part II: Database TestingStored Procedures and Triggers -- Testing Hidden Logic11🔒Part III: Beyond SQLNoSQL Fundamentals -- Beyond Relational Tables12🔒Part III: Beyond SQLData Masking and Anonymization -- Compliance by Design13🔒Part IV: Putting It All TogetherCapstone Project -- The Complete Database Test Suite14🔒Part IV: Putting It All TogetherAppendix A: Practice Database Schemas15🔒Part IV: Putting It All TogetherAppendix B: 100 SQL Exercises16🔒Part IV: Putting It All TogetherAppendix C: Glossary
Tile view built with Bookatlas — our open-source engine for turning markdown books into zoomable tile atlases.