This repository contains a collection of SQL scripts demonstrating various analytical techniques, such as changes over time, cumulative, performance, data segmentation, part-to-whole analysis.

#8WeekSQLChallenge, https://8weeksqlchallenge.com: Solutions for SQL Case Studies

Advanced SQL workbook: subqueries, window functions, CTEs, recursive CTEs, and datetime practice.

Проекты курса Инженер данных на платформе Yandex Practicum

💸 Bitcoin trading analysis

SQL projects using the different functions from basic to advance

Selected subset of Win (user32, shell32) API function calls for Window, Taskbar, etc handling, conveniently organized and wrapped in a C# DLL

This project is a SQL database management system that handles multiple tables and performs various queries and operations on them. It involves four different tasks, each with its own set of tables and questions to solve. The tasks cover a range of scenarios, that allow to apply basic, intermediate and advance SQL queries to different datasets.

8 Week SQL Challenge solutions — MySQL solutions for 7 case studies (Danny Diner to Balanced Tree). Covers window functions, 10-CTE funnels, market basket self-joins, and percentile calculations.

SQL Case Studies solved using Microsoft SQL Server and PostreSQL

This repository contains the code and examples for my article on Medium, which provides an introduction to Window Functions in Apache Spark.

120 years of Olympic history: athletes and results from basic biodata on athletes and medal results from Athens 1896 to Rio 2016.

SQL Challenge

A Godot addon node that maps a Window accurately into 2D world space, with full control both ways.

SQL-based analysis of Apple retail sales data to uncover insights on sales trends, product performance, and warranty claims using large-scale datasets.

HR analytics using advanced SQL | Window functions, CTEs, views, indexing | Optimized for dashboard consumption | MySQL

Advanced SQL analytics demonstrating window functions, CTEs, and cumulative calculations — techniques directly applicable to financial services reporting.

This repository showcases an SQL data analytics project demonstrating Exploratory Data Analysis (EDA) and Advanced Analytics (CTEs, Window Functions, Subqueries, Views) in PostgreSQL.

Creating Report for decision making in Film Rental Store

Pizza Sales analytics with sql

I have started a new playlist called MySQL on my YouTube channel. Watch the videos to learn SQL from scratch.

End-to-end SQL project analyzing customer churn and revenue using transactional sales data. The project applies SQL joins, aggregations, CTEs, and window functions to classify customers into Active, Churned, and Never Converted segments, with results visualized in Power BI.

Advanced SQL project analyzing e-commerce sales using joins, CTEs, and window functions. Includes sample data (CSV) and queries with business insights.

📊 End-to-end SQL data analysis project on Indian Election dataset | PostgreSQL | Advanced SQL | Data Modeling | Insights

SQL-запросы в Google Colab с помощью SQLite и PostgreSQL

This repository is part of my journey to learn **PySpark**, the Python API for Apache Spark. I explored the fundamentals of distributed data processing using Spark and practiced with real-world data transformation and querying use cases.

Analyzing the data using advancede sql techniques like data segmentation, change-over-time trends, cumulative analysis.

Postgres playground for features implementation

End-to-end SQL analytics project on Amazon India sales data — pricing strategy, discount behavior, customer segmentation, cumulative analytics, and part-to-whole market share analysis using T-SQL and window functions.

SQL-based end-to-end analysis of 100K+ e-commerce orders (Olist dataset), covering revenue growth, logistics performance, and RFM customer segmentation to drive business insights.