Health Data Clinic - Book 2: Design Principles, ACID & SQL

Rules are what keep a database honest. This book starts with the four ACID promises that protect data when something goes wrong, taking atomicity, consistency, isolation and durability one at a time so you can say what each one actually guarantees. Alongside them sit the integrity constraints that stop bad values at the door and the naming conventions that keep a schema readable months later. The second half is SQL itself, sorted into its four families so the language stops feeling like one large pile. You use DDL to build tables, DML to insert rows and then update and delete them, DQL to ask questions and filter and sort the answers, and DCL to control who is allowed to do what. The book closes with transactions in action, where the ACID ideas from the opening chapters become statements you can run and watch behave, with the printed output sitting next to each one.

Twenty-six A4 pages, in full color. Written in short sentences and plain English, for readers whose first language is not English and clearer for everyone else because of it.

Every query in this book was run against a live database before the page was printed, so the result you read is the result you get. Instant PDF download. By M.R. Sterling.