WEBVTT

00:00.220 --> 00:01.510
A welcome back.

00:01.590 --> 00:03.320
So this section is a big one.

00:03.360 --> 00:04.980
Really exciting stuff.

00:05.040 --> 00:06.550
I mean exciting is relative.

00:06.600 --> 00:11.850
We are you know talking about databases but I do have a party here to celebrate.

00:12.600 --> 00:13.350
Yeah.

00:13.380 --> 00:15.590
So let's see what are we talking about here.

00:15.600 --> 00:22.980
This course has been out so far all about data in basically one table at a time kind of self-contained

00:23.160 --> 00:30.150
basic data and nothing all that exciting and nothing very complex no data that is related but of course

00:30.180 --> 00:33.540
in the real world all of our data or almost all of it is related.

00:33.630 --> 00:39.160
We don't have books on a web site without also having things like reviews and customers.

00:39.180 --> 00:41.860
And I don't know if shopping carts.

00:42.120 --> 00:44.640
We don't have cars on their own.

00:44.730 --> 00:49.650
We might have cars in our database but then we might have salesmen and dealerships and all the other

00:49.650 --> 00:50.820
things that go along with it.

00:51.090 --> 00:53.930
Or like an Instagram you don't have just photos.

00:53.940 --> 00:57.700
We have users photos comments tags likes followings relationships.

00:57.720 --> 00:59.880
All this stuff that's related.

00:59.880 --> 01:05.880
So this is a turning point where we well one of the touring turning points are we start to work with

01:05.880 --> 01:08.170
most pool tables that are connected.

01:08.250 --> 01:14.370
So we're going to talk about how data is related and then how to implement those relations using multiple

01:14.370 --> 01:20.400
tables and some of the buzzwords some of the big things we're talking about here are Joines foreign

01:20.400 --> 01:26.310
keys and primary keys which you've kind of seen before one to one one to many many to many relationships

01:26.610 --> 01:27.680
lots of stuff.

01:28.050 --> 01:34.290
But like I said this is the first of a couple sections focusing on related data and the other thing

01:34.440 --> 01:39.260
that you may want to celebrate is that we are done with our books done with the books data.

01:39.390 --> 01:44.660
You can totally go burn the books if you like throw them off a cliff.

01:44.670 --> 01:45.330
We're done with that.

01:45.330 --> 01:50.500
We're moving on to bigger and better things inching closer to our Instagram data at the end of the course.

01:50.700 --> 01:51.500
OK.

01:51.780 --> 01:55.310
Have fun don't forget your party hat because I didn't.