1
00:00:00,390 --> 00:00:02,080
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:09,960
I mean, I guess you could say that for every section, hopefully, but the structure is pretty different

4
00:00:09,960 --> 00:00:12,630
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:32,070
that are associated with that.

10
00:00:32,070 --> 00:00:34,890
You'll be practicing them all at once in this section.

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

12
00:00:36,750 --> 00:00:40,920
I broke it up into kind of logical, hopefully sections that make sense.

13
00:00:40,920 --> 00:00:46,740
You'll go through the create section, we'll create data together and then you'll do exercises with

14
00:00:46,740 --> 00:00:51,870
it and we'll be working with all the same data so we get all the same answers, which is really important

15
00:00:51,870 --> 00:00:56,850
that if you're following along and you're trying to update something, that your update looks the same

16
00:00:56,850 --> 00:00:57,510
as mine.

17
00:00:57,720 --> 00:01:03,060
So the data that we'll be working with has to do with inventory management, has to do with, let's

18
00:01:03,060 --> 00:01:08,130
say, a clothing company, an online clothing retailer, or maybe just our closet.

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

20
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.

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

22
00:01:21,270 --> 00:01:21,780
stuff.

23
00:01:21,780 --> 00:01:24,000
And we'll have different types of shirts.

24
00:01:24,510 --> 00:01:32,970
I got props again, short sleeves, we've got long sleeves and the underappreciated and elusive three

25
00:01:32,970 --> 00:01:34,030
quarter length sleeve.

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

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

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

29
00:01:42,760 --> 00:01:44,050
Another Hawaiian shirt.

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

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

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

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