How to Learn the SQL Commands
SQL is the language of databases, and a handful of keywords cover most of what you will ever do — read, filter, add, change and delete data. Learn these and you can query almost any database. This deck pairs each keyword with its job.
There are 12 cards in the deck below. You can read through them, practise them right here with the flip-card player, and then save the deck to study properly with spaced repetition — the method that makes them stick for months, not minutes.
Why the basic SQL commands is hard to memorize (and the fix)
Beginners mix up the data-changing commands (INSERT, UPDATE, DELETE) and forget that WHERE is what filters rows — a missing WHERE on a DELETE is a famous disaster.
The fix is active recall plus spaced repetition. Instead of re-reading the list (which feels productive but barely works), you test yourself — pull each answer out of memory — and you review each card on a schedule that stretches over time. Every time you successfully recall a fact, the memory gets stronger and the next review is pushed further out. That's how you go from "I saw it once" to "I just know it."
The fastest way to learn the basic SQL commands
- Break it into small batches. Learn the read commands first (SELECT, FROM, WHERE), then the write commands (INSERT, UPDATE, DELETE), then JOIN and sorting.
- Test, don't re-read. Look at the question, say the answer out loud before flipping the card. The little struggle to recall is what builds the memory — a smooth re-read does almost nothing.
- Review on a schedule. Spaced repetition shows you each card right before you'd forget it. Get one right and it comes back in a few days, then a week, then a month. Miss one and it comes back sooner.
- Keep sessions short and daily. Five to ten minutes a day beats a two-hour cram every time. Consistency is the whole game.
One fact per card. Always pair UPDATE and DELETE with a WHERE clause — without it, they change every row.
The full deck: the SQL Commands
Here's every card in the set. Practise them above, or save the deck and let spaced repetition schedule your reviews automatically.
| Keyword | What it does |
|---|---|
| What does SELECT do? | Retrieves (reads) data from a database |
| What does FROM do? | Specifies which table to query |
| What does WHERE do? | Filters rows by a condition |
| What does INSERT INTO do? | Adds new rows to a table |
| What does UPDATE do? | Changes existing rows |
| What does DELETE do? | Removes rows from a table |
| What does JOIN do? | Combines rows from two or more tables |
| What does ORDER BY do? | Sorts the results |
| What does GROUP BY do? | Groups rows to run aggregate functions (COUNT, SUM…) |
| What does SELECT * mean? | Select all columns |
| What does COUNT() do? | Counts the number of rows |
| Why is WHERE important with DELETE? | Without it, DELETE removes every row in the table |
Save this deck and actually remember it
Create a free account, keep this 12-card deck, and we'll schedule every review at the perfect moment. First deck free forever — no credit card.
Study this deck free →FAQ: learning the basic SQL commands
How long does it take to learn the basic SQL commands?
Most people can lock in the basic SQL commands within one to three weeks of short daily sessions. With spaced repetition doing 10–12 cards a day, you'll recognise them within days and recall them reliably within a couple of weeks.
What's the best way to memorize the basic SQL commands?
Active recall plus spaced repetition. Test yourself instead of re-reading, and review on a schedule that spaces the cards out over time. Flashcards are built for exactly this — which is why the deck above is the fastest path.
Is this deck free?
Yes. You can practise all 12 cards on this page for free with no account. Sign up (also free) to save the deck and let spaced repetition schedule your reviews so it sticks long-term.