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

Press Next exercise to continue.