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

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

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

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

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.

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

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.

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

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.

🗳️ Analyze election data using SQL to unveil insights on party performance, voter trends, and constituency outcomes across India.