1
00:00:00,240 --> 00:00:02,490
Hey, welcome to the next section here.

2
00:00:02,520 --> 00:00:05,180
This one we're continuing with our Instagram data.

3
00:00:05,190 --> 00:00:07,080
Let's see if Blue will do her trick again.

4
00:00:08,390 --> 00:00:08,960
Blue.

5
00:00:10,120 --> 00:00:10,870
Can you get it?

6
00:00:11,740 --> 00:00:14,380
Who is my adorable little kitty?

7
00:00:14,830 --> 00:00:16,540
You can stand up like a human.

8
00:00:17,560 --> 00:00:20,710
She's come so far, just like you have come so far.

9
00:00:21,220 --> 00:00:21,910
Yeah.

10
00:00:21,910 --> 00:00:23,890
So we're working with Instagram data.

11
00:00:23,890 --> 00:00:25,180
We set up the schema.

12
00:00:25,210 --> 00:00:27,850
Now, all we have left is to do stuff with it.

13
00:00:27,850 --> 00:00:34,450
So the way this section works is rather than me giving you a bunch of tables, showing you here's the

14
00:00:34,450 --> 00:00:37,140
result I want, we're going to do it a bit differently.

15
00:00:37,150 --> 00:00:43,900
I'm going to ask you more of a real world question, like, Hey, we're doing a sweepstakes, or how

16
00:00:43,900 --> 00:00:49,780
about we're doing a campaign email campaign to email all of our inactive users and send them a reminder

17
00:00:49,780 --> 00:00:50,770
that they should post.

18
00:00:51,040 --> 00:00:54,250
So we need you to get all the inactive user's email addresses.

19
00:00:54,250 --> 00:01:01,270
So something like that where it's kind of in real world terms, not in the terms of a database like

20
00:01:01,270 --> 00:01:05,110
select all users where blah, blah blah, but you'll have to translate it.

21
00:01:05,110 --> 00:01:09,940
So we'll do things like that or we'll do things like, Hey, we have a brand who's really pressuring

22
00:01:09,940 --> 00:01:14,590
us to figure out what hashtags are the most useful or what to generate, generating the most likes.

23
00:01:14,590 --> 00:01:17,740
And they want to know what three hashtags they should use.

24
00:01:17,740 --> 00:01:21,430
So then you'll have to go right the query to find that answer.

25
00:01:21,430 --> 00:01:22,510
What are the best hashtags?

26
00:01:22,510 --> 00:01:23,200
How do you know?

27
00:01:23,350 --> 00:01:25,270
So hopefully that's exciting.

28
00:01:25,670 --> 00:01:31,840
I'm trying to make it kind of a nice ramp off to the real world just for the data section.

29
00:01:32,050 --> 00:01:36,250
And then after this, like I said, we have the web app portion of the course.

30
00:01:36,730 --> 00:01:40,720
So lots of exercises, all exercises and solutions in this section.

31
00:01:41,050 --> 00:01:41,770
Goodbye.