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.

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.

Inside My M.Sc. Thesis: Building Algo-Trading at 9.85 Sharpe via Statistical Arbitrage for $100–$1,000 Retail Accounts

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.

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.

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

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.

Business oriented SQL analysis of a digital music store's sales data in MySQL revenue, customer value, genre/artist performance, and geographic markets, using CTEs, window functions, and subqueries.

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

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

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.

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 practice covering core to advanced concepts using MySQL, with hands-on exercises and queries.

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.

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

Projeto de Banco de Dados e Análise em SQL com SQLite, explorando modelagem relacional, JOINs, CTEs e Window Functions.

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