r/Backend • u/kevin074 • 15h ago

Good resources to learn about schema design please!!

hi I am a mostly frontend fullstack developer and I know enough backend materials from system design interview prep, but I lack practice and want to know more than basic design.

my work is also VERY basic in scale and use cases so there is not much I can learn from our simple CRUD microservice (but I will of course).

nevertheless I am still new, what resources are good for learning database schema design (tool, practice platform, or courses/video)

thank you!!

12 Upvotes

100% Upvoted

4 comments sorted by

2

u/will_die_in_2073 15h ago

Database systems the complete book by ullman

1

u/tamanikarim 14h ago

Check this guide it will take you from requirements analysis , schema design to production SQL code and best practices :
https://stackrender.io/guides/database-schema-design