1
00:00:00,630 --> 00:00:01,770
Hey, welcome.

2
00:00:02,370 --> 00:00:03,960
I'd like to show a couple of things.

3
00:00:03,960 --> 00:00:05,790
Here's a nice trick Blue can do.

4
00:00:05,850 --> 00:00:06,300
Look at that.

5
00:00:06,300 --> 00:00:08,910
She's like a like a T-Rex or something.

6
00:00:09,480 --> 00:00:10,410
Great job.

7
00:00:11,130 --> 00:00:12,120
That's the first thing.

8
00:00:12,120 --> 00:00:17,430
But the second important news that I have here is that this section is the one where we finally do our

9
00:00:17,430 --> 00:00:18,420
Instagram data.

10
00:00:18,540 --> 00:00:20,370
We're finally cloning Instagram.

11
00:00:20,370 --> 00:00:22,200
And that's actually an exaggeration.

12
00:00:22,200 --> 00:00:23,550
We're only cloning the database.

13
00:00:23,550 --> 00:00:29,730
And even then we're only doing like seven or eight tables, not 20 or 50 Instagram tables.

14
00:00:29,730 --> 00:00:36,000
But still we're doing the basics, the important stuff, photos and comments and users and likes and

15
00:00:36,000 --> 00:00:42,150
follow follower, following relationships, hashtags, all that fun stuff, all the relationships between

16
00:00:42,150 --> 00:00:43,830
them and then all those joints.

17
00:00:43,830 --> 00:00:45,720
There's a lot of opportunities there.

18
00:00:45,720 --> 00:00:51,600
So this is sort of acting as a bit of a nightcap on this course.

19
00:00:51,600 --> 00:00:56,310
It's not the end, but this is the last kind of data set that we're working with.

20
00:00:56,310 --> 00:01:01,920
And then I'm going to show you after this how to build a web app with my SQL.

21
00:01:01,920 --> 00:01:04,500
So that's also coming up, which hopefully is exciting.

22
00:01:04,500 --> 00:01:10,740
But this section, like I said, is all about Instagram data, really exciting stuff, going to basically

23
00:01:10,740 --> 00:01:16,530
build the schema and then the next section is going to be a bunch of challenges and problems with it.

24
00:01:16,560 --> 00:01:18,270
Okay, let's get started.