window-functions 开源项目推荐（949 个）

DataWithBaraa /sql-ultimate-course

免费30小时SQL课程的材料：SQL Server、MySQL和PostgreSQL的数据库，41章中的每个查询，以及幻灯片。

DataWithBaraa /sql-data-analytics-project

在 SQL 中进行探索性数据分析与高级分析，从初步查看数据到客户报告和产品报告。数据与每条查询。

santoshkhatri9860 /advanced-sql-practice-mysql

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

muryulia /8-Week-SQL-Challenge

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

Victor-Kipruto-Rop /SQL-for-Data

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

theammarngp-makes /SQL-Engineering-Handbook

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

VIJAYAPANDIANT /elevate-labs-sql-task15

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

VIJAYAPANDIANT /leetcode-sql50

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.

SergeySenigov /data-engineer-practicum-portfolio

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

ndleah /bitcoin-prices-analysis

💸 Bitcoin trading analysis

evgeniimatveev /hr-bi-analytics-project

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

ellaclauz /SQL-FOR-DATA-ANALYSIS

SQL projects using the different functions from basic to advance

evgeniimatveev /SQL-Database-Design-A-Z

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

evgeniimatveev /Advanced-SQL-Data-Management-A-Z

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

evgeniimatveev /business-sql-analytics

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

wescaxeta /postgresql-queries

Coleção de queries PostgreSQL | CTEs, window functions, índices, EXPLAIN ANALYZE e isolamento multi-tenant

etfovac /WinAPI

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

7G-one /SQL-from-Zero-to-Window-Functions-The-Deepest-Zero-Base-SQL-Course

从零开始，16 课掌握 SQL。每课有完整建表+插入+查询示例，可直接复制到 SQLite/MySQL 运行。涵盖 CRUD、聚合、多表查询、子查询、索引、事务、存储过程、SQL 注入防御、窗口函数，最终完成博客系统实战。From SELECT to a blog system in 16 lessons.

nvmarpita /olist-ecommerce-sql-analysis

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

chdh /dsp-collection-js

A TypeScript library for digital signal processing and audio analysis.