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.

This repository features SQL-based analysis on bike rentals and the NFT market. The bike rental project explores customer trends, peak rental times, and revenue insights, while the NFT case study analyzes sales trends, blockchain transactions, and market dynamics. Built using SQL queries for data cleaning, aggregation, and joins in MySQL.

Using complex SQL queries, including PostgreSQL window functions, to answer specific business questions. Notably using multiple named subqueries, views to extract data from a database to address specific problems.

Danny Ma's #8WeekSQLChallenge case study solutions.

Demo of using window function with JOOQ & Springboot

bunch of SQL Window function query examples

MySQL-for data analytics

Analyzing and cleaning of COVID-19 data using different SQL functionalities.

Аналитический проект из ad-hoc запросов к базе данных с данными об авиаперевозках

A Data Collection and Storage project using SQL from TripleTen

A collection of T-SQL scripts I written throughout my journey as a Data Analyst, Data Engineer, and BI Developer. They demonstrate the use of window functions, calculating dates, dynamic SQL, stored procedures, and other out of the box solutions.

This repository provides a comprehensive guide for building production-ready data warehouses using SQL Server. It walks through the complete process of implementing a modern data warehouse using Medallion Architecture (Bronze, Silver, Gold layers) with practical code examples and detailed.

MySQL + Tableau Project

data-modeling-analysis-sql

This repository contains SQL scripts for analyzing ERP and CRM data from the gold layer of the data warehouse built in PostgreSQL-Data-Warehouse-Project. It covers both exploratory data analysis and advanced analytics techniques like trend analysis, cumulative metrics, performance tracking, data segmentation, and part-to-whole evaluation.

MySQL code using subqueries and window functions

Case Study #1 - Danny's Diner

SQL exercises and projects done at alx training

Building a modern data warehouse with sql, including ETL processes, data modelling, and analytics.