SQL basics
Ask a database real questions: filter, sort, count, join tables and change data, then build a small report.
4 modules · 12 lessons · about 3 hours · Beginner
What you'll be able to do
Answer everyday questions about my data with SQL.
- Read and filter rows from one table.
- Sort results, keep the top few and boil rows down to counts and totals.
- Join tables, keep rows without a match and build reports across tables.
- Add, change and remove rows, then pull it all together in a capstone.
Course outline
1Asking questions
- Your first SELECT
- Filtering rows with WHERE
- Smarter filters
2Sorting and summarising
- Sorting with ORDER BY
- Counting and totals
- Counting with GROUP BY
3Combining tables
- Joining two tables
- Keeping every row with LEFT JOIN
- Joins meet GROUP BY
4Changing data
- Adding rows with INSERT
- Changing and removing rows
- Capstone: a bookshop report
How you'll learn
- Write and run real code in your browser. Nothing to install.
- Short lessons that build on each other, so every step makes sense.
- A tutor you can ask anytime. It knows the lesson you're on.
- Quick checks along the way, so you know it stuck.
Questions
Is SQL basics really free?
Yes. Make a free account and start right away. No card needed, and nothing to cancel later.
Do I need any experience?
No. It starts from zero and explains each new idea as it comes up.
How long does it take?
12 lessons in all, about about 3 hours in total. Go at your own pace: your progress is saved.
What if I get stuck?
Ask the tutor. It knows the lesson you're on and explains things another way until it clicks.
Can I learn on my phone?
Yes. Lernelle works in any browser, on your phone, tablet or computer.
Does it stay up to date?
Yes. We update the course when things change, and you can bring the new version into yours with one click.
Ready to start?
It takes a minute to sign up, and the first lesson is waiting.