WEBVTT

00:00.680 --> 00:03.920
Hey welcome I'd like to show a couple of things.

00:03.920 --> 00:06.280
Here's a nice trick you can do that.

00:06.290 --> 00:09.470
She's like a good T-Rex or something.

00:09.530 --> 00:10.690
Great job.

00:11.240 --> 00:12.090
That's the first thing.

00:12.170 --> 00:17.360
But the second important news that I have here is that this section is the one where we finally do our

00:17.360 --> 00:20.250
Instagram data or Finally cloning Instagram.

00:20.570 --> 00:23.630
And that's actually an exaggeration we're only cloning the database.

00:23.630 --> 00:30.770
And even then we're only doing like 7 or 8 tables not you know 20 or 50 Instagram tables but still we're

00:30.770 --> 00:37.390
doing the basics the important stuff photos and comments and users and likes and follow you know follower

00:37.400 --> 00:42.890
following relationships hashtags all that fun stuff all the relationships between them and then all

00:42.890 --> 00:43.890
those joints.

00:43.910 --> 00:45.690
There's a lot of opportunities there.

00:45.890 --> 00:50.930
So this is sort of acting as a bit of a endcap on this.

00:50.940 --> 00:53.000
Of course it's not the end.

00:53.170 --> 00:58.700
But this is the last kind of data set that we're working with and then I'm going to show you after this

00:59.300 --> 01:02.090
how to build a web app with my Eskew well.

01:02.090 --> 01:07.820
So that's also coming up which hopefully is exciting but this section like I said is all about Instagram

01:07.820 --> 01:08.280
data.

01:08.360 --> 01:09.980
Really exciting stuff.

01:10.000 --> 01:15.950
You basically build the schema and then the next section is going to be a bunch of challenges and problems

01:15.950 --> 01:16.430
with it.

01:16.660 --> 01:18.280
OK let's get started.