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

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.

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

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.

Production-grade PostgreSQL analytics system for content engagement analysis

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

This repository contains database schema designs that follow industry best practices. The schemas are designed with scalability, modularity, and maintainability in mind, and they are freely available for developers to use, study, and improve upon.

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.

Centralized SQL architecture for 400K+ records with Privacy-First AI anomaly detection. Reduced latency by 24x. Focus: HealthTech & PDPA compliance.

📊 Analyze content engagement to uncover strategy opportunities with this production-grade PostgreSQL analytics platform.