9 · Lesson 3 of 4
SQL: SELECT, FROM and WHERE
Syllabus 9.4Syllabus 9.5
What this lesson covers
- Read and complete SQL scripts
- Identify the output of an SQL query
Key vocabulary
- SQL
- Structured query language: used to search and manage databases.
- SELECT
- Lists the fields to show in the results.
- FROM
- Names the table to search.
- WHERE
- Sets the condition that records must meet.
- *
- A wildcard meaning every field.
- <>
- The SQL operator for 'not equal to'.
Check your learning
- Quick check: 4 questions
- Key vocabulary test: 6 terms
- Activity 1: Write the query · 5 tasks
- Activity 2: What will it output? · 6 questions
- Activity 3: SQL quiz · 8 questions