question

gangarocks avatar image
0 Votes"
gangarocks asked hamberfim answered

Best books for Relational Database Design

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

sql-server-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered Cathyji-msft commented

Hi @gangarocks,

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.


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @gangarocks,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If not, please let us know. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

Best regards,
Cathy

0 Votes 0 ·
ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

YitzhakKhabinsky-0887 avatar image
0 Votes"
YitzhakKhabinsky-0887 answered

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


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

hamberfim avatar image
0 Votes"
hamberfim answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.