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.
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.
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.
AI-powered analyzer for legacy COBOL estates — maps call graphs, detects recursive cycles, and generates modernization tickets. Next.js + Vercel + Aurora PostgreSQL + Claude.
Active infrastructure dependency tracker and self-healing graph engine to detect and repair lineage loop anomalies.
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.
Service-dependency blast radius, deploy order, and cycle detection computed entirely with Postgres recursive CTEs. React 19 + Express 5 + TypeScript.
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.
Pure SQL over IMDb's full 141M-row dataset: 15 queries incl. a recursive-CTE Kevin Bacon traversal, plus 11 tests that caught real referential gaps in IMDb's own exports.
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.
A local-first, block-based note-taking app with a graph-native architecture. Built on Tauri v2, React 19, SQLite, and recursive CTEs for graph traversal.
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.
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
This project builds and analyzes a small transactional e-commerce database using SQL (SQLite). Main focus: Applying SQL to reach structural correctness before analytical output.
To associate your repository with the recursive-cte topic, visit your repo's landing page and select "manage topics."