All righty.
So in this section, we're going to focus on the basics of something called CRUD.
So it's an acronym CRUD, and it stands for Create, Read, Update and Delete or destroy some variation
of that.
The idea is that these are the four main operations that we perform on our data.
We've already seen how to create data.
When we have a database, we want to be able to add data in.
We want to be able to search back or read it back out.
We want to be able to update it and then also to delete it.
Those are the four most important and most common operations that we'll do.
And CRUD itself, the acronym is not particular to databases.
It's common in other facets of programming and web development.
But it's a nice acronym that fits what we are trying to do here.
So what we're going to do is step through all four different operations and we've already seen create.
It should be reviewed hopefully which we do using insert into.
So going back to our cats, we have things like insert into cat's name and age and then the values taco
and 14.
So we won't spend any more time talking about create in this section but we'll be using insert into
throughout the rest of the course.
But really what we're going to focus on here are the other three operations.
So how do we read data out?
How do we search, how do we find things?
How do we update data if we made a mistake or something changes?
And then how do we delete data?
How do we delete everything from a table and how do we delete one or two things at a time?
So that's really what this section will focus on, and we'll kick it off by talking about reading data
out.