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.

mysql sql projects mysql-database sql-database sql-table snowflakedb mysql-project sqlcase-study sql-case-study sql-snowflake sql-snowflake-schema-design

• Updated Oct 22, 2026

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

bigquery portfolio sql data-analysis learning-by-doing case-study sql-portfolio sql-case-study

• Updated Mar 3, 2026

Case study solutions to the #8WeekSQLChallenge

sql postgresql data-analytics data-analysis case-study-analysis practice-sql 8weeksqlchallenge 8-week-sql-challenge sql-case-study

• Updated Oct 24, 2025

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.

python data-engineering data-analytics ansi-sql duckdb sql-case-study

• Updated Sep 20, 2026
• Jupyter Notebook

mysql case-study 8-week-sql-challenge 8weekssqlchallenge pizza-runner sql-case-study

• Updated Jan 19, 2024

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

mysql data-analysis sql-project sql-case-study github-database-analytics

• Updated Aug 2, 2026

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.

mysql sql data-visualization data-analysis mysql-workbench portfolio-project mysqlworkbench employee-database hr-analytics sql-case-study query-writing

• Updated Sep 10, 2026

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.

mysql sql presentation data-analysis business-analysis employee-database employee-management-system hr-analytics sql-case-study query-writing

• Updated Sep 11, 2026

SQL case study analyzing customer spending, visits, menu preferences, and loyalty points.

mysql sql data-analysis customer-analytics sql-case-study

• Updated Oct 2, 2026