sql-case-study

This repository contains a collection of MySQL database projects showcasing various database design and management techniques. Each project demonstrates practical applications of MySQL in different contexts, including data modeling, query optimization, and relational database management.

SQL-based analytical case study on a Rapido ride-hailing dataset, covering user behavior, ride patterns, vehicle performance, and cohort analysis using BigQuery SQL.

Case study solutions to the #8WeekSQLChallenge

SQL case study on an employee database utilising filtering, logical conditions, pattern matching, and multi-condition queries to answer core HR questions: identifying high earners, segmenting by department and demographics. Built in MySQL Workbench.

SQL case study solving customer purchasing behavior using MySQL, joins, CTEs, window functions and aggregation.

SQL Case Study: End-to-end airline passenger disruption analytics engine using DuckDB ANSI SQL, Python, and Seaborn to demonstrate advanced window functions, dynamic labor modeling, and relational data architecture.

A hands-on SQL case study answering core business questions on an employee database identifying high earners, filtering by department and demographics, and combining logical conditions and pattern matching to simulate real analyst query-writing. Built in MySQL.