Comment by ruraljuror

The book Designing Data-Intensive Applications by Martin Kleppmann covers exactly the topics you are asking about and references many blog posts.