Best April deals - hours only!Up to 80% off on all courses and bundles.-Close
1. The four operations


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.


Click Next exercise to continue.