Insert, update, delete

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

Video

Click on the play button to start the video. If your teacher asks you to pause the video and look at the worksheet you should:

  • Click "Close Video"
  • Click "Next" to view the activity

Your video will re-appear on the next page, and will stay paused in the right place.

Worksheet

These slides will take you through some tasks for the lesson. If you need to re-play the video, click the ‘Resume Video’ icon. If you are asked to add answers to the slides, first download or print out the worksheet. Once you have finished all the tasks, click ‘Next’ below.

This quiz includes images that don't have any alt text - please contact your teacher who should be able to help you with an audio description.

Quiz:

Insert, Update, Delete –

Use this table of data to answer the questions below

Question 1

Question 2

Question 3

Q1.What would be the most appropriate data type for car_reg?

tblSpeeds

1/3

Q2.What would be the most appropriate data type for Speed?

2/3

Q3.Which of the following describes the purpose of the following query: INSERT INTO tblSpeeds (Registered_owner, Car_reg, Speed)VALUES ("Sara Bibi","JN03HNM",70);

3/3

This quiz includes images that don't have any alt text - please contact your teacher who should be able to help you with an audio description.

Quiz:

Insert, Update, Delete –

Use this table of data to answer the questions below

Question 1

Question 2

Question 3

Q1.What would be the most appropriate data type for car_reg?

tblSpeeds

1/3

Q2.What would be the most appropriate data type for Speed?

2/3

Q3.Which of the following describes the purpose of the following query: INSERT INTO tblSpeeds (Registered_owner, Car_reg, Speed)VALUES ("Sara Bibi","JN03HNM",70);

3/3

Lesson summary: Insert, update, delete

It looks like you have not completed the quiz.

To share your results with your teacher please complete the quiz.

Browse Oak's lessons: