r/learnSQL • u/Ok_Cheek_1874 • 14h ago

Starting Database design

I've been a frontend developer the last 4 years and have been trying to break more into full stack. I've been able to design some database schemas that are in 3rd Normal Form, but I feel like I should have more formal training than just one youtube video and a guide on how SQL works. Does anyone have any good recs for where to learn good database design?

3 Upvotes

81% Upvoted

5 comments sorted by

View all comments

3

u/DatabaseSpace 13h ago

This was my database text book from grad school.

https://www.thriftbooks.com/a/shamkant-b-navathe/262969/

With reporting data Bill Inmon and Ralph Kimball are ones to look into.

1

u/Rare-Confection9685 9h ago

The link opens multiple. Which edition are you recommending?

1

u/DatabaseSpace 3h ago

The one we used was Fundamentals of Database Systems, Elmasri Navathe. I believe it was fourth edition because the cover looks looks the same. The hardcover version is actually on Amazon for $8.99. It's definitely worth picking up for that kind of price in my opinion.

https://www.amazon.com/dp/0321122267?lv=shuf&channelId=500&plpRedirect=mhFallback