windowfunction

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 .

Exercises and projects covered in SQL Nanodegree by Udacity.

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

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

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"

Trying my hand at Leetcode Easy,Medium and Hard questions

These challanges were asked on this webiste.

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

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.

SQL Assignment

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

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!

Covid 19 Data Exploration & Cleaning using SQL.

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

This repository will contain all leetcode problems and solved solution for SQL starting from beginning to advanced question

Advanced SQL Analysis for Cars24 Sales Insights

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.

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.