Hey, everyone.
Welcome to the course.
Really important thing to say up front.
I just updated this course or it's less of an update, more of an overhaul or complete renovation,
demolishing and rebuilding of the course.
And there's a couple of reasons that I did this.
The first is that when I made this course originally, I made a pretty big choice that came back to
be a bit of a problem.
Installing my SQL can be a pain, so I decided to use a platform, an ID in the browser called Cloud
nine, which made it incredibly easy.
It was like a single button click essentially to have my SQL up and running.
It didn't matter if you were on a mac or a Windows machine or something else, but that service was
subsequently bought by Amazon, shut down, or at least substantially changed.
And we've been scrambling to come up with workarounds and that was something I used throughout the entire
course hundreds of videos, 15, 20 hours of content all linked to this Cloud nine thing.
So the good news is, in this completely updated version of the course, all cloud nine stuff is gone.
Everything is done locally on your machine, whether it's a mac machine, windows or something else.
We install it locally.
We even install this tool called the workbench MySQL workbench, and we can run everything without having
to sign up for some service without having to use the browser all on our machine.
Additionally, since I first did this course a couple of years ago, my SQL 8.0 has been released.
The original was 5.7, which yes, I know is confusing.
My SQL went from 5.7 to 8.0, but it's just the naming of it.
This course has now been redone using eight point X, so not a lot has changed for the basic syntax,
but there are some new features that I've included.
So if you're brand new, you're just taking this course for the first time.
You just enrolled or you're watching a preview.
You really don't need to do anything different.
Just know that the course is redone and the update is live.
Now, if you are a returning student, somebody who already went through the course and did everything
with the previous version, don't go through this course in the beginning and treat it as a brand new
course, because a lot of the content is exactly the same.
The videos are all new, everything has been rerecorded, but most of that has been to cut out Cloud
nine.
So if you already know how to do things like select and insert and create tables and work with foreign
keys and all of that, I wouldn't waste your time going over that content again.
But there are some new topics that I've included that you definitely want to check out or I would recommend
you check out.
That includes things like Check constraints, Alter Table with roll up, definitely window functions,
SQL modes, and then making sure that you are running eight point X, You can check out the installation
instructions at the beginning and work with the SQL workbench if you want.
But I assume that most of you who are watching this video are just starting the course.
Do you really care that it's been updated?
Do you need to know what's new?
Probably not.
It's all here now, but it is good, I guess, to know the story of this course and how it's changed
over the years.
And with that out of the way, let's go ahead and get started.
Welcome.
I hope you enjoy the new content.