You've now learned the three core commands for changing data: INSERT
, UPDATE
, and DELETE
. Let's practice choosing the right tool for the job and using them safely.
Remember, each command serves a unique purpose.
Engagement Message
Ready to practice your data manipulation skills?
Type
Multiple Choice
Practice Question
You need to change the email address for a user who already exists in your database. Which command should you use?
A. INSERT B. UPDATE C. DELETE D. SELECT
Suggested Answers
- A
- B - Correct
- C
- D
Type
Fill in The Blanks
Markdown With Blanks
Fill in the blanks to perform a sequence of operations: add a new user, update their job, and then remove them.
Suggested Answers
- INSERT
- UPDATE
- DELETE
Type
Sort Into Boxes
Practice Question
Sort these SQL keywords into the correct category.
Labels
- First Box Label: Commands
