1
00:00:00,330 --> 00:00:06,780
Welcome to the first video in this course, introduction to eschew server 2017, and today we'll be

2
00:00:06,780 --> 00:00:10,950
looking at downloading and installing this bit of software.

3
00:00:11,250 --> 00:00:16,950
Now a database is pretty much a logical collection of related data.

4
00:00:17,370 --> 00:00:18,060
And that's it.

5
00:00:18,060 --> 00:00:24,270
In a nutshell, if you have any experience with databases, it probably came with Microsoft Access or

6
00:00:24,270 --> 00:00:24,960
my SD.

7
00:00:24,960 --> 00:00:27,870
Well, and you just want to extend your knowledge beyond that.

8
00:00:27,870 --> 00:00:31,350
And even if you have no prior knowledge of databases.

9
00:00:31,590 --> 00:00:37,920
This is an excellent course to get you up to speed with what databases are capable of, what preparation

10
00:00:37,920 --> 00:00:44,460
needs to go in place, and how you can go about starting your journey towards becoming a database administrator

11
00:00:44,460 --> 00:00:47,700
or just manipulating data in databases altogether.

12
00:00:48,120 --> 00:00:56,160
As I said before, we'll be exploring all of these concepts using Microsoft SQL Server 2017, and I

13
00:00:56,160 --> 00:00:59,370
already have it up on my screen the page for download.

14
00:00:59,490 --> 00:01:07,380
So I have included the URL as outlined here in the Class Notes, and this will get you to downloading

15
00:01:07,380 --> 00:01:12,600
the Microsoft SQL Server 2017 Express database engine.

16
00:01:12,840 --> 00:01:18,630
And the server description is that it's a powerful and reliable database management system that allows

17
00:01:18,630 --> 00:01:22,920
you to build lightweight websites and desktop applications.

18
00:01:22,920 --> 00:01:25,190
So this is pretty good, pretty decent.

19
00:01:25,200 --> 00:01:26,550
It's a decent starting place.

20
00:01:26,550 --> 00:01:30,990
If you don't have that high spec, high end machine, you just have a regular machine, you just want

21
00:01:30,990 --> 00:01:31,620
to get started.

22
00:01:31,620 --> 00:01:33,060
This is an excellent option.

23
00:01:33,270 --> 00:01:39,990
There are other additions that you would probably see in your research, but if you follow this link,

24
00:01:40,200 --> 00:01:43,490
it will cut through all of that noise and all the other additions.

25
00:01:43,500 --> 00:01:48,780
And we can get started with Express so you can go ahead and put that download and initially initiate

26
00:01:48,780 --> 00:01:50,040
that download procedure.

27
00:01:50,340 --> 00:01:57,060
And then another bit of software that we're interested in is the Eskimo Server Management Studio.

28
00:01:57,300 --> 00:02:03,630
No, the management studio will be your gateway into actually interacting with the database, interrogating

29
00:02:03,630 --> 00:02:08,660
the data and writing what we call queries in a language you call S12.

30
00:02:08,940 --> 00:02:14,140
We'll get into all of those things in due time, but for now, you can follow this URL.

31
00:02:14,160 --> 00:02:20,070
Once again, it's in the class notes, and we can just click this download button to initialize this

32
00:02:20,070 --> 00:02:21,740
download, which may take a while.

33
00:02:21,750 --> 00:02:27,480
It's a pretty big file, so as soon as that download is done, we'll reconvene and then we will walk

34
00:02:27,480 --> 00:02:29,460
through that installation process.

35
00:02:30,620 --> 00:02:31,970
Hey, guys, welcome back.

36
00:02:32,330 --> 00:02:40,640
No, that our downloads are finished, we'll start by installing our school express engine, so we just

37
00:02:40,640 --> 00:02:47,630
click on that installation file, click run and then we will be greeted with this installation screen

38
00:02:47,960 --> 00:02:48,620
we can click.

39
00:02:48,620 --> 00:02:52,880
Basic custom would allow you to select certain features of this stage.

40
00:02:52,880 --> 00:02:54,050
We don't need to be doing that.

41
00:02:54,050 --> 00:02:55,310
We can just go with basic.

42
00:02:57,390 --> 00:03:01,680
We can go ahead and agree to the terms and conditions you can read it through if you wish.

43
00:03:02,400 --> 00:03:05,890
If you have other ideas, then you may want to change their picture.

44
00:03:05,920 --> 00:03:08,310
Otherwise you may as well use as a default.

45
00:03:08,550 --> 00:03:14,580
And you can see here that of six gigabytes, we only really need 300 megabytes.

46
00:03:14,880 --> 00:03:17,220
So I'm just going to go ahead and click install.

47
00:03:17,520 --> 00:03:21,090
And this may take a while, so we will reconvene once this is finished.

48
00:03:22,020 --> 00:03:28,860
OK, so at the end of that installation procedure, you'll see that you were successful in doing this

49
00:03:28,860 --> 00:03:32,100
installation and then they give you some information.

50
00:03:32,100 --> 00:03:33,840
They give you a connection string.

51
00:03:33,840 --> 00:03:39,360
So if you wanted to develop an application on top of this database, then you would probably want to

52
00:03:39,360 --> 00:03:40,800
pay attention to this part.

53
00:03:41,460 --> 00:03:47,280
But that's not really necessary right now, and they just give you the parts for the love files and

54
00:03:47,280 --> 00:03:49,950
other essential bits of the application.

55
00:03:50,190 --> 00:03:57,450
Another essential part of this installation process, as mentioned before, is to install the sequel

56
00:03:57,450 --> 00:03:59,470
management server studio.

57
00:04:00,090 --> 00:04:06,000
At the end of this exposition installation, they will actually give you an option to see installed

58
00:04:06,090 --> 00:04:06,750
systems.

59
00:04:07,110 --> 00:04:11,490
And this will really just bring up your browser to navigate to.

60
00:04:12,150 --> 00:04:13,800
Well, I figure this speech.

61
00:04:13,950 --> 00:04:18,180
So the link to this page is already included in the class notes.

62
00:04:18,450 --> 00:04:24,810
And here from here, you can get a direct download to the management studio.

63
00:04:24,810 --> 00:04:28,890
So if you didn't do it before, you may just follow this link and get that file.

64
00:04:29,100 --> 00:04:33,660
I already have it in downloaded here, so I just initiate this installation.

65
00:04:35,820 --> 00:04:41,470
All of this will launch the installer, and they really just give you one button to click which is installed.

66
00:04:41,490 --> 00:04:45,200
Of course, you can change this location if you have other ideas for the path.

67
00:04:45,600 --> 00:04:49,770
Otherwise, you may leave it as the as the default and just click install.

68
00:04:50,640 --> 00:04:55,140
So this may also take a while, so we will reconvene at the end of this process.

69
00:04:59,630 --> 00:05:06,410
OK, so our installation is finished, and all we have to do is restart to continue, so we can just

70
00:05:06,410 --> 00:05:07,130
do that quickly.

71
00:05:07,550 --> 00:05:14,510
And we in the next video will start looking at how we start piecing everything together, what the database

72
00:05:14,510 --> 00:05:18,350
is and why learning this skill is so important.

73
00:05:18,530 --> 00:05:19,100
Stay tuned.