1
00:00:00,330 --> 00:00:02,460
Welcome to the first video in this course.

2
00:00:02,460 --> 00:00:10,140
Introduction to school server 2017 and today we'll be looking at downloading and installing this bit

3
00:00:10,140 --> 00:00:11,880
of software now.

4
00:00:12,130 --> 00:00:17,660
A database is pretty much a logical collection of related data.

5
00:00:17,670 --> 00:00:18,780
That's it in a nutshell.

6
00:00:18,780 --> 00:00:25,830
If you have prior experience with databases it probably came with Microsoft Access or my S2 well and

7
00:00:25,830 --> 00:00:27,920
you just want to extend your knowledge beyond that.

8
00:00:27,930 --> 00:00:34,080
And even if you have no prior knowledge of databases This is an excellent course to get you up to speed

9
00:00:34,080 --> 00:00:37,080
with what databases are capable of.

10
00:00:37,080 --> 00:00:43,110
What preparation is to go in place and how you can go about starting your journey towards becoming a

11
00:00:43,110 --> 00:00:48,170
database administrator or just manipulating data in databases altogether.

12
00:00:48,210 --> 00:00:56,550
As I said before we'll be exploring all of these concepts using Microsoft Eskew server 2017 and I already

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

14
00:00:59,550 --> 00:01:07,380
So I have included the U R L as outlined here in the class notes and this would get you to downloading

15
00:01:07,380 --> 00:01:15,360
the Microsoft school server 2017 express database engine and the short description is that it's a powerful

16
00:01:15,360 --> 00:01:22,910
and reliable database management system that allows you to build lightweight Web sites and desktop applications.

17
00:01:22,920 --> 00:01:24,420
So this is pretty good.

18
00:01:24,420 --> 00:01:26,570
Pretty decent is a decent starting place.

19
00:01:26,580 --> 00:01:31,230
If you don't have that high spec high end machine you just have a regular machine you just want to get

20
00:01:31,230 --> 00:01:31,620
started.

21
00:01:31,620 --> 00:01:33,300
This is an excellent option.

22
00:01:33,300 --> 00:01:40,380
There are other additions that you would probably see in your research but if you follow this link it

23
00:01:40,380 --> 00:01:45,450
will cut through all of that noise and all the other additions and we can get started with Express so

24
00:01:45,450 --> 00:01:51,600
you can go ahead and download and initiate initiate that download procedure and then another bit of

25
00:01:51,600 --> 00:01:57,120
software that we're interested in is the Esko server management studio.

26
00:01:57,340 --> 00:02:03,630
Know the management studio will be your gateway into actually interacting with the database interrogating

27
00:02:03,630 --> 00:02:08,970
the data and writing what we call queries in a language we call escrow.

28
00:02:09,030 --> 00:02:11,570
We'll get into all of those things in due time.

29
00:02:11,580 --> 00:02:18,630
But for now you can follow this euro once again it's in the class notes and we can just take this download

30
00:02:18,630 --> 00:02:21,750
button to initialize this download which may take awhile.

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

32
00:02:27,810 --> 00:02:30,800
that installation process.

33
00:02:30,830 --> 00:02:32,340
Guys welcome back.

34
00:02:32,390 --> 00:02:39,820
Know that our downloads are finished we'll start by installing our school express engine.

35
00:02:39,950 --> 00:02:47,170
So we just click on that installation file click Run and then we will be greeted with this installation

36
00:02:47,170 --> 00:02:52,160
on screen we can click basic custom would allow you to select certain features.

37
00:02:52,160 --> 00:02:54,080
At this stage we don't need to be doing that.

38
00:02:54,080 --> 00:03:01,080
We can just go with basic we can go ahead and agree to the terms and conditions you can read it through

39
00:03:01,080 --> 00:03:02,270
if you wish.

40
00:03:02,400 --> 00:03:07,650
If you have other ideas then you may want to change the rhetoric otherwise you may as well leave as

41
00:03:07,650 --> 00:03:11,550
a default and you can see here that of 6 gigabytes.

42
00:03:11,550 --> 00:03:18,540
We only really need 300 megabytes so I'm just going to go ahead and click install and this may take

43
00:03:18,540 --> 00:03:21,540
a while so you will reconvene once this is finished.

44
00:03:22,070 --> 00:03:22,440
OK.

45
00:03:22,470 --> 00:03:29,760
So at the end of that installation procedure you'll see that you were successful in doing this installation

46
00:03:29,760 --> 00:03:35,520
and then they give you some information to give you a connection string so if you wanted to develop

47
00:03:35,520 --> 00:03:41,300
an application on top of this database then you would probably want to pay attention to this part.

48
00:03:41,470 --> 00:03:47,790
But that's not really necessary right now and they just give you the parts for the love files and other

49
00:03:48,090 --> 00:03:50,270
essential bits of the application.

50
00:03:50,280 --> 00:03:58,230
Another essential part of this installation process as mentioned before is to install the sequel Management

51
00:03:58,230 --> 00:04:05,130
Server studio at the end of this express addition installation they will actually give you an option

52
00:04:05,130 --> 00:04:12,070
to C install SS m s and this will really just bring up your browser to navigate to.

53
00:04:12,270 --> 00:04:19,829
Well I figure this speech so the link to this page is already included in the class notes and here from

54
00:04:19,829 --> 00:04:26,760
here you can get a direct download to the management studiously if you didn't do it before you may just

55
00:04:26,760 --> 00:04:29,090
follow this link and get that file.

56
00:04:29,110 --> 00:04:37,980
I already have it downloaded here so I just initiate this installation all of this will launch the installer

57
00:04:38,010 --> 00:04:43,260
and they really just give you one button to click which is install of course you can change its location

58
00:04:43,260 --> 00:04:45,500
if you have other ideas for the path.

59
00:04:45,690 --> 00:04:50,670
Otherwise you may leave it as the as the default and just click install.

60
00:04:50,700 --> 00:04:52,410
So this may also take a while.

61
00:04:52,410 --> 00:04:59,470
So we will reconvene at the end of this process.

62
00:04:59,720 --> 00:05:00,200
OK.

63
00:05:00,230 --> 00:05:06,710
So our installation is finished and all we have to do is restart to continue so we can just do that

64
00:05:06,710 --> 00:05:13,510
quickly and we in the next video we'll start looking at how we start piecing everything together.

65
00:05:13,580 --> 00:05:18,560
What's a database is and why learning this skill is so important.

66
00:05:18,560 --> 00:05:19,120
Stay tuned.