1
00:00:00,180 --> 00:00:00,870
All righty.

2
00:00:00,870 --> 00:00:05,520
So in this section, we're going to focus on the basics of something called CRUD.

3
00:00:05,850 --> 00:00:15,660
So it's an acronym CRUD, and it stands for Create, Read, Update and Delete or destroy some variation

4
00:00:15,660 --> 00:00:16,200
of that.

5
00:00:16,650 --> 00:00:21,420
The idea is that these are the four main operations that we perform on our data.

6
00:00:21,810 --> 00:00:24,270
We've already seen how to create data.

7
00:00:24,660 --> 00:00:28,680
When we have a database, we want to be able to add data in.

8
00:00:28,950 --> 00:00:31,860
We want to be able to search back or read it back out.

9
00:00:32,400 --> 00:00:35,610
We want to be able to update it and then also to delete it.

10
00:00:35,610 --> 00:00:39,930
Those are the four most important and most common operations that we'll do.

11
00:00:39,930 --> 00:00:43,980
And CRUD itself, the acronym is not particular to databases.

12
00:00:44,340 --> 00:00:47,400
It's common in other facets of programming and web development.

13
00:00:47,400 --> 00:00:50,820
But it's a nice acronym that fits what we are trying to do here.

14
00:00:50,820 --> 00:00:56,040
So what we're going to do is step through all four different operations and we've already seen create.

15
00:00:57,230 --> 00:01:01,910
It should be reviewed hopefully which we do using insert into.

16
00:01:02,240 --> 00:01:09,800
So going back to our cats, we have things like insert into cat's name and age and then the values taco

17
00:01:09,800 --> 00:01:11,060
and 14.

18
00:01:11,900 --> 00:01:17,360
So we won't spend any more time talking about create in this section but we'll be using insert into

19
00:01:17,360 --> 00:01:18,530
throughout the rest of the course.

20
00:01:18,800 --> 00:01:23,480
But really what we're going to focus on here are the other three operations.

21
00:01:23,480 --> 00:01:24,950
So how do we read data out?

22
00:01:24,950 --> 00:01:27,320
How do we search, how do we find things?

23
00:01:27,320 --> 00:01:32,030
How do we update data if we made a mistake or something changes?

24
00:01:32,030 --> 00:01:33,590
And then how do we delete data?

25
00:01:33,590 --> 00:01:38,120
How do we delete everything from a table and how do we delete one or two things at a time?

26
00:01:38,480 --> 00:01:43,640
So that's really what this section will focus on, and we'll kick it off by talking about reading data

27
00:01:43,640 --> 00:01:44,180
out.