SQL & NoSQL Projects

Database-driven solutions focused on structured design, analytics, and scalable data architecture.

Designing a Store Database

A foundational SQL project focused on database creation, table design, data insertion, and basic analytical queries.

SQL · MySQL · Data Modeling

Objective

Build a simple relational database for a fictional shopping mall and extract meaningful statistics using SQL aggregate functions.

Create Database

CREATE DATABASE mall;
USE mall;

Create Table


CREATE TABLE tospin (
  id INT PRIMARY KEY,
  name TEXT,
  price FLOAT,
  quantity INT,
  sales INT
);

Analytics Queries


SELECT MAX(price) FROM tospin;
SELECT MIN(price) FROM tospin;
SELECT AVG(price) FROM tospin;
SELECT SUM(quantity) FROM tospin;
SELECT COUNT(name) FROM tospin;

This project demonstrates strong fundamentals in SQL syntax, schema design, and analytical thinking.

⭐ View SQL Script on GitHub

DataDig: Winston’s Donut Logs

A creative SQL project showcasing database design, structured inserts, and real-world logging scenarios using MySQL.

SQL · MySQL · Schema Design

Objective

Create a structured database that logs donut consumption across multiple life stages, demonstrating real-world data modeling.

Table Schema


CREATE TABLE winstons_donut_logs (
  id INT PRIMARY KEY,
  status VARCHAR(255),
  years_old INT,
  donuts_eaten INT,
  reason TEXT
);

The dataset tracks behavior over time, mirroring common event-logging use cases in analytics systems.

Key Takeaways

Strong relational schema planning
Clear separation of attributes
Scalable design for analytical queries

⭐ View on GitHub