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

A security and performance inspector for Django & DRF. Features static analysis, config checks, N+1 query detection, and SARIF support for GitHub Code Scanning.

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.

Database Reliability Engineering platform for HA/DR, 100TB+ migrations, performance guardrails, and self-healing data systems.

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.

Documentation-as-Code knowledge base for Platform Engineering: Linux systems, backend development (Java/Python/SQL), infrastructure (Docker/CI-CD), and LTS-safe operations runbooks.

🗄️ IBM Relational Database Administrator with GenAI Certificate Portfolio – A comprehensive collection of projects, labs, and assignments showcasing expertise in relational database administration, 🏘️data warehousing, 🔁ETL pipelines, and 🤖Generative AI integration for modern database management.

Personal portfolio showcasing end-to-end projects in Backend Development, Big Data Pipelines, and BI. Focused on Python, PySpark, Node.js, and SQL optimization.

An enterprise-grade, multi-vendor e-commerce platform built with Django & DRF. Features dual JWT/Session auth, an asynchronous cart API, Khalti payment integration, and highly optimized SQL queries (zero N+1 issues).

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.

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

Fast C extension for grouping consecutive monotonic sequences into ranges. O(n), works with any Comparable+succ type. Useful for compacting large IN() clauses in SQL.

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.

PostgreSQL query performance optimization using indexing

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

SQL performance analysis and optimization advisor with SQLMesh integration