MySQL E-commerce Database

A beginner-friendly MySQL project that models an online store: customers, products, orders and payments. I am building it step by step while learning SQL, from basic queries to advanced topics.

Tools

• MySQL 8.0
• MySQL Workbench 8.0 CE

How to run

Run the files in this order:

1. 01_database_setup/01_create_database.sql
2. 01_database_setup/02_create_tables.sql
3. 03_sample_data/01_insert_data.sql

Roadmap

• Project structure
• Create tables
• Sample data
• Basic queries
• Joins and aggregations
• Subqueries, CTEs, window functions
• Transactions, procedures, triggers
• Business analysis