window-functions

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.

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

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

SQL practice repository covering data analysis, joins, aggregations, window functions, and real-world query solving for data engineering and analytics.

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

💸 Bitcoin trading analysis

HR analytics pipeline: 30 employees · 5 departments · $58K–$135K salary range. PostgreSQL + SQL (CTEs, window functions) + Python + Tableau. Sales dept leads at $102K avg.

A professional SQL project demonstrating the core concepts of MySQL Window Functions, including ranking, running totals, and comparing values across related rows.

SQL projects using the different functions from basic to advance

A comprehensive collection of 50 optimized SQL solutions for the LeetCode SQL 50 study plan, covering fundamental to advanced database querying concepts like Joins, Subqueries, and Window Functions.

Advanced SQL in MySQL 8.0: window functions, pivot tables, regex, stored procedures, employee management project, ML data prep

Retail analytics pipeline: 2,314 customers · 5,000 transactions · $2.58M revenue. PostgreSQL + SQL (CTEs, window functions) + Python + Tableau + Excel.

SQL database design in PostgreSQL: normalization (1NF→3NF), ERD diagrams, subqueries, window functions, indexing and query optimization

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

Production-ready SQL Engineering Handbook with SQL tutorials, interview questions, real-world projects, query optimization, window functions, and analytics engineering examples.

A TypeScript library for digital signal processing and audio analysis.

SQL case studies on real-world domains E-Commerce, HR Analytics, Hospital Management, and Banking. Covers joins, aggregations, subqueries, window functions, and CTEs.

SQL analysis of Olist Brazilian e-commerce data using MySQL — sales, customer behavior, and delivery performance.

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.

PostgreSQL queries from basic joins to window functions, recursive CTEs and measured index optimisation. One e-commerce schema, one Docker command, pure SQL.