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,950
Really exciting stuff.

4
00:00:04,950 --> 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 here to celebrate.

6
00:00:12,570 --> 00:00:14,400
Yeah, so let's see.

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

8
00:00:15,570 --> 00:00:23,100
This course has been so far all about data in basically one table at a time, kind of self contained,

9
00:00:23,100 --> 00:00:23,850
basic data.

10
00:00:23,850 --> 00:00:29,220
Nothing all that exciting and nothing very complex, no data that is related.

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

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

13
00:00:40,380 --> 00:00:41,430
shopping carts.

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

15
00:00:44,580 --> 00:00:49,680
We might have cars in our database, but then we might have salesmen and dealerships and all the other

16
00:00:49,680 --> 00:00:50,850
things that go along with it.

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

18
00:00:53,910 --> 00:00:59,730
We have users photos, comments, tags, likes followings, relationships, all this stuff that's related.

19
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

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

21
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

22
00:01:14,400 --> 00:01:16,530
tables and some of the buzzwords.

23
00:01:16,530 --> 00:01:22,140
Some of the big things we're talking about here are joints, foreign keys and primary keys, which you've

24
00:01:22,140 --> 00:01:23,250
kind of seen before.

25
00:01:23,250 --> 00:01:27,600
1 to 1, one to many, many to many relationships, lots of stuff.

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

27
00:01:32,970 --> 00:01:37,860
And the other thing that you may want to celebrate is that we are done with our books.

28
00:01:37,860 --> 00:01:44,520
Down with the books data, you can totally go burn the books if you'd like, throw them off a cliff.

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

30
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

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

32
00:01:51,720 --> 00:01:52,510
Have fun.

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

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