Spring Deals - hours only!Up to 70% off on all courses and bundles.-Close
Introduction
Inserting data
Modifying data
Deleting data
CRUD
14. SUMMARY: CRUD

Instruction

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

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

  • Create
  • Retrieve
  • Update
  • Delete

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

Remember, in SQL Server, you:

  • Create data with the INSERT command.
  • Retrieve data with the SELECT command.
  • Update data with the UPDATE command.
  • Delete data with the DELETE command.

Exercise

Click Next exercise to continue.