4.4
2,100+ reviews on G2
Learning SQL means learning to ask a database questions: SELECT the columns you want FROM a table, filter rows with WHERE, sort with ORDER BY, then join and group tables. You need a free database and a sample table, then four skills:

Which columns, from which table.
Which rows to keep.
How to sort the result.
Combine and summarize tables.
Learn in Evernote. Clip the docs, let the AI Assistant fix your code, and search any snippet.
PostgreSQL and SQLite are free. The PostgreSQL documentation includes a tutorial that builds a sample weather table.
A SELECT statement has a select list (the columns), a table list (FROM) and optional conditions. SELECT * returns all columns.
Keep only the rows you need: WHERE city = 'San Francisco' or WHERE total > 100.
ORDER BY total DESC lists the biggest first. Without BY, PostgreSQL reports a syntax error.
Combine tables with JOIN, and summarize with GROUP BY and functions like COUNT and SUM.
Load a spreadsheet you care about into a table and answer real questions with it.
One entry per session. Copy it, or save it to your Evernote account and keep your snippets in the same note.
Date: [day] · Time spent: [minutes]
Topic: [one concept, like for loops or functions]
Source: [tutorial, chapter or video, with its link]
What I built: [a small program, in one line]
Error I hit: [the last line of the error message]
How I fixed it: [one sentence, plus the corrected snippet]
Next session: [the next concept to learn]
4.4
2,100+ reviews on G2
4.4
8,200+ reviews on Capterra
4.4
73,000+ reviews on App Store
248M
Registered users
Yes. PostgreSQL and SQLite are free, and the PostgreSQL documentation has a built-in tutorial.
Retrieving, adding, changing and summarizing data stored in relational databases.
SELECT and FROM, then WHERE and ORDER BY. After that, JOIN and GROUP BY.
It returns all the columns of the table. The PostgreSQL tutorial calls * a shorthand for all columns.
The PostgreSQL tutorial covers SELECT, WHERE, ORDER BY, joins and aggregate functions in chapters 2.5 to 2.7. How long it takes depends on your schedule.
No. SQL is its own language. The PostgreSQL tutorial starts with SELECT and needs no other programming language.
Keep one notebook for SQL: the tutorial pages you clip, your queries, and every error you fixed.
Save the PostgreSQL querying lesson with the Web Clipper. Keep it in a notebook called Learning SQL, with the weather table example and its link.
Put the orders query and its syntax error in a note. Ask the AI Assistant why sorting needs ORDER BY, and accept the corrected line.
Search for "ORDER BY" when you need the syntax again. Evernote finds it in your PostgreSQL clip and in the practice note, code blocks included.
Clip the docs you learn from, ask the AI Assistant why your code breaks, and find any snippet again by searching for it.
Start for free