Why SQLite says misuse of aggregate COUNT(), why PostgreSQL says a column must appear in the GROUP BY clause, why SQLite sometimes gives a wrong answer with no error at all, and how WHERE and HAVING differ.
Why SQLite says "no such column", how single quotes fix the usual cause, the four other causes (a typo, another table, an alias, an old table) and the errors that look alike. With a table you can run.
· 6 min read
Frequently asked questions
What students ask before they start Databases & SQL Fundamentals.
Do I need to install anything?
Not for this course. The editor in the page runs your code next to the chat. If you prefer, you can use DB Browser for SQLite on your own computer.
What if I get stuck?
The tutor gives a ladder of hints, from a light nudge to the solution, and only after you have made a real attempt.
Do I keep my code?
Yes. In the editor in the page, your project is saved on the server for this course, continues in your next session on any device, and downloads as a .zip.
Do I get a certificate?
Yes. When you have finished every session, you get the Databases & SQL certificate of completion with your name: a link anyone can check, one-click LinkedIn and a PDF.
Do I need anything from before?
No. This course starts from zero. Take the sessions in order: each one builds on the one before.
Write your first query in the next 20 minutes.
Twenty minutes with the tutor, right in your browser. No card, nothing to install.