ctes

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.

🗳️ Analyze election data using SQL to unveil insights on party performance, voter trends, and constituency outcomes across India.

SQL-based business analytics project using PostgreSQL to analyze customer behavior, sales performance, artist popularity, and genre trends through advanced SQL queries on the Chinook Music Store database.

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.

Business-focused SQL analytics project for a D2C skincare e-commerce brand using PostgreSQL.

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.

A portfolio project demonstrating intermediate-to-advanced SQL querying—including CTEs, multi-value subqueries, and multi-table filtering—to solve real-world e-commerce marketing and fraud-risk scenarios

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

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-based business analysis project for a food delivery platform, solving 20+ real-world business problems using PostgreSQL, including customer segmentation, revenue analysis, rider performance, sales trends, and advanced SQL techniques.

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

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

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