EasyEnv
Engineering/Courses/Catalog/MySQL/Capstone: Design an Ecommerce Schema
MySQL
IntermediateLesson 13 of 1350 min · hands-on

Capstone: Design an Ecommerce Schema

Part of the MySQL course

Every lesson so far handed you a table and asked you to query it. Real work runs the other way round: somebody describes a shop, and you have to decide what the tables are, which relationships need enforcing, what happens when a product is deleted, and whether creating an order can leave the database half-finished. That is the skill this capstone exercises.

Try each step yourself before reading the version below it. Getting a design slightly wrong and then seeing why is worth more than copying one that works. ...

Want to learn MySQL Capstone: Design an Ecommerce Schema in a real environment?

Click below, get a fresh Linux box with MySQL ready to go, and work through Capstone: Design an Ecommerce Schema hands-on with an AI tutor that knows your code.

Start this lessonCapstone: Design an Ecommerce Schema

What you'll learn

  • Foreign keys
  • ON DELETE behavior
  • Indexes on lookup columns
  • Transactional order creation
  • EXPLAIN on a real query

Read this lesson in your language

All lessons in this course

13 lessons
  1. 1What is MySQL20 min
  2. 2The mysql CLI and First Commands25 min
  3. 3Creating Databases and Tables30 min
  4. 4Data Types30 min
  5. 5SELECT and WHERE30 min
  6. 6Joins35 min
  7. 7Aggregates and Grouping30 min
  8. 8Indexes30 min
  9. 9Transactions and Storage Engines35 min
  10. 10Stored Procedures and Triggers35 min
  11. 11EXPLAIN and Query Tuning35 min
  12. 12mysqldump and Restore25 min
  13. 13Capstone: Design an Ecommerce Schema50 min

Explore other courses

Capstone: Design an Ecommerce Schema - MySQL (English) | Engineering Courses