1
00:00:00,120 --> 00:00:00,630
All right.

2
00:00:00,630 --> 00:00:04,460
So the next very important thing we have to do, of course, is install MySQL.

3
00:00:04,770 --> 00:00:12,630
And if you remember, I mentioned that one of the main reasons I'm updating this course is because originally

4
00:00:12,630 --> 00:00:19,020
I used an easy tool called Cloud nine when I recorded the course that made it instantaneous for anybody

5
00:00:19,020 --> 00:00:20,700
to have MySQL up and running.

6
00:00:20,700 --> 00:00:23,450
It was all in the browser, but that tool went away.

7
00:00:23,460 --> 00:00:29,430
Now there's a reason that I opted to use that tool in the past, which is that installing MySQL can

8
00:00:29,430 --> 00:00:31,140
sometimes be a little tedious.

9
00:00:31,140 --> 00:00:36,240
So this section might have some of the longest individual videos, like 15 to 20 minute videos just

10
00:00:36,240 --> 00:00:38,040
to install it on Windows or on a mac.

11
00:00:38,040 --> 00:00:38,850
So hang in there.

12
00:00:38,850 --> 00:00:42,240
It's not too bad, it's just a lot of menus and configuration.

13
00:00:42,450 --> 00:00:45,990
So this video is not going to show you how to install my SQL.

14
00:00:45,990 --> 00:00:48,930
Instead, what I want to show you is our end goal.

15
00:00:49,380 --> 00:00:51,690
It's important that you understand what we're doing here.

16
00:00:51,690 --> 00:00:54,960
So I have my Mac side of my machine right here.

17
00:00:54,960 --> 00:00:56,130
This is all Mac stuff.

18
00:00:56,130 --> 00:00:57,630
And this over here is windows.

19
00:00:57,630 --> 00:01:02,550
It doesn't look all that different, but you can see the Windows toolbar down there and I have the tools

20
00:01:02,550 --> 00:01:07,410
will be using are installed on both so you can see them simultaneously in the course.

21
00:01:07,410 --> 00:01:08,340
I'm recording on a mac.

22
00:01:08,340 --> 00:01:13,680
So you'll see this, you'll see this, you won't see this Windows stuff as much, but it looks very

23
00:01:13,680 --> 00:01:15,000
similar as you can tell.

24
00:01:15,360 --> 00:01:21,270
So what we're going to do is install my SQL Server, my SQL Server, the database management relational

25
00:01:21,540 --> 00:01:23,670
relational database management system.

26
00:01:24,030 --> 00:01:27,630
We'll be running and then we can interact with it in different ways.

27
00:01:27,630 --> 00:01:30,900
One way is through the terminal, through a command line.

28
00:01:30,900 --> 00:01:32,340
So it's text based.

29
00:01:32,340 --> 00:01:36,660
I can do things like select nine times nine.

30
00:01:36,660 --> 00:01:42,840
Now this is a stupid use of my SQL using it as a calculator, but I get a result and this is done by

31
00:01:42,840 --> 00:01:48,570
typing it into a prompt and hitting enter and we will use this a lot in the course because it's instantaneous.

32
00:01:48,660 --> 00:01:49,830
I can type something.

33
00:01:49,830 --> 00:01:53,550
This will give me an error, but I can type something and then see a result.

34
00:01:53,850 --> 00:01:59,520
But then we'll also be using a tool called my SQL workbench, which is this right here.

35
00:01:59,730 --> 00:02:01,110
This is what it looks like on a mac.

36
00:02:01,110 --> 00:02:07,500
At least this allows me to write my queries in files, save them in files, and then execute them when

37
00:02:07,500 --> 00:02:08,190
I'm ready.

38
00:02:08,310 --> 00:02:10,620
This doesn't really allow me to do that.

39
00:02:10,620 --> 00:02:12,900
I type my code in here and I hit enter.

40
00:02:12,900 --> 00:02:14,580
So it just says an example.

41
00:02:14,940 --> 00:02:19,320
Here's a long query that I have will learn what this means throughout the course.

42
00:02:19,320 --> 00:02:21,630
When I run this, I get a result here.

43
00:02:21,630 --> 00:02:28,170
This is employee information on salaries department average by average salary average by department

44
00:02:28,170 --> 00:02:33,540
minimum maximum the rank of each employee by their salary within their department overall at the company.

45
00:02:33,720 --> 00:02:41,790
Anyway, this query I just copied and pasted into the terminal, but I can also run the exact same thing.

