Reading about SQL doesn't make you good at it. Typing queries does.
Direct answer
To practise SQL, write queries every day on a database that interests you. Use an in-browser SQL playground or an interactive course, try a SQL game for fun, and finish with a small project where you ask real questions of real data. Predict the result before you run each query.
Exercise ladder
- Select and filter: list all customers from one city.
- Sort: top 5 most expensive items.
- Count and group: orders per customer.
- Join: customers with their orders.
- Change data: add a record, update a price. Use
WHERE! - Design: plan two tables and connect them.
Games and interactive tools
Playing helps motivation. See our list of SQL games. Choose ones where you write real queries, not only click.
Project ideas
- Your budget: where does the money go each month?
- A film or music collection: which year has the most?
- A tiny shop: best-selling products, quietest days.
- A cinema: which shows fill up, who books most? (That's the dataset in Teyro's SQL course.)
Write five questions, then answer each with a query.
Habits that make practice stick
- Practise a little every day.
- Predict the output first.
- Fix errors by reading the message.
- Keep a file of queries you're proud of.
Next steps
Follow the path in how to learn SQL for beginners and the basics in what is SQL.
Where Teyro fits
Teyro's SQL and Databases for Beginners course puts practice in every lesson: real SQLite in your browser, a cinema booking database, short lessons on your phone. It is free to start.
The bottom line
Practise small, practise daily, and answer real questions.
