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.
Advanced PostgreSQL database project demonstrating stored procedures, triggers, views, indexing, recursive CTEs, and concurrency control.
Active infrastructure dependency tracker and self-healing graph engine to detect and repair lineage loop anomalies.
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.
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.
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.
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.
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.
🗃️ T-SQL query practice against the BikeStores sample database — recursive CTEs, window functions, joins, date logic, and dynamic SQL.
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.
수학 지식그래프 기반 자가진단 AI 튜터링 서비스 (1인 개발). Spring Boot 3 + React 모노레포 · Neo4j → MySQL 재귀 CTE 통합 · 단일 EC2 blue-green 무중단 배포
Add a description, image, and links to the recursive-cte topic page so that developers can more easily learn about it.
To associate your repository with the recursive-cte topic, visit your repo's landing page and select "manage topics."