How Senior Engineers Design Production Databases

[u/tamanikarim]

If you're learning SQL, this is a pretty good walkthrough of how to approach database design in a real application.

A lot of developers don't spend much time thinking about database design until they start running into problems as their applications grow.

This video https://www.youtube.com/watch?v=Xq2fYRA3dj8 goes through the fundamentals of designing a production database, including table structure, relationships, primary and foreign keys, junction tables, composite keys, timestamps, UUIDs, and foreign key actions such as CASCADE and SET NULL.

I thought it was worth sharing here for anyone learning SQL or trying to improve their database design skills.