common-table-expressions

This project analyzes e-commerce order fulfillment using Advanced SQL Techniques and Python-based visualization to uncover insights on sales trends, customer segmentation, shipping cost optimization, and payment preferences.

Production-focused EF Core 10 provider for MySQL 8.4/9.7 LTS and MariaDB 10.11/11.4/11.8/12.3 LTS, with JSON and complex types, temporal tables, CTEs, HiLo/sequences, NetTopologySuite spatial support, advisory-lock-protected migrations, diagnostics, and engine-aware SQL translation.

SQL Case Studies solved using Microsoft SQL Server and PostreSQL

PostgreSQL e-commerce analytics project featuring relational data modelling, automated setup, data-quality tests, views, indexes, CTEs and window functions.

A portfolio of end-to-end SQL case studies (Flight Data and Hospital Management) demonstrating advanced data cleaning, ETL, and exploratory data analysis using MySQL.

This project involved analyzing data for Rockbuster Stealth LLC, a fictional movie rental company transitioning to an online video rental service.

A Tableau dashboard showing the best hotel prices for places with ratings of 7.0 or greater.

Answering ad-hoc business questions about Rockbuster’s film inventory, customer data, and payment records to support their transition to an online video rental service.

data-modeling-analysis-sql

Built a Data Model, Implemented Basic to Advanced SQL Queries

A SQL project to analyze music store data. Find the results of given data with the help of answering the questions using queries.

IPL Data Analysis using SQL and MySQL to analyze team, player, batting, bowling, venue, toss, and season-wise performance.

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.

An Advanced SQL Analytics Project demonstrating end-to-end data analysis using SQL — from EDA and ADA to data transformations and final business reports. Includes two analytical views summarizing Customer and Product performance with insights on revenue, trends, and growth.

This project builds and analyzes a small transactional e-commerce database using SQL (SQLite). Main focus: Applying SQL to reach structural correctness before analytical output.

MySQL exploratory data analysis project investigating global layoffs by company, industry, country and time period.

This project documentation was developed as a free project, as a data analyst from the fictional company Sell Boardgames would do in his daily work.

LeetCode SQL 50

A step-by-step learning journey to master sql with hands-on exercises.

Healthcare analytics using PostgreSQL on a synthetic EHR dataset.