WEBVTT

1
00:00:00.300 --> 00:00:01.840
All right, here we go.

2
00:00:01.840 --> 00:00:03.190
We're gonna get started here,

3
00:00:03.190 --> 00:00:06.070
downloading some of the software that
we're gonna be using in this course.

4
00:00:06.070 --> 00:00:08.910
The first thing that we need
to download is a Text Editor.

5
00:00:08.910 --> 00:00:12.300
So, Sublime Text,
which we highly recommend you use,

6
00:00:12.300 --> 00:00:17.920
is a really great text editor for
engineers, programmers of any kind.

7
00:00:17.920 --> 00:00:21.160
So, they support all different
kinds of languages including SQL,

8
00:00:21.160 --> 00:00:22.540
which we will be using.

9
00:00:22.540 --> 00:00:27.160
And yeah, so it's a free text editor and
David's gonna talk

10
00:00:27.160 --> 00:00:30.630
a little bit about some of the reason why
it's great, some of the features it has.

11
00:00:30.630 --> 00:00:34.000
>> Yeah, so when we say Text Editor,
it's basically like Microsoft Word, but

12
00:00:34.000 --> 00:00:34.910
for coding.

13
00:00:34.910 --> 00:00:39.460
One of the two main features that we like
about it, is that it color codes your code

14
00:00:39.460 --> 00:00:43.670
so that you can organize and easily
visually see what your code is saying.

15
00:00:43.670 --> 00:00:46.010
Because it'll break it up it into
different colors for different elements.

16
00:00:46.010 --> 00:00:48.020
The second thing we like about it is that,

17
00:00:48.020 --> 00:00:52.110
you wanna keep all your queries
that you make in a single location.

18
00:00:52.110 --> 00:00:55.050
Or single folder that has all
these different SQL files.

19
00:00:55.050 --> 00:00:58.550
So that you can come back to it and
copy and paste the query and run it again.

20
00:00:58.550 --> 00:01:00.560
Instead of having to rewrite
the whole query every time

21
00:01:00.560 --> 00:01:02.090
you want to run the query.

22
00:01:02.090 --> 00:01:02.980
So yeah, we recommend this.

23
00:01:02.980 --> 00:01:05.410
You can go to sublimetext.com it's free.

24
00:01:05.410 --> 00:01:06.610
>> Yeah, so it's free.

25
00:01:06.610 --> 00:01:09.290
And if you come to sublimetext.com,
you scroll down here,

26
00:01:09.290 --> 00:01:14.240
it will have the version and the operating
system that it detects from your browser.

27
00:01:14.240 --> 00:01:17.480
And so
when you hover over the download button,

28
00:01:17.480 --> 00:01:20.080
it says Sublime Text may be downloaded and
evaluated for free,

29
00:01:20.080 --> 00:01:22.520
however a license must be purchased for
continued use.

30
00:01:22.520 --> 00:01:25.790
But, there's no enforce time for the
evaluation, therefore you can use it for

31
00:01:25.790 --> 00:01:28.450
free as long as you'd like.

32
00:01:28.450 --> 00:01:32.390
And if you go over to the download page
here, you see that it's supported by

33
00:01:32.390 --> 00:01:38.790
Windows and Linux as well as Mac.

34
00:01:38.790 --> 00:01:43.640
So if you click here to download,
it will download right here.

35
00:01:43.640 --> 00:01:46.530
And then we'll just click
there to open it up.

36
00:01:46.530 --> 00:01:50.180
>> Yeah.
You can install it on your own.

37
00:01:50.180 --> 00:01:50.720
>> Blah, blah, blah.

38
00:01:50.720 --> 00:01:51.630
>> You already have it installed.

39
00:01:51.630 --> 00:01:56.345
>> Yeah, we have it installed, I'm just
gonna open up a blank coding page here.

40
00:01:56.345 --> 00:01:58.335
And so you can type in.

41
00:01:58.335 --> 00:02:00.685
Text will just be white.

42
00:02:00.685 --> 00:02:06.480
We had some,
that's gonna be some SQL commands.

43
00:02:06.480 --> 00:02:08.005
And so, you see that that turns red.

44
00:02:08.005 --> 00:02:09.645
We'll talk more about that later.

45
00:02:09.645 --> 00:02:11.175
But yeah, so, you're all set up.

46
00:02:11.175 --> 00:02:14.195
You wanna save that to your
dock at the bottom of the page,

47
00:02:14.195 --> 00:02:17.165
cuz you'll be using that all the time,
and in the next lecture,

48
00:02:17.165 --> 00:02:19.375
we'll be downloading MySQL and
getting started.

49
00:02:19.375 --> 00:02:19.875
See you there.