1
00:00:00,150 --> 00:00:05,310
Hey, welcome to another one of these videos at the beginning of a section where I just make a fool

2
00:00:05,310 --> 00:00:07,510
of myself, do something ridiculous.

3
00:00:07,530 --> 00:00:09,960
This time we're working with books.

4
00:00:09,960 --> 00:00:11,460
As you can see, it got more props.

5
00:00:11,460 --> 00:00:13,710
Just really love props on this course.

6
00:00:13,980 --> 00:00:15,090
And they're here for a reason.

7
00:00:15,090 --> 00:00:19,170
Because in this section we're getting introduced to our new data set.

8
00:00:19,260 --> 00:00:23,640
So for the next couple of sections, we're going to be working with one data set that I'm going to give

9
00:00:23,640 --> 00:00:23,940
you.

10
00:00:23,940 --> 00:00:25,500
And it has to do with books.

11
00:00:25,500 --> 00:00:30,180
And books make a particularly good data set because there's a lot of data to model.

12
00:00:30,180 --> 00:00:35,640
We've got things like titles, genre, the authors, how many authors.

13
00:00:35,640 --> 00:00:44,190
There are things like reviews, ratings, page count, release dates, tons of information for all different

14
00:00:44,190 --> 00:00:49,440
sizes of books, giant prop books, medium small books, all that fun stuff.

15
00:00:49,440 --> 00:00:56,460
And our back story here is a very weak back story is that we run a small online bookstore and we're

16
00:00:56,460 --> 00:00:58,770
being just slaughtered by Amazon.

17
00:00:58,770 --> 00:01:05,550
So we're fighting back the only way we know how, which is redoing our database inventory management

18
00:01:06,030 --> 00:01:06,480
system.

19
00:01:06,480 --> 00:01:07,530
So that's what we're going to do.

20
00:01:07,560 --> 00:01:12,690
We're going to fight back by redoing our database, and that will be what we start this section doing.

21
00:01:12,930 --> 00:01:17,580
But then once we have that data in the database, we're going to move on to learning a bunch of new

22
00:01:17,580 --> 00:01:18,270
commands.

23
00:01:18,270 --> 00:01:21,150
And those commands all are called string functions.

24
00:01:21,150 --> 00:01:23,730
So I'll explain what those mean in just a little bit.

25
00:01:23,730 --> 00:01:28,860
I don't want to make this video too long, but basically they expand our way of selecting data and working

26
00:01:28,860 --> 00:01:32,790
with text or with strings really important and kind of fun things that we can do.

27
00:01:32,790 --> 00:01:34,770
So we're going to go ahead and get started.

28
00:01:35,220 --> 00:01:41,820
Oh, before I forget this book here, so very important book this represents.

29
00:01:42,950 --> 00:01:45,170
The book of SQL knowledge.

30
00:01:46,700 --> 00:01:52,580
Yeah, I kind of regret this now, but this is the book of SQL knowledge you can ignore.

31
00:01:52,610 --> 00:01:56,550
There's a bunch of bugs in here that are attracted to the light can ignore that part.

32
00:01:56,570 --> 00:01:58,820
Our book of SQL knowledge doesn't have any bugs in it.

33
00:01:58,820 --> 00:01:59,990
We are bug free.

34
00:02:00,170 --> 00:02:02,540
Anyways, I think I should probably end it here.

35
00:02:02,570 --> 00:02:03,920
I'll see you in the next video.