The materials of the free 30-hour SQL course: the databases for SQL Server, MySQL and PostgreSQL, every query of the 41 chapters, and the slides.
-
Updated
Nov 6, 2026 - TSQL
The materials of the free 30-hour SQL course: the databases for SQL Server, MySQL and PostgreSQL, every query of the 41 chapters, and the slides.
Exploratory data analysis and advanced analytics in SQL, from the first look at the data to a customer report and a product report. The data and every query.
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
A professional SQL project demonstrating the core concepts of MySQL Window Functions, including ranking, running totals, and comparing values across related rows.
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.
Проекты курса Инженер данных на платформе 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.
Entity Framework Core provider for MySQL and MariaDB. Supports .NET 11 / EF Core 11, with a maintained .NET 10 / EF Core 10 line. Typed CTEs, window functions, locking reads, INSERT SELECT, UPSERT, migrations and scaffolding.
SQL projects using the different functions from basic to advance
SQL database design in PostgreSQL: normalization (1NF→3NF), ERD diagrams, subqueries, window functions, indexing and query optimization
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.
Coleção de queries PostgreSQL | CTEs, window functions, índices, EXPLAIN ANALYZE e isolamento multi-tenant
Selected subset of Win (user32, shell32) API function calls for Window, Taskbar, etc handling, conveniently organized and wrapped in a C# DLL
从零开始,16 课掌握 SQL。每课有完整建表+插入+查询示例,可直接复制到 SQLite/MySQL 运行。涵盖 CRUD、聚合、多表查询、子查询、索引、事务、存储过程、SQL 注入防御、窗口函数,最终完成博客系统实战。From SELECT to a blog system in 16 lessons.
SQL analysis of Olist Brazilian e-commerce data using MySQL — sales, customer behavior, and delivery performance.
To associate your repository with the window-functions topic, visit your repo's landing page and select "manage topics."