Lessons (5)
These resources will be removed by end of Summer Term 2025.
Switch to our new teaching resources now - designed by teachers and leading subject experts, and tested in classrooms.
These resources were created for remote use during the pandemic and are not designed for classroom teaching.
- 1 Slide deck
- 1 Worksheet
- 1 Quiz
- 1 Video
- 1 Slide deck
- 1 Worksheet
- 1 Quiz
- 1 Video
- 1 Slide deck
- 1 Worksheet
- 1 Quiz
- 1 Video
- 1 Slide deck
- 1 Worksheet
- 1 Quiz
- 1 Video
- 1 Slide deck
- 1 Quiz
- 1 Video
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.
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.
In this lesson, we will explore INSERT, UPDATE, and DELETE queries, before being given the opportunity to implement these queries using our music database.
In this lesson, we will use our SQL skills to build, interrogate, and update a database to manage swimming lessons.
In this lesson, we will use our SQL skills to build, interrogate, and update a database to manage swimming lessons.
Can't find what you need?
Create a tailor-made lesson plan and resources on any topic with Aila, our free AI-powered lesson assistant. Entirely adaptable to your class and context.