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.

SQL case studies and exercises from my studies at Mate Academy. This repository contains queries for data analysis, transformations, and optimization, covering topics like joins, window functions, and aggregate queries. A learning journey in SQL for data analytics.

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.

Built a Data Model, Implemented Basic to Advanced SQL Queries

SQL exercises and projects done at alx training

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

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.

SQL_Notes: Learn SQL concepts through practical application! This repository contains concise notes on key SQL concepts, commands, and techniques, illustrated by solutions to LeetCode SQL challenges and exercises from other sources. Sharpen your SQL skills by understanding the why behind the code!

Welcome to the "Spotify Music Analysis - 2023" project! Here, we're exploring a carefully compiled dataset showcasing the standout songs of 2023, as documented by Spotify. This dataset goes beyond the usual song collections, offering a complete look into each track's characteristics, popularity, and visibility across different music platforms.

bunch of SQL Window function query examples

Demo of using window function with JOOQ & Springboot

Danny Ma's #8WeekSQLChallenge case study solutions.

This project demonstrates a comprehensive data warehousing and analytics solution, from building a data warehouse to generating actionable insights. Designed as a portfolio project, it highlights industry best practices in data engineering and analytics.

MySQL-for data analytics

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.

This repository contains the solutions of the 8 case studies for The 8 Weeks SQL Challenge

data-modeling-analysis-sql

MySQL + Tableau Project

MySQL code using subqueries and window functions