1
00:00:00,240 --> 00:00:01,380
Hey, welcome back.

2
00:00:01,410 --> 00:00:03,300
So this section is a big one.

3
00:00:03,300 --> 00:00:04,970
Really exciting stuff.

4
00:00:04,980 --> 00:00:06,540
I mean, exciting is relative.

5
00:00:06,540 --> 00:00:11,460
We are talking about databases, but I do have a party hat here to celebrate.

6
00:00:12,570 --> 00:00:13,290
Yeah.

7
00:00:13,350 --> 00:00:14,400
So let's see.

8
00:00:14,400 --> 00:00:15,570
What are we talking about here?

9
00:00:15,570 --> 00:00:21,540
This course has been so far all about data in basically one table at a time.

10
00:00:21,570 --> 00:00:28,260
Kind of self contained, basic data, Nothing all that exciting and nothing very complex, no data that

11
00:00:28,260 --> 00:00:29,220
is related.

12
00:00:29,220 --> 00:00:33,420
But of course, in the real world, all of our data are almost all of it is related.

13
00:00:33,420 --> 00:00:40,200
We don't have books on a website without also having things like reviews and customers and, I don't

14
00:00:40,200 --> 00:00:41,430
know, shopping carts.

15
00:00:42,000 --> 00:00:44,580
We don't have cars on their own.

16
00:00:44,580 --> 00:00:49,530
We might have cars in our database, but then we might have salesmen and dealerships and all of the

17
00:00:49,530 --> 00:00:50,850
other things that go along with it.

18
00:00:50,940 --> 00:00:53,910
Or like on Instagram, you don't have just photos.

19
00:00:53,910 --> 00:00:59,160
We have users, photos, comments, tags, likes, followings, relationships, all this stuff that's

20
00:00:59,160 --> 00:00:59,730
related.

21
00:00:59,730 --> 00:01:06,480
So this is a turning point where we well, one of the turning points where we start to work with multiple

22
00:01:06,480 --> 00:01:07,950
tables that are connected.

23
00:01:08,100 --> 00:01:14,400
So we're going to talk about how data is related and then how to implement those relations using multiple

24
00:01:14,400 --> 00:01:20,430
tables and some of the buzzwords, some of the big things we're talking about here are joints, foreign

25
00:01:20,430 --> 00:01:26,490
keys and primary keys, which you've kind of seen before, 1 to 1, one to many, many to many relationships,

26
00:01:26,520 --> 00:01:27,600
lots of stuff.

27
00:01:27,990 --> 00:01:32,700
But like I said, this is the first of a couple sections focusing on related data.

28
00:01:32,970 --> 00:01:38,580
And the other thing that you may want to celebrate is that we are done with our books down at the books

29
00:01:38,580 --> 00:01:39,210
data.

30
00:01:39,210 --> 00:01:44,520
You can totally go burn the books if you'd like, throw them off a cliff.

31
00:01:44,520 --> 00:01:45,330
We're done with that.

32
00:01:45,330 --> 00:01:49,920
We're moving on to bigger and better things, inching closer to our Instagram data at the end of the

33
00:01:49,920 --> 00:01:50,490
course.

34
00:01:50,700 --> 00:01:52,530
Okay, have fun.

35
00:01:52,530 --> 00:01:55,530
And don't forget your party hat, because I didn't.

36
00:01:56,870 --> 00:01:57,350
Yeah.