SQL case studies on real-world domains E-Commerce, HR Analytics, Hospital Management, and Banking. Covers joins, aggregations, subqueries, window functions, and CTEs.

🚀 Hands-on MySQL reference guide & cheat sheet—from DDL/DML foundations to analytical window functions, CTEs, and real-time database interview scenarios.

SQL-based end-to-end analysis of 100K+ e-commerce orders (Olist dataset), covering revenue growth, logistics performance, and RFM customer segmentation to drive business insights.

This project presents a fictional case study analyzing the operations of a textile company, FabricFlow, using SQL. The dataset includes information about products, sales, inventory, suppliers, and purchases. The goal is to derive actionable insights to improve operational efficiency, inventory management, and supplier performance.

Analyzing the 2023 data analyst job market using SQL — top-paying roles, in-demand skills, and optimal skills by salary-to-demand ratio.

Advanced SQL project analyzing e-commerce sales using joins, CTEs, and window functions. Includes sample data (CSV) and queries with business insights.

PostgreSQL business analytics case studies using joins, CTEs, window functions, recursive queries, ranking, and moving averages.

📊 End-to-end SQL data analysis project on Indian Election dataset | PostgreSQL | Advanced SQL | Data Modeling | Insights

A diverse collection of SQL-based projects that solve practical business problems using relational data. From global economics to urban transport and marketing analytics, these projects highlight strong proficiency in data querying, joins, CTEs, and window functions.

PostgreSQL project for Canadian banking analytics, covering risk, fraud, loans, KPIs, SLAs, data quality, advanced SQL, and Docker.

Exploration of Covid 19 official dataset using SQL queries. Data cleaning of Nashville housing dataset for effective modelling and analysis.

SQL project analyzing MLB schools, salaries, careers, and comparisons. Explores top schools, team spending, player career spans, team loyalty, batting hand trends, and decade-by-decade height/weight changes using advanced queries and analytics.

SQL analysis of Forbes Global 2000 using CTEs, window functions, subqueries and views.

End-to-end SQL analysis of a bike-sharing dataset covering data validation, ride duration patterns, peak-hour demand, station-level net flow, and month-over-month user growth using advanced SQL concepts.

Global layoffs analysis 2020–2026 using pure SQL — CTEs, window functions, DENSE_RANK, 12 queries, 875K layoffs

A collection of SQL queries demonstrating CTEs, joins, and aggregation for analytical reporting.

Transforms raw sales and dimension data into two key analytics views—customer_report and product_report—within the gold schema using T-SQL. Includes customer segmentation, product ranking, sales trends (YoY, moving averages), and revenue contribution analysis.

SQL Data Cleaning and EDA on World Layoffs Dataset using MySQL

This project showcases the use of SQL to analyze retail sales data for insights on customer behavior, product performance, and sales trends. It involves table creation, data cleaning, exploration, and answering real-world business questions using SQL.

A demonstration of modular SQL programming using the WITH clause (CTEs) and subqueries. This repository showcases how to refactor complex nested logic into clean, readable, and maintainable code which is a vital skill for scalable data analysis.