Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Operating on Data in SQL

CRUD
1. The four operations

Instruction

It's time to wrap things up! We have learned how to add, modify and remove data from a database. In the SQL Queries course you also learned how to select data from a database.

This sequence of four operations is often referred to with the acronym CRUD:

  • Create
  • Retrieve
  • Update
  • Delete

Any application handling data will be able to do the four operations.

Remember, in SQL:

  • you create data with the INSERT command,
  • you retrieve data with the SELECT command,
  • you update data with the UPDATE command,
  • you delete data with the DELETE command.

Exercise

Click Next exercise to continue.