eCommerce Product Database Design: Step-By-Step

Published: 13 February 2024
on channel: Database Star
20,483
608

📝 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...
🎓 Turn your idea into a real database: https://databasestar.mykajabi.com/edd...

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


Watch video eCommerce Product Database Design: Step-By-Step online without registration, duration hours minute second in high quality. This video was added by user Database Star 13 February 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 20,483 once and liked it 608 people.