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.

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.

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 .

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

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

Advanced SQL Analysis for Cars24 Sales Insights

SQL Assignment

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

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.