Best books for Relational Database Design

Question

Please suggest to me some good books for Relational Database Design using SQL Server.

Answer 1

Hi @gangadhar ,

Database Design for Mere Mortals is the perfect introduction to relational database design for the novice and anyone needing a refresher. With his many years of real-world experience designing relational databases, Michael J. Hernandez, the author of the book, shows you how to analyze and improve existing databases, implement keys, define table relationships and business rules, and create data views. the advantage of this book is real-world example and easy to read.

This is an excellent book to learn database modeling and design from scratch. If you want, you can also combine this book with the SQL & Database Design by Kirill Eremenko on Udemy, which is also very affordable.

There are many other good books for Relational Database Design, please refer to the blog Top 5 Books to Learn SQL and Database Design for Programmers and DBAs - Best of Lot to get more introduction.

Best regards,
Cathy

---

If the response is helpful, please click "Accept Answer" and upvote it, thank you.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Louis Davidson has a book which he has kept updated through the years,
https://www.amazon.com/Server-Relational-Database-Design-Implementation/dp/1484264967/ref=sr_1_1?dchild=1&keywords=louis+Davidson&qid=1610319271&s=books&sr=1-1

Full disclosure: I know Louis personally and he is a nice guy.

Answer 3

Here is another good book with a good methodology on modeling and design. It is generic textbook, not just for MS SQL Server.

Database Systems: A Practical Approach to Design, Implementation, and Management 6th Edition

Answer 4

I found that "Murach's SQL Server 2019 for Developers" is very handy as it's not just about SQL/Server but also covers DB design. Plus it's 2020 release date is relatively new in comparison to some of the other books on the market.