recursive-cte

Advanced SQL workbook: subqueries, window functions, CTEs, recursive CTEs, and datetime practice.

PostgreSQL queries from basic joins to window functions, recursive CTEs and measured index optimisation. One e-commerce schema, one Docker command, pure SQL.

PHP + MySQL iç içe kategori ağacı: adjacency list, recursive CTE ile tek sorguda okuma, sürükle-bırak taşıma, döngü ve derinlik koruması, alt ağaç ürün sayaçları — PDO, Ajax, Bootstrap 5

Advanced PostgreSQL database project demonstrating stored procedures, triggers, views, indexing, recursive CTEs, and concurrency control.

Threaded comments API in Go: nested trees with recursive CTEs, paginated root threads, sqlc + PostgreSQL

Service-dependency blast radius, deploy order, and cycle detection computed entirely with Postgres recursive CTEs. React 19 + Express 5 + TypeScript.

Active infrastructure dependency tracker and self-healing graph engine to detect and repair lineage loop anomalies.

Enterprise-grade SQL portfolio isolating advanced database engineering from any dashboard or app layer — window functions, recursive CTEs, transactional stored procedures, triggers, and measured query optimization on PostgreSQL, verified with real EXPLAIN ANALYZE evidence.

End-to-end PostgreSQL e-commerce analytics project covering data quality, relational modeling, safe financial reconciliation, business KPIs, recursive CTEs, RFM, retention and query optimization.

Reconciling a merchant's true target_base (customers reached) from raw SQLite send logs — resolving retry chains via recursive CTEs, campaign eligibility gates, and standalone vs. chained dedup logic. Includes a full reconciliation bridge, verified SQL, and an independent pandas validation script.

Engineered advanced SQL solutions for analytical, hierarchical, and data engineering problems using SQL Server.

Production-tested Postgres patterns for graph-shaped data — recursive traversal, hybrid trigram+vector entity resolution, momentum scoring, keyset pagination. Runnable and verified.

🗃️ T-SQL query practice against the BikeStores sample database — recursive CTEs, window functions, joins, date logic, and dynamic SQL.

Dependency-graph risk analysis in SQL: recursive CTE traversal over 117 npm roots finds 52.8% of 1,985 reachable packages have a single maintainer, and jest installs 284 packages from 4 declared.

Advanced SQL project analyzing financial transaction datasets to uncover fraud patterns, suspicious transfers, balance inconsistencies, and high-risk accounts using CTEs, recursive queries, and window functions.

SQL portfolio: multi-level BOM, glaze chemistry, costing and supplier what-if (MySQL 8, synthetic data)

AI-powered analyzer for legacy COBOL estates — maps call graphs, detects recursive cycles, and generates modernization tickets. Next.js + Vercel + Aurora PostgreSQL + Claude.

A container terminal where PostgreSQL decides what’s allowed to happen. Three berths, cranes on a shared rail, robot trucks, rail and customs, all simulated in SimPy and committed as transactions. Traffic, stacking and stowage rules are constraints and triggers. Rendered as an isometric 3D diorama.

Healthcare analytics portfolio: 36 SQL exercises on 7M+ rows across 17 tables. Window functions, recursive CTEs, risk scoring, revenue cycle analysis. $13.3B opportunity identified. Built with SQLite + Python + pandas

SQL case study analysing Data Bank, a fictional neo-bank that ties cloud storage to account balance, using MySQL. Covers node security, transaction analysis, and four data provisioning models including daily compounding interest. Part of the 8 Week SQL Challenge by Danny Ma.