GCSE – Databases and SQL

Curriculum KS4 Unit

Resources

This unit introduces learners to the world of databases and SQL. Learners explore the key terms used in a database and learn why relational databases are used to eliminate redundancy and inconsistencies that can occur in a flat file database. Next they explore increasingly challenging SQL commands where they retrieve, update and delete data in a relational database.

Unit guide

Updated: 10 Feb 2023

Learning graph

Updated: 10 Feb 2023

Summative assessment

Updated: 10 Feb 2023

Summative answer

Updated: 10 Feb 2023

Lessons

Lesson 1

Database essentials

Lesson 2

SQL searches

Lesson 3

Insert, update, delete

Lesson 4

Swim challenge part 1

Lesson 5

Swim challenge part 2