Module 2 · SQL — asking the database directly Lesson 4 of 15
SELECT, WHERE, ORDER BY
The first four words of SQL. SELECT chooses columns, WHERE filters rows, ORDER BY sorts them, LIMIT caps the output.
Worked example
SELECT name, city FROM candidates WHERE city = 'Hyderabad' ORDER BY name LIMIT 10 — a small query that answers a real question.
Your practice task
Write five queries against a table of your own, each answering a question in plain English that you write down first.
Do this before moving on. Reading a solution teaches the shape of it; typing it teaches you.
Key takeaway
The first four words of SQL. SELECT chooses columns, WHERE filters rows, ORDER BY sorts them, LIMIT caps the output.
Keep your place in this course
A free account saves which lessons you have finished and unlocks the certificate. The lesson itself stays free to read.
Create free account or sign inCourse complete
You finished every lesson.
Your certificate is ready, and the projects you built are the proof to attach to an application.
Almost there
15 lessons left of 15
Finish every lesson to unlock the certificate. Each one ends in a practice task — do them and the final project brief writes itself.