GCSE
Lesson 2 SQL searches
SQL is introduced into this lesson. Learners use the music database from the last lesson to write their first SQL commands. The activities start with learners retrieving data using SELECT, FROM and WHERE statements. They complete increasingly challenging tasks for different search terms. They then move on to retrieving data from multiple tables.
Learning objectives
- Describe the function of SQL
- Use SQL to retrieve data from a table in a relational database
- Use SQL to retrieve data from more than one table in a relational database
Career video to support the unit
Zac Decent
Data Governance & Quality Manager
Computer Science can propel students into fulfilling careers of the future. In this video, Zac Decent, Data Governance & Quality Manager, explains the topic of databases (SQL) and how he uses it in his day-to-day role.
Package contents
- Lesson plans
- Learning graphs
- Unit overviews
- Activities
Not registered yet?
Create an account and get access to over 500 hours of free teaching resources.
GCSE revision
A comprehensive range of content and helpful practice questions are also available for this topic.