DB Isolation Levels, Locks, Dirty Reads, Non-Repeatable Reads, and Phantom Reads

A good wikipedia article on Isolation (of the I in ACID): https://en.wikipedia.org/wiki/Isolation_(database_systems).  Introduces well the concepts of the various levels of isolation, the required locking for each level, and the observed results per level.