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

SQL projects using the different functions from basic to advance

💸 Bitcoin trading analysis

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.

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

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

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

A TypeScript library for digital signal processing and audio analysis.

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.

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

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

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

SQL practice covering joins, subqueries, aggregations, window functions, and CTEs — includes a self-designed coffee shop business case using MySQL/MariaDB.