A structured SQL project analyzing customer behavior, menu trends, and loyalty program effectiveness for a fictional restaurant.
-
Updated
Jan 29, 2025
A structured SQL project analyzing customer behavior, menu trends, and loyalty program effectiveness for a fictional restaurant.
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.
This repository contains the solutions of the 8 case studies for The 8 Weeks SQL Challenge
🦠 Covid Data Cleaning 🧹 on SSMS (SQL Server 19.2) | 🍕 Pizza Sales Data Cleaning 🧹 on SSMS (SQL Server 20.0) | 🏦 Bank Loan Data Analysis & Cleaning 📊
A collection of fun, interesting, and challenging SQL projects showcasing my skills in data manipulation, querying, and analysis.
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.
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.
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
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.
Add a description, image, and links to the joins-group-by-case-window-functions topic page so that developers can more easily learn about it.
To associate your repository with the joins-group-by-case-window-functions topic, visit your repo's landing page and select "manage topics."