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.
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
These challanges were asked on this webiste.
This repository will contain all leetcode problems and solved solution for SQL starting from beginning to advanced question
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
A similar environment that of various IPL Fantancy Sports App like Dream11 is created and the data is extracted according to questions asked.
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 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.
SQL Assignment
Covid 19 Data Exploration & Cleaning using SQL.
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"
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.
Add a description, image, and links to the windowfunction topic page so that developers can more easily learn about it.
To associate your repository with the windowfunction topic, visit your repo's landing page and select "manage topics."