Learn SQL

TOPIAN SPIRIT FOUNDATION

About this app

Embark on a fantasy coding adventure and master SQL offline!

Learn SQL: Code & Play Offline turns database learning into an interactive RPG quest. Forget boring syntax sheets—become a Database Squire, join the Coding Guild, write real SQL queries, and level up your skills to restore order to the Kingdom's data registers.

Whether you are a absolute beginner or an aspiring database administrator, our offline-first curriculum takes you from basic queries to advanced database operations.

🤖 BUILT-IN OFFLINE SQL COMPILER
No internet? No problem. The app features an embedded, full-featured SQLite database engine that runs entirely on your device. Execute queries, inspect database schemas, and get instant autograding feedback without needing any server connection or data plan.

🎮 GAMIFIED CODING QUESTS & XP
* Earn Experience Points (XP) for every correct query.
* Maintain your Daily Learning Streak to build consistent habits.
* Unlock legendary achievements and badges in your Guild Profile (from SQL Recruit to Query Archmage).
* Visual progression tracker keeps you motivated.

📚 BASICS TO ADVANCED SQL CURRICULUM (13 MODULES)
1. SELECT Basics: Learn to retrieve table records.
2. Filtering with WHERE: Conditional logical checks (AND, OR).
3. Sorting Results: Ascending and descending outputs (ORDER BY).
4. Limiting Outputs: Retrieve top-N rows (LIMIT).
5. Pattern Matching: Search strings using wildcards (LIKE '%').
6. Grouping & Aggregations: Summarize datasets (GROUP BY, SUM, AVG, COUNT).
7. Filtering Groups: Apply constraints to aggregations (HAVING).
8. Joining Quests: Query relationships across multiple tables (INNER JOIN).
9. Nested Subqueries: Nest query statements inside other operations.
10. Conditional Columns: Add logic branches (CASE WHEN ... THEN ... ELSE).
11. Set Membership: Query set records (IN operator).
12. Common Table Expressions: Write cleaner code using WITH CTE blocks.
13. Null Handlers: Set fallback values for missing data (COALESCE).

🛠️ FREE-PLAY SQL SANDBOX & REFERENCE DESK
* SQL Playground: Write and execute custom queries against the local database in a free-form sandbox console.
* Reference Desk: Quick-access cheat sheet containing explanation cards and syntax templates for SELECT, JOIN, aggregates, and more.

🔒 100% OFFLINE, SECURE, & AD-FREE
* Works completely offline—perfect for commutes, flights, or off-grid study sessions.
* No registrations, no data collection, no account requirements.
* Sleek neon-purple and teal visual theme optimized for mobile readability.

Start your database coding journey today. Download Learn SQL and code your way to mastery!

What’s new

Initial production release for Learn SQL