WEBVTT

00:00.390 --> 00:02.280
Hey welcome to the next section.

00:02.340 --> 00:05.390
So this section is a bit different than everything else.

00:05.430 --> 00:08.150
I mean I guess you could say that for every section hopefully.

00:08.220 --> 00:12.610
But the structure is pretty different because it's all challenges it's all exercises.

00:12.810 --> 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

00:16.830 --> 00:17.280
point.

00:17.370 --> 00:22.730
Everything from creating a database and switching and using the database to creating your tables and

00:22.730 --> 00:27.840
defining schema to then doing that basic Kroto operations we've talked about creating reading updating

00:27.870 --> 00:32.940
and deleting data all that stuff all those commands that are associated with that you'll be practicing

00:32.940 --> 00:34.040
them all at once.

00:34.050 --> 00:40.020
In this section and it's not just one giant video I broke it up into kind of logical hopefully sections

00:40.020 --> 00:40.990
that make sense.

00:41.040 --> 00:46.470
They'll go through you know the Create section will create data together and then you'll do exercises

00:46.470 --> 00:49.130
with it and we'll be working with all the same data.

00:49.170 --> 00:53.910
So we get all the same answers which is really important that you know if you're following along and

00:53.910 --> 00:57.520
you're trying to update something that your update looks the same as mine.

00:57.840 --> 01:03.390
So the data that we'll be working with has to do with inventory management has to do with let's say

01:03.630 --> 01:08.310
a clothing company an online clothing retailer or maybe just our closet.

01:08.310 --> 01:14.430
We're just doing a inventory of my closet I need to figure out what fits what doesn't fit what colors

01:14.430 --> 01:16.230
are there what shirts have holes.

01:16.230 --> 01:20.730
I didn't know what to give away to charity what to burn in a pile if that's what you do.

01:20.940 --> 01:21.960
All that stuff.

01:21.960 --> 01:24.040
And you know we all have different types of shirts.

01:24.570 --> 01:25.800
I got props again.

01:26.160 --> 01:33.450
You know short sleeves we've got long sleeves and the under appreciated and elusive three quarter length

01:33.450 --> 01:34.810
sleeve.

01:34.940 --> 01:41.010
Not to mention things like you know Hawaiian shirts or even Hawaiian shirts of different colors to he

01:41.010 --> 01:42.650
didn't see that coming like that.

01:42.740 --> 01:44.200
Another Hawaiian shirt.

01:44.570 --> 01:45.030
Yeah.

01:45.030 --> 01:46.630
Should probably stop this video of him.

01:46.850 --> 01:48.590
So let's get on with the exercises.

01:48.620 --> 01:51.410
Coming up a whole bunch of exercises around Schertz.