I made a video demystifying database consistency, isolation levels, record contention, and pessimistic vs. optimistic concurrency control tradeoffs. (I also said "dollars" instead of "pounds" 40 times.) Check it out if you want a basic working knowledge of this stuff.