Intro and SELECT
Understand tables, rows and columns, then retrieve exactly what you need.
What you will be able to do
- Explain relational structure
- Select columns
- Alias output
A relational database stores data in tables. Each row is a record; each column has a name and a type. SQL is the language you use to ask questions.
SELECT title, level, minutes
FROM lessons
WHERE course_slug = 'html'
ORDER BY minutes DESC
LIMIT 5;| Clause | Job |
|---|---|
| SELECT | Choose the columns to return. |
| FROM | Name the table(s). |
| WHERE | Filter rows. |
| ORDER BY | Sort the result. |
| LIMIT | Cap the number of rows. |
Your turn
EasyList beginner courses
Return title and level from courses where level is "Beginner".
SQL · starter
SELECT
FROM courses
WHERECheck your understanding before moving on.
Knowledge checkQuestion 1
Which clause filters rows?
Select an answer to continue
Study tools
Make it yours.
Keep a private note for this lesson, then turn the key ideas into flashcards you can revisit.
Sign in to save notes and flashcards.Both are private to your account and stay with your progress.
Sign inFinished reading?
Lock in what you just learned.
0%
Mark this lesson complete to save your place and move one step closer to the certificate.