GCSE – Lesson 2 – SQL searches

Curriculum KS4 Unit Lesson

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
  • Slide decks
  • Learner resources
  • Homework

GCSE revision

A comprehensive range of content and helpful practice questions are also available for this topic.

View on Ada Computer Science