Optimize Laravel queries using SQL JSON aggregation - reduce multiple relation queries to a single SQL statement

Reduce multi-relation Doctrine queries to a single SQL statement using JSON aggregation. Solves Doctrine's N+1 problem.

An end-to-end business analytics SQL portfolio built on a custom e-commerce database — designed to answer real business questions about customers, revenue, retention, and product performance using advanced SQL techniques.

AI Query Optimizer Report

A curated knowledge base and second brain for MySQL architecture, query optimization, and database administration. Structured for deep learning via Obsidian.

19 production-ready PostgreSQL queries solving real e-commerce analytics challenges. Advanced SQL techniques: CTEs, window functions, complex joins & stored procedures.

End-to-end SQL case study analyzing e-commerce sales data using joins, subqueries, procedures, triggers, and performance optimization

Sistema web para mineração e consulta de slow_logs do MySQL.

Spring Boot demo comparing JPA lazy loading (N+1 problem) vs EntityGraph optimization. Shows performance difference between 11 queries vs 1 query for Books-Authors many-to-many relationship. Includes query counting, tests, and metrics.

Querying, data manipulation, performance optimization, and AWS-specific SQL

A collection of algorithm solutions focusing on Data Structures, Time Complexity analysis, and SQL optimization.

Scalable ETL pipeline and PostgreSQL optimization for 40M+ records. Features memory-efficient Python preprocessing and B-Tree indexing for a 95% reduction in query latency.

Interactive Data Analytics Dashboard for German Crime Victim Statistics (2023-2024). High-performance visualization of 430k+ records using PHP, MySQL, and Chart.js.

SaaS-style SQL auditor for B2B data teams: analyzes schema + queries using LLM + rules engine to audit, optimize, and explain SQL in natural language.

Real-time FX rates processing with SQL batch and Kafka streaming solutions

Production-grade PostgreSQL analytics system for content engagement analysis

SQL performance analysis and optimization advisor with SQLMesh integration

🕵️ Surgical SQL monitoring for Django. Catch performance leaks, redundant queries, and slow database hits directly in your console. Zero-UI, API-ready, and built with modern Python 3.11+ type safety

Real-world SQL query optimization case studies with before/after performance metrics and best practices

This repository contains solutions to the first 50 SQL problems on LeetCode. Each problem is solved using SQL queries, with detailed explanations and efficient approaches. These solutions aim to help users improve their SQL skills and understanding of database concepts while providing clear and well-documented code for reference.