Advanced SQL - Discover sequential, step-by-step explanations and solutions, accompanied by the necessary database creation codes, available on Ankit Bansal Sir's YouTube channel for SQL. Give it a ⭐ and stay tuned for more updates!

Basic to Complex SQL Server queries with Adventure Works database including window functions, triggers, string manipulation, user-defined functions, CTE, recursive CTE, DML and DDL

The 6 most window functions in PySpark - based on my blog post

Exercises and projects covered in SQL Nanodegree by Udacity.

These challanges were asked on this webiste.

Rebel Foods, formerly known as Faasos, is a renowned food delivery company in India. It originated as a restaurant chain but transitioned into an online platform. Rebel Foods is known for providing affordable meals, a wide variety of cuisines, and prompt delivery services. They operate numerous brands and leverage technology to enhance the overall

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 will contain all leetcode problems and solved solution for SQL starting from beginning to advanced question

This SQL-based project analyzes Pizza Hut's sales data to uncover insights about customer behavior, product performance, and store efficiency. It focuses on optimizing decision-making by leveraging advanced SQL techniques.

No description provided.

this project to analyze the Online Retail dataset using SQL. The objective of this project was to obtain insights about the data and develop targeted marketing strategies for improving sales and customer loyalty.

We analyzed a Walmart sales dataset to gain insights using complex SQL queries.

No description provided.

SQL Assignment

Data science SQL Skillz(Postgre) - nanodegree udacity. Analyse d'une base de donnée provenant d'une société de location de film vidéo accompagnée d'un rapport visuel .

Advanced SQL Analysis for Cars24 Sales Insights

A similar environment that of various IPL Fantancy Sports App like Dream11 is created and the data is extracted according to questions asked.

This Repository Contains a collection of SQL Scripts demonstrating various analytical techniques, such as changes over time, cumulative, performance, part-to-whole anlaysis.

This project analyzes Namma Yatri ride data using Power BI and a SQL database to identify trends, peak times, and popular routes for data-driven insights.

This SQL Case study was provided by Ankit Bansal on his Youtube channel

This project involved comprehensive exploration and analysis of global COVID-19 data using SQL Server. The dataset included information on COVID-19 cases, deaths, and vaccination rates sourced from publicly available databases (e.g., Our World in Data). The primary objective was to extract meaningful insights from raw pandemic data.

Trying my hand at Leetcode Easy,Medium and Hard questions

📊 SQL Projects – Data Analysis Portfolio This repository contains hands-on SQL projects focused on real-world data scenarios. Each project demonstrates practical SQL skills including data cleaning, filtering, joins, aggregations, window functions, CTE usage, views, and business-driven insights.

This repository contains the SQL queries and the dataset to accompany an article on Medium.com titled "The Data Adventure 01: “How Long will your Business Start to Profit?” — An SQL Adventure"

An end-to-end SQL project on Reliance Finance Sales Analysis using PostgreSQL

Covid 19 Data Exploration & Cleaning using SQL.

This project cleans and prepares a layoffs dataset using SQL by removing duplicates, standardizing text, handling null/blank values, and dropping unnecessary columns. The result is a consistent, high-quality dataset ready for reporting, analysis, and visualization.

This project was completed as a part of the " Advanced Big Data" course at Nile University.

This project analyzes retail sales data to identify trends, optimize inventory, and enhance customer engagement. Using SQL, we transform raw data into actionable insights, focusing on sales trends, inventory optimization, and customer segmentation for targeted marketing.

A project analyzing Adventure Works data using SQL and visualizing insights in Power BI.