Myths about teaching can hold you back
Learn why
These resources were made for remote use during the pandemic, not classroom teaching.
Switch to our new teaching resources now - designed by teachers and leading subject experts, and tested in classrooms.
Lesson details
Key learning points
- 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.
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 would be most suitable to be the Primary Key
Which field would be most suitable to be the Primary Key
Car_Reg
Registered owner
Speed
Q2.What would be the output of the following query: SELECT Car_reg WHERE Registered_Owner = "Abeni Barmore";
What would be the output of the following query: SELECT Car_reg WHERE Registered_Owner = "Abeni Barmore";
4
67
YM15PTO
Q3.What would be the output of the following query: SELECT CaptureID WHERE Speed > 70;
What would be the output of the following query: SELECT CaptureID WHERE Speed > 70;
1,2,3,6
4,5
6