Computing

Y11 Computing

Key Stage 4

Year 11

Databases and SQL

In this lesson, we will explore the key terminology required to be able to use SQL to search and update a relational database. Together we will step through the key concepts using a music database as an example. We will complete the lesson by gaining some hands on experience of using a database management system.

Database essentials

In this lesson, we will use the music database from the previous lesson, 'Database essentials', to write our first SQL commands to access and manipulate the data.

SQL searches

In this lesson, we will explore INSERT, UPDATE, and DELETE queries, before being given the opportunity to implement these queries using our music database.

Insert, update, delete

In this lesson, we will use our SQL skills to build, interrogate, and update a database to manage swimming lessons.

Key Stage 4, Computing, Databases and SQL

Database essentials

SQL searches

Insert, update, delete

Swim challenge (Part 1)

Swim challenge (Part 2)