eCommerce Product Database Design: Step-By-Step

 Bonus PDF: This ERD, descriptions of each table and column with sample data, and SQL scripts to create all of the tables on your own database: https://www.databasestar.com/dbdesign/?utm_sourceviddesc&utm_mediumyoutube&utm_campaign127
 Learn how to design an effective database and create it using SQL: https://databasestar.mykajabi.com/edd/?utm_sourceviddesc&utm_mediumyoutube&utm_campaign127
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