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
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.