1
00:00:00,060 --> 00:00:02,520
So as I mentioned, we have a really quick activity now.

2
00:00:02,520 --> 00:00:07,740
And the point here is to get you thinking about data types and thinking in data types or in terms of

3
00:00:07,740 --> 00:00:08,520
data types.

4
00:00:09,000 --> 00:00:13,890
So what I'd like you to do is draw or write or just think about a tweet table.

5
00:00:13,890 --> 00:00:20,520
So modeling tweets, if you're not familiar with Twitter, that's going to be a tough one, I guess.

6
00:00:20,520 --> 00:00:26,820
But basically, there are three things I need you to at least three things that I want you to model.

7
00:00:26,940 --> 00:00:28,380
And these are the columns.

8
00:00:28,380 --> 00:00:29,370
So a username.

9
00:00:29,370 --> 00:00:34,740
So when someone tweets, let's say I tweet and I have I don't actually use Twitter, but if I had an

10
00:00:34,740 --> 00:00:40,170
account and I called it a coffee lover cult, I mean, that's just terrible.

11
00:00:40,170 --> 00:00:45,060
But if I did, it would need to be maximum 15 characters long.

12
00:00:45,060 --> 00:00:46,950
So how do you specify that?

13
00:00:46,950 --> 00:00:48,840
What data type is it then?

14
00:00:48,840 --> 00:00:50,190
The content of the tweet.

15
00:00:50,190 --> 00:00:54,900
So whatever the tweet is itself can't be more than 140 characters.

16
00:00:54,900 --> 00:01:01,260
And then the number of people that have favorited that tweet basically liked it or hearted it.

17
00:01:01,680 --> 00:01:03,600
So you don't have to draw it out.

18
00:01:03,600 --> 00:01:08,730
But if you want to draw it out in that tabular format and then fill in some fake data or even real tweet

19
00:01:08,730 --> 00:01:10,890
data that you find, go ahead and do that.

20
00:01:10,890 --> 00:01:15,930
But just think about what these data types are in terms of what we just learned.

21
00:01:15,930 --> 00:01:18,000
And there's really only two choices that we saw.

22
00:01:18,030 --> 00:01:20,190
So hopefully it's not too difficult.

23
00:01:20,970 --> 00:01:23,430
So we'll be right back with a solution.

24
00:01:27,350 --> 00:01:30,050
Okay, so let's start talking about the answer.

25
00:01:30,440 --> 00:01:36,500
So we had username, which was a maximum of 15 characters that would be a var char and you would put

26
00:01:36,500 --> 00:01:41,510
15 in in the parentheses to specify that it's no more than 15 characters.

27
00:01:42,590 --> 00:01:45,680
Then we have content of the tweet max of 140.

28
00:01:45,710 --> 00:01:46,700
It's very similar.

29
00:01:46,700 --> 00:01:51,650
It's also var char, it's text, but this time we restrict it at 140 characters.

30
00:01:52,310 --> 00:01:55,250
Then we have favorites, which is just a number.

31
00:01:55,250 --> 00:01:56,300
So we use INT.

32
00:01:56,870 --> 00:01:59,060
And then here's some mock data that I added.

33
00:01:59,060 --> 00:02:06,140
If you want to take a look, we have cool guy who tweeted my first tweet and I was one person who liked

34
00:02:06,140 --> 00:02:07,430
it or favorited it.

35
00:02:07,460 --> 00:02:11,840
Then we have Guitar Queen who tweeted, I love music, smiley face.

36
00:02:11,930 --> 00:02:12,790
How endearing.

37
00:02:12,800 --> 00:02:15,500
And we have ten favorites on that.

38
00:02:16,010 --> 00:02:22,220
And then Lonely Heart, this sad guy or gal who tweeted Still Looking for Love.

39
00:02:22,430 --> 00:02:26,150
And that has zero favorites because nobody wants to be depressed.

40
00:02:26,890 --> 00:02:27,520
All right.

41
00:02:27,520 --> 00:02:33,640
So next up, we're going to see how to take these data types and actually tell SQL or my SQL how to

42
00:02:33,670 --> 00:02:35,830
implement a table using those data types.