While there are many courses and tutorials online, learning from a book is still one of the best ways to greatly improve your skills. Below I have selected top Database Design books.
- Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design (3rd Edition) (2013)
- Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scalable, and Maintainable Systems (2017)
- Beginning Database Design Solutions (2008)
- Clean Architecture: A Craftsman’s Guide to Software Structure and Design (Robert C. Martin Series) (2017)
- Beginning Database Design: From Novice to Professional (2012)
- Refactoring Databases: Evolutionary Database Design (paperback) (Addison-Wesley Signature Series (Fowler)) (2006)
- Database Design and Relational Theory: Normal Forms and All That Jazz (2012)
- Relational Database Design and Implementation (2016)
- RELATIONAL DATABASE PRACTICES: BRIDGING THE GAP BETWEEN THE THEORY OF DATABASE DESIGN AND REAL-WORLD PRACTICES (2017)
- SOLVING BUSINESS PROBLEMS USING SQL: A DEFINITIVE GUIDE FOR BEGINNERS WHO WANT TO BE PROFICIENT IN DATABASE WRITING SQL (2019)
- Pro SQL Server Relational Database Design and Implementation (2016)
- Six-Step Relational Database Design™: A step by step approach to relational database development Second Edition (2013)
- Esssential Aspects of Design and Implementation of Relational Databases (2014)
- Database Reliability Engineering: Designing and Operating Resilient Database Systems (2017)
Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design (3rd Edition) (2013)
Michael J. Hernandez’s best-selling Database Design for Mere Mortals® has earned worldwide respect as the clearest, simplest way to learn relational database design. Now, he’s made this hands-on, software-independent tutorial even easier, while ensuring that his design methodology is still relevant to the latest databases, applications, and best practices.
Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scalable, and Maintainable Systems (2017)
Data is at the center of many challenges in system design today. Difficult issues need to be figured out, such as scalability, consistency, reliability, efficiency, and maintainability. In addition, we have an overwhelming variety of tools, including relational databases, NoSQL datastores, stream or batch processors, and message brokers. What are the right choices for your application?
This book is intended for IT professionals and students who want to learn how to design, analyze, and understand databases. The material will benefit those who want a better high-level understanding of databases such as proposal managers, architects, project managers, and even customers. The material will also benefit those who will actually design, build, and work with databases such as database designers, database administrators, and programmers.
Clean Architecture: A Craftsman’s Guide to Software Structure and Design (Robert C. Martin Series) (2017)
By applying universal rules of software architecture, you can dramatically improve developer productivity throughout the life of any software system. Now, building upon the success of his best-selling books Clean Code and The Clean Coder, legendary software craftsman Robert C. Martin (“Uncle Bob”) reveals those rules and helps you apply them. Martin’s doesn’t merely present options.
Beginning Database Design, Second Edition provides short, easy-to-read explanations of how to get database design right the first time. This book offers numerous examples to help you avoid the many pitfalls that entrap new and not-so-new database designers.
Refactoring Databases: Evolutionary Database Design (paperback) (Addison-Wesley Signature Series (Fowler)) (2006)
Refactoring has proven its value in a wide range of development projects–helping software professionals improve system designs, maintainability, extensibility, and performance. Now, for the first time, leading agile methodologist Scott Ambler and renowned consultant Pramodkumar Sadalage introduce powerful refactoring techniques specifically designed for database systems.
What makes this book different from others on database design? Many resources on design practice do little to explain the underlying theory, and books on design theory are aimed primarily at theoreticians.
Relational Database Design and Implementation: Clearly Explained, Fourth Edition, provides the conceptual and practical information necessary to develop a database design and management scheme that ensures data accuracy and user satisfaction while optimizing performance. Database systems underlie the large majority of business information systems.
RELATIONAL DATABASE PRACTICES: BRIDGING THE GAP BETWEEN THE THEORY OF DATABASE DESIGN AND REAL-WORLD PRACTICES (2017)
The gap between what a student learns in a standard database design course and what goes on in the real world is wide and is growing wider every year. Standard database design courses (included in a university computer science or information technology curriculum, or provided by vendors of database management systems) teach the concepts underlying the relational database model.
SOLVING BUSINESS PROBLEMS USING SQL: A DEFINITIVE GUIDE FOR BEGINNERS WHO WANT TO BE PROFICIENT IN DATABASE WRITING SQL (2019)
Are you getting ready for your new job? Whether you are going to start a new job, or you are a database administrator, developer of web or mobile applications, or you are engaged in a similar business applications role, a good understanding of SQL is essential for communicating with modern database systems.
Learn effective and scalable database design techniques in a SQL Server 2016 and higher environment. This book is revised to cover in-memory online transaction processing, temporal data storage, row-level security, durability enhancements, and other design-related features that are new or changed in SQL Server 2016. Designing an effective and scalable database using SQL Server is a task requiring skills that have been around for forty years coupled with technology that is constantly changing.
Six-Step Relational Database Design™: A step by step approach to relational database development Second Edition (2013)
Six-Step Relational Database DesignTM bridges the gaps between database theory, database modeling, and database implementation by outlining a simple but reliable six-step process for accurately modeling user data on a Crow’s Foot Relational Model Diagram, and then demonstrating how to implement this model on any relational database management system.
Esssential Aspects of Design and Implementation of Relational Databases (2014)
The Essential Aspects of Physical Implementation and Design of Relational Databases discusses the physical design and implementation of relational databases — the two phases in building of databases that often do not get enough attention in textbooks on database design and management.
The infrastructure-as-code revolution in IT is also affecting database administration. With this practical book, developers, system administrators, and junior to mid-level DBAs will learn how the modern practice of site reliability engineering applies to the craft of database architecture and operations.
Best Database Design Books Worth Your Attention
We highly recommend you to buy all paper or e-books in a legal way, for example, on Amazon. But sometimes it might be a need to dig deeper beyond the shiny book cover. Before making a purchase, you can visit resources like Library Genesis and download some database design books mentioned below at your own risk. Once again, we do not host any illegal or copyrighted files, but simply give our visitors a choice and hope they will make a wise decision.
Pro SQL Server Relational Database Design and Implementation: Best Practices for Scalability and Performance
Author(s): Louis Davidson
ID: 2876995, Publisher: Apress, Year: 2021, Size: 13 Mb, Format: pdf
RDBMS In-Depth: Mastering SQL and PL/SQL Concepts, Database Design, ACID Transactions, and Practice Real Implementation of RDBM (English Edition)
Author(s): Dr. Madhavi Vaidya
ID: 3079455, Publisher: BPB Publications, Year: 2021, Size: 3 Mb, Format: epub
Database Design and Implementation (Java, JDBC).
Author(s): Edward Sciore
ID: 2479685, Publisher: Springer, Year: 2020, Size: 15 Mb, Format: pdf
Please note that this booklist is not definite. Some books are absolutely record-breakers according to The Wall Street Journal, others are composed by unknown writers. On top of that, you can always find additional tutorials and courses on Coursera, Udemy or edX, for example. Are there any other relevant books you could recommend? Drop a comment if you have any feedback on the list.