# Insert, update, delete

In this lesson, we will explore INSERT, UPDATE, and DELETE queries, before being given the opportunity to implement these queries using our 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.

#### Unit quizzes are being retired in August 2023

Why we're removing unit quizzes from the website >
Quiz:

# Insert, Update, Delete –

Use this table of data to answer the questions below

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

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

#### Unit quizzes are being retired in August 2023

Why we're removing unit quizzes from the website >
Quiz:

# Insert, Update, Delete –

Use this table of data to answer the questions below

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

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

## Time to move!

Did you know that exercise helps your concentration and ability to learn?

For 5 mins...

Move around:
Jog

On the spot:
Dance