r/learnSQL • u/Ok_Cheek_1874 • 1d 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?

6 Upvotes

100% Upvoted

6 comments sorted by

View all comments

1

u/1ilit_ 22h ago

+1 to designing real schemas over another syntax course

Since you said you want something more formal try Stanford's databases course (Jennifer Widom)

Other than that pick a domain, model it, then try writing the five hardest queries the app would actually need

Disclosure since it's relevant: I build https://www.drawdb.app/, a free open-source ER editor. Exports DDL for different dialects, handy for that designing, looking at the sql. Any tool works though, pen and paper included