1
00:00:00,390 --> 00:00:02,040
Hey, welcome to the next section.

2
00:00:02,130 --> 00:00:05,010
So this section is a bit different than everything else.

3
00:00:05,400 --> 00:00:08,100
I mean, I guess you could say that for every section, hopefully.

4
00:00:08,100 --> 00:00:12,630
But the structure is pretty different because it's all challenges, it's all exercises.

5
00:00:12,630 --> 00:00:16,830
So the way that this will work is you're going to practice all the commands you've seen up until this

6
00:00:16,830 --> 00:00:22,680
point, everything from creating a database and switching and using the database to creating your tables

7
00:00:22,680 --> 00:00:25,860
and defining a schema to then doing the basic CRUD operations.

8
00:00:25,860 --> 00:00:30,750
We've talked about creating, reading, updating and deleting data, all that stuff, all those commands

9
00:00:30,750 --> 00:00:34,890
that are associated with that, you'll be practicing them all at once in this section.

10
00:00:34,890 --> 00:00:36,720
And it's not just one giant video.

11
00:00:36,750 --> 00:00:43,020
I broke it up and to kind of logical, hopefully sections that make sense, you'll go through the create

12
00:00:43,020 --> 00:00:48,210
section, we'll create data together and then you'll do exercises with it and we'll be working with

13
00:00:48,210 --> 00:00:53,220
all the same data so we get all the same answers, which is really important that if you're following

14
00:00:53,220 --> 00:00:57,510
along and you're trying to update something that your update looks the same as mine.

15
00:00:57,750 --> 00:01:01,980
So the data that we'll be working with has to do with inventory management.

16
00:01:01,980 --> 00:01:07,470
It has to do with, let's say, a clothing company, an online clothing retailer, or maybe just our

17
00:01:07,470 --> 00:01:08,130
closet.

18
00:01:08,160 --> 00:01:10,950
We're just doing an inventory of my closet.

19
00:01:10,950 --> 00:01:16,260
I need to figure out what fits, what doesn't fit, what colors are there, what shirts have holes.

20
00:01:16,260 --> 00:01:20,790
I don't know what to give away to charity, what to burn in a pile, if that's what you do.

21
00:01:20,820 --> 00:01:24,030
All that stuff and we'll have different types of shirts.

22
00:01:24,510 --> 00:01:27,510
I got props again, short sleeves.

23
00:01:27,510 --> 00:01:29,970
We've got long sleeves.

24
00:01:30,060 --> 00:01:34,020
And the underappreciated and elusive three quarter length sleeve.

25
00:01:34,930 --> 00:01:40,810
Not to mention things like Hawaiian shirts or even Hawaiian shirts of different colors, too.

26
00:01:40,840 --> 00:01:42,130
But you didn't see that coming.

27
00:01:42,160 --> 00:01:42,760
Look at that.

28
00:01:42,760 --> 00:01:44,080
Another Hawaiian shirt.

29
00:01:44,440 --> 00:01:44,950
Yeah.

30
00:01:44,950 --> 00:01:46,510
I should probably stop this video, huh?

31
00:01:46,660 --> 00:01:49,260
So let's get on with the exercises coming up.

32
00:01:49,320 --> 00:01:51,640
Whole bunch of exercises around shirts.