Myths about teaching can hold you back
Learn why
These resources will be removed by the end of the Spring Term 2026.
Start using our brand new teaching resources now. Designed by teachers and subject experts, with real classrooms in mind.
The older resources below were created for lockdown learning during the pandemic and are not designed for classroom teaching.
Lesson details
Key learning points
- In this lesson, we will use our SQL skills to build, interrogate, and update a database to manage swimming lessons.
Licence
This content is made available by Oak National Academy Limited and its partners and licensed under Oak’s terms & conditions (Collection 1), except where otherwise stated.
Loading...
3 Questions
Q1.Which field is the primary key in this table?
Which field is the primary key in this table?
Level
Sessions
Start_Date
Q2.What are the relationships between the tables?
What are the relationships between the tables?
Many to Many
One to One
Q3.How many records would the following query find?SELECT * FROM tblCourses WHERE Start_Date = “2020-10-04”; (Image source: DB Browser for SQLite)
How many records would the following query find?SELECT * FROM tblCourses WHERE Start_Date = “2020-10-04”; (Image source: DB Browser for SQLite)
1
2
4