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.
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.
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.
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.
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
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.
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.
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."