This repository contains the solutions of the 8 case studies for The 8 Weeks SQL Challenge

This project analyzes historical transaction data from Walmart stores using advanced SQL queries to uncover insights related to sales performance, customer behavior, and operational efficiency. By leveraging SQL techniques, the project covers various aspects such as branch performance, product profitability, customer segmentation, and sales trends.

A structured SQL project analyzing customer behavior, menu trends, and loyalty program effectiveness for a fictional restaurant.

🦠 Covid Data Cleaning 🧹 on SSMS (SQL Server 19.2) | 🍕 Pizza Sales Data Cleaning 🧹 on SSMS (SQL Server 20.0) | 🏦 Bank Loan Data Analysis & Cleaning 📊

The project "Ecommerce_Application_MySQL_Database" is build to understand how mysql database for ecommerce application is designed in the industry. This project will help you to understand how joins, windows-functions, and procedures work in real industry projects.

A collection of fun, interesting, and challenging SQL projects showcasing my skills in data manipulation, querying, and analysis.

Ejercicios prácticos de SQL intermedio con MySQL 8+: SELECT avanzado, JOINs, Agregaciones, CTEs, Subconsultas y Window Functions. Incluye soluciones y esquema de base de datos lista para usar.

These Projects have SQL real-world data analysis with Netflix and Zomato datasets.Worked with complex queries utilizing JOINs, aggregation functions, GROUP BY, subqueries, CTEs, and window functions. Analyzed popular content, cuisine preferences, revenue metrics, and operational performance.

This repository, NorthWind Customer Churn Analysis, leverages the NorthWind database and MySQL to analyze customer churn patterns. It identifies trends, predicts at-risk customers, and provides actionable insights to improve customer retention.

This project demonstrates end-to-end data analysis of an online bookstore using SQL. It covers data modeling, importing CSV files into PostgreSQL, and writing queries for business intelligence insights. The project showcases skills in SQL querying, joins, aggregation, window functions, and real-world data problem-solving.

Advanced SQL for Data Analytics. A collection of problem-solving solutions covering complex Joins, Window Functions, CTEs, and Query Optimization. Includes real-world interview questions, schema design, and dataset analysis for MySQL and PostgreSQL

SQL-based operational analytics project built on a logistics transportation dataset hosted on Supabase. The project applies advanced PostgreSQL techniques to derive insights on fleet performance, route economics, operational risk, and demand trends.

MySQL projects on GitHub showcase a wide range of applications, sample databases, and learning resources designed to help developers understand SQL, relational modeling, and backend integration. Many repositories feature sample databases such as the well-known test_db, which contains realistic employee records.

Engineered a BI framework to drive growth and operational efficiency. Segmented 90+ customers for churn mitigation, audited logistical ROI to optimize shipping costs, and automated margin protection for discontinued inventory. Delivered actionable KPIs for sales attribution and revenue forecasting using 830+ order records.

SQL queries for beginners to advanced. You'll also see some beginner projects in this repository. These projects are made keeping in mind the concepts of data engineering.