E-Commerce Analytics Database

A portfolio project in SQL database design, analytics, and optimization for a simulated e-commerce platform.

Overview

The database models customers, products, orders, reviews, and shipments. It demonstrates:

Schema design (ERD, DDL)

Data generation (large sample sets)

Analytical queries (sales trends, customer behavior, revenue analysis)

Stored procedures and functions

Role-based views

Performance tuning with indexes and query plans

Tech Stack

Database: PostgreSQL or MySQL

Tools: VS Code, GitHub, dbdiagram.io or draw.io

Languages: SQL; optional Python (Faker for data)

Structure

/schema — Database creation scripts /data — Sample data (CSV and inserts) /queries — Analytical SQL queries /procedures — Stored procedures and functions /views — Views and permissions /docs — ERD diagrams, performance notes