Build software better, together

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

• Updated Jun 25, 2018
• Shell

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.

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

SQL Assignment

Advanced SQL Analysis for Cars24 Sales Insights

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

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 .

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

• Updated Jan 16, 2021

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

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