SQL Practice: Learn & Run SQL
Contains ads
Everyone
info
0+
Downloads
Everyone
Learn more
About this app
Learn SQL offline. This SQL practice app has short lessons, 150 graded exercises, a SQL editor that runs your own queries and SQL interview questions. Everything is free and nothing is locked.
LEARN SQL STEP BY STEP
50 short lessons in 12 modules take you from your first SELECT to window functions, CTEs and transactions. Every example in this SQL tutorial runs on a sample database with one tap, and any example opens in the editor so you can change it.
• Basics: SELECT, WHERE, ORDER BY, LIMIT, text and date functions
• Joins: INNER, LEFT, RIGHT, FULL and self joins
• GROUP BY, HAVING and aggregate functions
• Subqueries, UNION, CTEs and recursive queries
• Window functions: ROW_NUMBER, RANK, LAG and running totals
• INSERT, UPDATE, DELETE, table design, constraints, indexes and transactions
SQL PRACTICE WITH GRADED EXERCISES
150 exercises from easy to hard on four sample databases: a school, a shop, a company and a movie catalog. The app checks the rows your query returns, so any correct query passes, not one exact answer text.
• See why your result differs: missing rows, extra rows, wrong order, rounding or a NULL comparison
• Three hints per exercise, then the solution
• The expected result is one tap away
• Exercises that change data run on a fresh copy, so the samples never break
RUN SQL IN A REAL EDITOR
A full SQL editor and SQL compiler that runs SQLite on your phone.
• Syntax colors, line numbers and autocomplete for tables and columns
• Run everything, the statement at the cursor or a selection
• Format SQL and read EXPLAIN QUERY PLAN
• Errors explained in plain words, often with a fix you can apply
• A hint when a query returns zero rows, such as = NULL instead of IS NULL
• Query history, saved snippets and CSV export
• Stop a long query at any time
SQL INTERVIEW QUESTIONS
60 SQL interview questions grouped by topic and by junior, mid and senior level. Each one has a clear answer, a query you can run and the mistakes people often make.
SQL REFERENCE
152 entries for statements, clauses, operators and functions, each with syntax and a runnable example. Notes show where MySQL, PostgreSQL and SQL Server differ from SQLite.
YOUR OWN SQLITE DATABASES
• Create a database, or import a .db, .sqlite or .sql file
• Browse tables, columns, keys and an ER diagram
• Design tables without typing CREATE TABLE
• Export as .db, .sql or CSV
Your files stay on your device.
SQL OFFLINE AND FREE
No account, no sign-up and no subscription. Lessons, SQL practice and the editor all work without a connection. Favorites, notes and search help you find things again. Light and dark themes, on phones, tablets and foldables.
The app is supported by ads. If you want a quiet session, watch one short video to turn ads off for 24 hours.
LEARN SQL STEP BY STEP
50 short lessons in 12 modules take you from your first SELECT to window functions, CTEs and transactions. Every example in this SQL tutorial runs on a sample database with one tap, and any example opens in the editor so you can change it.
• Basics: SELECT, WHERE, ORDER BY, LIMIT, text and date functions
• Joins: INNER, LEFT, RIGHT, FULL and self joins
• GROUP BY, HAVING and aggregate functions
• Subqueries, UNION, CTEs and recursive queries
• Window functions: ROW_NUMBER, RANK, LAG and running totals
• INSERT, UPDATE, DELETE, table design, constraints, indexes and transactions
SQL PRACTICE WITH GRADED EXERCISES
150 exercises from easy to hard on four sample databases: a school, a shop, a company and a movie catalog. The app checks the rows your query returns, so any correct query passes, not one exact answer text.
• See why your result differs: missing rows, extra rows, wrong order, rounding or a NULL comparison
• Three hints per exercise, then the solution
• The expected result is one tap away
• Exercises that change data run on a fresh copy, so the samples never break
RUN SQL IN A REAL EDITOR
A full SQL editor and SQL compiler that runs SQLite on your phone.
• Syntax colors, line numbers and autocomplete for tables and columns
• Run everything, the statement at the cursor or a selection
• Format SQL and read EXPLAIN QUERY PLAN
• Errors explained in plain words, often with a fix you can apply
• A hint when a query returns zero rows, such as = NULL instead of IS NULL
• Query history, saved snippets and CSV export
• Stop a long query at any time
SQL INTERVIEW QUESTIONS
60 SQL interview questions grouped by topic and by junior, mid and senior level. Each one has a clear answer, a query you can run and the mistakes people often make.
SQL REFERENCE
152 entries for statements, clauses, operators and functions, each with syntax and a runnable example. Notes show where MySQL, PostgreSQL and SQL Server differ from SQLite.
YOUR OWN SQLITE DATABASES
• Create a database, or import a .db, .sqlite or .sql file
• Browse tables, columns, keys and an ER diagram
• Design tables without typing CREATE TABLE
• Export as .db, .sql or CSV
Your files stay on your device.
SQL OFFLINE AND FREE
No account, no sign-up and no subscription. Lessons, SQL practice and the editor all work without a connection. Favorites, notes and search help you find things again. Light and dark themes, on phones, tablets and foldables.
The app is supported by ads. If you want a quiet session, watch one short video to turn ads off for 24 hours.
Learn SQL offline: 150 exercises, a SQL editor and SQL interview questions
Updated on
Safety starts with understanding how developers collect and share your data. Data privacy and security practices may vary based on your use, region, and age. The developer provided this information and may update it over time.
What’s new
First release.
• 50 lessons in 12 modules, from SELECT to window functions
• 150 graded SQL exercises that explain why a result differs
• SQL editor on SQLite with autocomplete, run at cursor and plain-language errors
• 60 SQL interview questions with runnable answers
• 152-entry SQL reference
• Import, design and export your own SQLite databases
• Works offline
• 50 lessons in 12 modules, from SELECT to window functions
• 150 graded SQL exercises that explain why a result differs
• SQL editor on SQLite with autocomplete, run at cursor and plain-language errors
• 60 SQL interview questions with runnable answers
• 152-entry SQL reference
• Import, design and export your own SQLite databases
• Works offline
