1
00:00:00,180 --> 00:00:01,410
Hey, welcome back.

2
00:00:01,620 --> 00:00:07,290
If you're looking at my desk right now and you're asking, wow, why is there so much crud on it?

3
00:00:07,500 --> 00:00:08,940
Well, you're on to something.

4
00:00:08,970 --> 00:00:11,670
This section is all about crud.

5
00:00:12,360 --> 00:00:12,900
Yeah.

6
00:00:14,100 --> 00:00:16,079
So crud is an acronym.

7
00:00:16,079 --> 00:00:21,660
It stands for for things C, R, U, and D, create, read, update and delete.

8
00:00:21,660 --> 00:00:25,800
And they are the four basic actions that we want to be able to do to our data.

9
00:00:25,800 --> 00:00:28,200
So we've actually seen two components already.

10
00:00:28,200 --> 00:00:33,630
We've seen how, let's say we're working with users, we've seen how to create users with the insert

11
00:00:33,630 --> 00:00:39,810
command, we've seen how to read users, take them back out, you know, spill the milk out of the database.

12
00:00:39,810 --> 00:00:43,320
That is the read section, which we did with select.

13
00:00:43,320 --> 00:00:48,600
Now we also are going to review more about select and insert, but primarily we're going to see how

14
00:00:48,600 --> 00:00:50,730
to update and delete information.

15
00:00:50,730 --> 00:00:54,870
So how do we change something in our database if we made a mistake or let's say a user changed their

16
00:00:54,870 --> 00:00:58,350
password, they clicked, forgot my password link and they want to reset it.

17
00:00:58,350 --> 00:01:01,020
We need to change it in the database and then delete.

18
00:01:01,230 --> 00:01:05,820
Let's say our user decides to leave our site for some really bad reason.

19
00:01:05,820 --> 00:01:07,620
We can delete him or her.

20
00:01:07,830 --> 00:01:09,870
So that's the focus of this section.

21
00:01:10,560 --> 00:01:15,150
We're going to have a ton of exercises because we're seeing a lot of commands, and now that we have

22
00:01:15,150 --> 00:01:19,410
those four commands in place, we'll be able to go do a lot of stuff.

23
00:01:19,410 --> 00:01:23,130
They're kind of the fundamental four things of any database or any data.

24
00:01:23,130 --> 00:01:24,930
So tons of challenges coming up.

25
00:01:24,930 --> 00:01:29,070
Look forward to that and I'll see you basically in the next section when I have to do another one of

26
00:01:29,070 --> 00:01:29,940
these videos.

27
00:01:29,970 --> 00:01:30,190
So you.