Hey, welcome to another one of these videos at the beginning of a section where I just make a fool
of myself, do something ridiculous.
This time we're working with books.
As you can see, it got more props.
Just really love props on this course.
And they're here for a reason because in this section we're getting introduced to our new data set.
So for the next couple of sections, we're going to be working with one data set that I'm going to give
you.
And it has to do with books.
And books make a particularly good data set because there's a lot of data to model.
We've got things like titles, genre, the authors, how many authors there are things like reviews,
ratings, page count, release dates, tons of information for all different sizes of books, giant
prop books, medium small books, all that fun stuff.
And our back story here is a very weak back story, is that we run a small online bookstore and we're
being just slaughtered by Amazon.
So we're fighting back the only way we know how, which is redoing our database inventory management
system.
So that's what we're going to do.
We're going to fight back by redoing our database, and that will be what we start this section doing.
But then once we have that data in the database, we're going to move on to learning a bunch of new
commands.
And those commands all are called string functions.
So I'll explain what those mean in just a little bit.
I don't want to make this video too long, but basically they expand our way of selecting data and working
with text or with strings, really important and kind of fun things that we can do.
So we're going to go ahead and get started.
Oh, before I forget this book here, so very important book this represents.
The Book of SQL Knowledge.
Yeah, I kind of regret this now, but this is the book of SQL Knowledge you can ignore.
There's a bunch of bugs in here that are attracted to the light.
Can ignore that part.
Our book of SQL Knowledge doesn't have any bugs in it.
We are bug free.
Anyways, I think I should probably end it here.
I'll see you in the next video.