46
00:02:41,790 --> 00:02:45,210
This is what it looks like from within the workbench.

47
00:02:46,460 --> 00:02:48,520
So you'll see me do both in the course.

48
00:02:48,530 --> 00:02:49,850
There's no difference.

49
00:02:49,850 --> 00:02:54,260
I mean, there's a difference in the fact that I'm clicking a button versus over here typing it in or

50
00:02:54,260 --> 00:02:57,620
pasting it in, but the end result is exactly the same.

51
00:02:57,620 --> 00:02:59,720
It's just displayed slightly differently here.

52
00:02:59,720 --> 00:03:01,340
It's displayed in a terminal window.

53
00:03:01,490 --> 00:03:02,720
But look at the first row.

54
00:03:02,720 --> 00:03:05,750
It says 17 customer service, 61,000.

55
00:03:06,230 --> 00:03:07,880
Look at the first row I got here.

56
00:03:07,880 --> 00:03:13,190
17 And then it's hard to see the full thing, but customer service 61,000.

57
00:03:13,190 --> 00:03:19,550
So it's displayed graphically in this application instead of being displayed as part of the command

58
00:03:19,550 --> 00:03:20,330
line output.

59
00:03:20,330 --> 00:03:23,930
But it's the same information and that's really important that you understand that.

60
00:03:23,930 --> 00:03:27,860
So you don't get too hung up on what I'm using in one video versus the other.

61
00:03:27,860 --> 00:03:29,510
It's going to work either way.

62
00:03:29,510 --> 00:03:34,550
If you prefer to do everything in a file, you can do it in a file and here you can keep making new

63
00:03:34,550 --> 00:03:34,970
files.

64
00:03:34,970 --> 00:03:39,080
I'll show you how this works when we install it, but I can make a new file here.

65
00:03:39,080 --> 00:03:40,070
Put some code in there.

66
00:03:40,070 --> 00:03:45,620
I can save it, give it a name, and then when I'm ready, execute it and I get my result.

67
00:03:45,710 --> 00:03:51,680
Or if you prefer, you can just have the terminal open and run your code in here, do whatever you want,

68
00:03:51,680 --> 00:03:53,630
and get a result on the command line.

69
00:03:53,870 --> 00:03:58,610
So I'm going to be doing both and at some point you'll probably need to have both open.

70
00:03:58,610 --> 00:04:03,440
But it's important again that you understand behind the scenes they're talking to the same server,

71
00:04:03,440 --> 00:04:05,510
they're talking to the same data.

72
00:04:05,510 --> 00:04:08,090
It's just a different client, a different interface.

73
00:04:08,090 --> 00:04:16,010
And then here it is on Windows, so I can do something like select nine times nine again and I get my

74
00:04:16,010 --> 00:04:23,960
result 81 or I can do it over here in the workbench, select nine times nine and I'll click the lightning

75
00:04:23,960 --> 00:04:26,510
bolt and I see 81.

76
00:04:26,990 --> 00:04:27,380
All right.

77
00:04:27,380 --> 00:04:30,710
So it looks pretty much the same, a little bit different.

78
00:04:30,710 --> 00:04:35,240
I've increased the font size here because I'm using this in the videos, but at the end of the day,

79
00:04:35,240 --> 00:04:39,890
it's pretty much identical between Windows and Mac, and that's pretty much it for this video.

80
00:04:39,950 --> 00:04:44,780
I just wanted to preface the actual installation by showing you what we're installing because it could

81
00:04:44,780 --> 00:04:45,770
be confusing.

82
00:04:45,770 --> 00:04:50,600
You're going to install a server, you're going to run my SQL or interact with it from the command line,

83
00:04:50,600 --> 00:04:54,530
but you're also going to interact with it from this tool called my SQL workbench.

84
00:04:54,560 --> 00:04:59,360
It could be a lot if we didn't understand what we were doing before we actually installed it all.

85
00:04:59,660 --> 00:05:06,500
Okay, so following this video, we've got a mac install and a Windows install pick the correct platform.

86
00:05:06,500 --> 00:05:11,690
Of course, unless you really are a masochist and you want to watch both for no reason, but pick the

87
00:05:11,690 --> 00:05:15,260
correct platform, go through the installation, and then I'll see you on the other side.

88
00:05:15,440 --> 00:05:16,310
Good luck.

89
00:05:16,640 --> 00:05:17,390
It's not too bad.

