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.

SQL Engineeering Handbook by Mohammad Ammar . Production-ready with SQL tutorials, interview questions, real-world projects, query optimization, window functions, and analytics engineering examples. Created by the Co-Founder of Apex Analyticx . Live Portfolio : https://theammarngp.lovable.app

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

💸 Bitcoin trading analysis

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

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 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.

SQL projects using the different functions from basic to advance

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

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

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

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

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

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.

Structured T-SQL business intelligence analysis of the AdventureWorks dataset — sales trends, customer segmentation, and product performance using window functions, CTEs, and reusable reporting views.

🧠 Structured SQL Learning Repository | Beginner to Advanced Topics + Real Projects 🎯 Covers core SQL skills, window functions, performance tuning, and hands-on data warehousing/EDA projects