1
00:00:00,090 --> 00:00:00,600
Hey, everyone.

2
00:00:00,600 --> 00:00:01,710
Welcome to the course.

3
00:00:01,950 --> 00:00:03,480
Really important thing to say up front.

4
00:00:03,480 --> 00:00:09,930
I just updated this course or it's less of an update, more of an overhaul or complete renovation,

5
00:00:09,930 --> 00:00:12,410
demolishing and rebuilding of the course.

6
00:00:12,420 --> 00:00:14,520
And there's a couple of reasons that I did this.

7
00:00:14,550 --> 00:00:21,990
The first is that when I made this course originally, I made a pretty big choice that came back to

8
00:00:21,990 --> 00:00:24,220
be a bit of a problem.

9
00:00:24,240 --> 00:00:31,590
Installing my SQL can be a pain, so I decided to use a platform, an ID in the browser called Cloud

10
00:00:31,590 --> 00:00:34,050
nine, which made it incredibly easy.

11
00:00:34,050 --> 00:00:38,100
It was like a single button click essentially to have my SQL up and running.

12
00:00:38,100 --> 00:00:43,350
It didn't matter if you were on a mac or a Windows machine or something else, but that service was

13
00:00:43,350 --> 00:00:48,360
subsequently bought by Amazon, shut down, or at least substantially changed.

14
00:00:48,360 --> 00:00:53,490
And we've been scrambling to come up with workarounds and that was something I used throughout the entire

15
00:00:53,490 --> 00:01:00,480
course hundreds of videos, 15, 20 hours of content all linked to this Cloud nine thing.

16
00:01:00,480 --> 00:01:05,850
So the good news is, in this completely updated version of the course, all cloud nine stuff is gone.

17
00:01:05,850 --> 00:01:10,200
Everything is done locally on your machine, whether it's a mac machine, windows or something else.

18
00:01:10,200 --> 00:01:11,610
We install it locally.

19
00:01:11,610 --> 00:01:17,610
We even install this tool called the workbench MySQL workbench, and we can run everything without having

20
00:01:17,610 --> 00:01:21,660
to sign up for some service without having to use the browser all on our machine.

21
00:01:21,690 --> 00:01:27,840
Additionally, since I first did this course a couple of years ago, my SQL 8.0 has been released.

22
00:01:27,840 --> 00:01:32,190
The original was 5.7, which yes, I know is confusing.

23
00:01:32,190 --> 00:01:37,500
My SQL went from 5.7 to 8.0, but it's just the naming of it.

24
00:01:37,500 --> 00:01:43,770
This course has now been redone using eight point X, so not a lot has changed for the basic syntax,

25
00:01:43,770 --> 00:01:45,990
but there are some new features that I've included.

26
00:01:46,200 --> 00:01:49,860
So if you're brand new, you're just taking this course for the first time.

27
00:01:49,860 --> 00:01:51,930
You just enrolled or you're watching a preview.

28
00:01:51,960 --> 00:01:53,760
You really don't need to do anything different.

29
00:01:53,760 --> 00:01:57,660
Just know that the course is redone and the update is live.

30
00:01:57,660 --> 00:02:02,820
Now, if you are a returning student, somebody who already went through the course and did everything

31
00:02:02,820 --> 00:02:08,280
with the previous version, don't go through this course in the beginning and treat it as a brand new

32
00:02:08,280 --> 00:02:11,640
course, because a lot of the content is exactly the same.

33
00:02:11,640 --> 00:02:17,130
The videos are all new, everything has been rerecorded, but most of that has been to cut out Cloud

34
00:02:17,130 --> 00:02:17,700
nine.

35
00:02:17,700 --> 00:02:22,380
So if you already know how to do things like select and insert and create tables and work with foreign

36
00:02:22,380 --> 00:02:26,460
keys and all of that, I wouldn't waste your time going over that content again.

37
00:02:26,460 --> 00:02:31,620
But there are some new topics that I've included that you definitely want to check out or I would recommend

38
00:02:31,620 --> 00:02:32,340
you check out.

39
00:02:32,340 --> 00:02:38,550
That includes things like Check constraints, Alter Table with roll up, definitely window functions,

40
00:02:38,550 --> 00:02:44,400
SQL modes, and then making sure that you are running eight point X, You can check out the installation

41
00:02:44,400 --> 00:02:49,590
instructions at the beginning and work with the SQL workbench if you want.

42
00:02:49,590 --> 00:02:53,430
But I assume that most of you who are watching this video are just starting the course.

43
00:02:53,430 --> 00:02:55,200
Do you really care that it's been updated?

44
00:02:55,200 --> 00:02:56,490
Do you need to know what's new?

45
00:02:56,520 --> 00:02:57,590
Probably not.

46
00:02:57,600 --> 00:03:02,790
It's all here now, but it is good, I guess, to know the story of this course and how it's changed

47
00:03:02,790 --> 00:03:03,660
over the years.

48
00:03:03,660 --> 00:03:06,450
And with that out of the way, let's go ahead and get started.

49
00:03:06,450 --> 00:03:07,110
Welcome.

50
00:03:07,110 --> 00:03:08,520
I hope you enjoy the new content.