Building out a CRUD application

What CRUD means?

So to create a CRUD application, let's first learn CRUD.

CRUD stands for Create, Read, Update, Delete.

C == Create
R == Read
U == Update
D == Delete

For every one of these verbs, There are equivalent SQL statements that match that verb for want to do to a database.

Create:

Whenever we want to create an object in our web application, We want to commit an insert statement in our relational database.

Read:

When we want to read records from the user's perspective on a web application, We want to select certain records from our database so that we can feed them into the view that the client sees.

Update:

When we want to update something from the user's perspective, The user clicks a button, checks the checkbox, or submits a form.

Changing something that already exists in that web application, we want to execute an update statement to our database.

Delete:

Finally, when a user chooses to remove something and delete that, we want to execute a delete statement on our database.