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.

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.

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

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

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

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

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.

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

Postgres + Docker SQL analytics lab with data quality checks, performance EXPLAIN notes, and CI.

This SQL Lab serves as a technical archive focused on solving complex business logic through advanced SQL queries and to master SQL concepts by tackling LeetCode challenges and translating them into real-world data scenarios. The lab features hands-on, optimized solutions that strengthen analytical thinking and practical problem-solving

DataLens is a high-performance log and event analytics backend that ingests large datasets, exposes real-time operational insights, and enables reproducible query/index benchmarking on PostgreSQL.

Production-grade PostgreSQL analytics system for content engagement analysis

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