Built to Prove SQL Mastery
QueryQuest is a portfolio project demonstrating deep SQL proficiency — from foundational SELECT statements to advanced recursive CTEs. Every challenge is hand-crafted with real datasets and a live in-browser SQL engine.
🎯 Project Goals
- Demonstrate SQL mastery across all skill levels
- Build a fully functional gamified platform
- Implement a real SQL engine (SQL.js / SQLite)
- Create story-driven adventure modes
- Design complete XP + leaderboard system
🔧 Tech Stack
Built entirely with web fundamentals — no frameworks, no build tools.
HTML5CSS3Vanilla JS
SQL.jsCodeMirrorSQLiteLocalStorage
📊 Challenge Coverage
- 42 standard SQL challenges across 6 tiers
- 6-case Detective murder mystery mode
- 5-mission Space Explorer sci-fi mode
- 7-floor SQL Dungeon RPG mode
- Progressive difficulty, always reachable
🏗️ Architecture
- Static site — GitHub Pages deployable
- SQL.js runs real SQLite in-browser
- nav-inject.js for consistent navigation
- Dark / Light mode with CSS variables
- Fully mobile responsive
SQL Concepts Covered
📋
SELECT & Filtering
WHERE, BETWEEN, IN, LIKE, IS NULL
📊
Aggregation
COUNT, SUM, AVG, MIN, MAX
🗂️
Grouping
GROUP BY with HAVING clauses
🔗
JOINs
INNER, LEFT, RIGHT, FULL OUTER
🔄
Subqueries
Correlated & scalar subqueries
🧱
CTEs
Common Table Expressions
🪟
Window Functions
RANK, ROW_NUMBER, OVER()
🌀
Recursive CTEs
Hierarchical data traversal
📈
Running Totals
Cumulative SUM with ROWS
⚡
Set Operations
UNION, INTERSECT, EXCEPT
📅
Date Functions
Temporal filtering & formatting
🔢
String Functions
UPPER, LOWER, SUBSTR, LENGTH
Ready to Test Your SQL?
Start with Rookie challenges or jump into a Detective, Space, or Dungeon adventure.