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.

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

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

💸 Bitcoin trading analysis

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

SQL projects using the different functions from basic to advance

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.

120 years of Olympic history: athletes and results from basic biodata on athletes and medal results from Athens 1896 to Rio 2016.

SQL Case Studies solved using Microsoft SQL Server and PostreSQL

SQL Challenge

This repository contains the code and examples for my article on Medium, which provides an introduction to Window Functions in Apache Spark.

HR Analytics with Advanced SQL | Window Functions, CTEs, Views, Indexing | Dashboard-Ready Queries

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

Advanced SQL analytics demonstrating window functions, CTEs, and cumulative calculations — techniques directly applicable to financial services reporting.

This repository showcases an SQL data analytics project demonstrating Exploratory Data Analysis (EDA) and Advanced Analytics (CTEs, Window Functions, Subqueries, Views) in PostgreSQL.

A collection of real-world SQL projects focused on business insights, data analysis, and advanced querying using MySQL.

Creating Report for decision making in Film Rental Store

Pizza Sales analytics with sql

Analyzing the data using advancede sql techniques like data segmentation, change-over-time trends, cumulative analysis.

This repository is part of my journey to learn **PySpark**, the Python API for Apache Spark. I explored the fundamentals of distributed data processing using Spark and practiced with real-world data transformation and querying use cases.