Health Data Clinic - Book 15: Encryption & Privacy

Access control decides who gets in. This book protects the data itself, so that a stolen file or an over-shared report gives up nothing. You start with encryption at rest and encryption in transit, then the distinction that trips almost everyone, hashing against encryption, and why a stored password should never be recoverable. A chapter covers how encryption sits alongside SQLite specifically. From there the book turns practical: working out which columns are genuinely sensitive, writing SQL that masks values so a result stays useful without being revealing, de-identifying records with techniques such as age bands, and seeing where anonymization fits next to them. You learn to tell a safe report from an unsafe one, build a privacy-safe view, and spot the mistakes that leak data by accident. Privacy rules are set out as background context only. The work here is engineering, not legal advice.

Twenty-five 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.