Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scalable, and Maintainable Systems
This books goes over many modern challenges with handling data. From reliability, through data models in databases, high availability and consistensy issues. This book alone is the best resource to give you a wide enough background on the data world.
Luc Perkins, Eric Redmond, Jim Wilson
In this book, the authors go through 7 different databases, each with a distinct type. Postgres for relational database, MongoDB for document database, Neo4J for graph database, and more. Using this book, you'll have a deep understanding of the different database models, and you'll be well equipped to decide on a database model when necessary.
This book is considered the holy grail on everything data warehouse design. Ralph Kimball was the first to design the star schema architecture, and he lays down the architecture in detail in this book. He goes into real world examples of business data and how it should be managed in a data warehouse.