eCommerce Product Database Design: Step-By-Step

Get this design, explanation, and SQL scripts: https://www.databasestar.com/dbdesign...

In an eCommerce database, one of the most complex parts is how to design for products and product attributes.

In this video, you'll see a real-world eCommerce website or online store, and watch as we design a database from scratch.

You'll also see the SQL that can be used to create the tables, add the data from the website so you see what the data looks like, and how to make changes as our understanding of the website changes.


⏱ TIMESTAMPS:
00:00 - Our website
02:06 - Category of products
03:57 - A single product
10:28 - More product details
19:16 - View another product
21:47 - Nested categories
24:27 - Product filters and attributes


🔗 VIDEO LINKS:
Get this design, explanation, and SQL scripts: https://www.databasestar.com/dbdesign...

🔗 RESOURCES:
📝 Get my free SQL Cheat Sheets: https://www.databasestar.com/get-sql-...
🧭 SQL Roadmap from basics to advanced: https://www.databasestar.com/sql-road...
✍️ Learn how to design a database: https://databasestar.mykajabi.com/edd
📧 Contact me here: https://www.databasestar.com/contact/

📝 Database Design Exercises: https://bbrumm.gumroad.com/l/hqsxi
📝 SQL Practice Questions: https://bbrumm.gumroad.com/l/ulekqk
📝 SQL Performance Quick Guide: https://bbrumm.gumroad.com/l/fcvny
📝 Ultimate SQL How-To Guide: https://bbrumm.gumroad.com/l/oqggau