Welcome to the first video in this course.
Introduction to school server 2017 and today we'll be looking at downloading and installing this bit
of software now.
A database is pretty much a logical collection of related data.
That's it in a nutshell.
If you have prior experience with databases it probably came with Microsoft Access or my S2 well and
you just want to extend your knowledge beyond that.
And even if you have no prior knowledge of databases This is an excellent course to get you up to speed
with what databases are capable of.
What preparation is to go in place and how you can go about starting your journey towards becoming a
database administrator or just manipulating data in databases altogether.
As I said before we'll be exploring all of these concepts using Microsoft Eskew server 2017 and I already
have it up on my screen the page for download.
So I have included the U R L as outlined here in the class notes and this would get you to downloading
the Microsoft school server 2017 express database engine and the short description is that it's a powerful
and reliable database management system that allows you to build lightweight Web sites and desktop applications.
So this is pretty good.
Pretty decent is a decent starting place.
If you don't have that high spec high end machine you just have a regular machine you just want to get
started.
This is an excellent option.
There are other additions that you would probably see in your research but if you follow this link it
will cut through all of that noise and all the other additions and we can get started with Express so
you can go ahead and download and initiate initiate that download procedure and then another bit of
software that we're interested in is the Esko server management studio.
Know the management studio will be your gateway into actually interacting with the database interrogating
the data and writing what we call queries in a language we call escrow.
We'll get into all of those things in due time.
But for now you can follow this euro once again it's in the class notes and we can just take this download
button to initialize this download which may take awhile.
It's a pretty big file so as soon as that download is done we'll reconvene and then we'll walk through
that installation process.
Guys welcome back.
Know that our downloads are finished we'll start by installing our school express engine.
So we just click on that installation file click Run and then we will be greeted with this installation
on screen we can click basic custom would allow you to select certain features.
At this stage we don't need to be doing that.
We can just go with basic we can go ahead and agree to the terms and conditions you can read it through
if you wish.
If you have other ideas then you may want to change the rhetoric otherwise you may as well leave as
a default and you can see here that of 6 gigabytes.
We only really need 300 megabytes so I'm just going to go ahead and click install and this may take
a while so you will reconvene once this is finished.
OK.
So at the end of that installation procedure you'll see that you were successful in doing this installation
and then they give you some information to give you a connection string so if you wanted to develop
an application on top of this database then you would probably want to pay attention to this part.
But that's not really necessary right now and they just give you the parts for the love files and other
essential bits of the application.
Another essential part of this installation process as mentioned before is to install the sequel Management
Server studio at the end of this express addition installation they will actually give you an option
to C install SS m s and this will really just bring up your browser to navigate to.
Well I figure this speech so the link to this page is already included in the class notes and here from
here you can get a direct download to the management studiously if you didn't do it before you may just
follow this link and get that file.
I already have it downloaded here so I just initiate this installation all of this will launch the installer
and they really just give you one button to click which is install of course you can change its location
if you have other ideas for the path.
Otherwise you may leave it as the as the default and just click install.
So this may also take a while.
So we will reconvene at the end of this process.
OK.
So our installation is finished and all we have to do is restart to continue so we can just do that
quickly and we in the next video we'll start looking at how we start piecing everything together.
What's a database is and why learning this skill is so important.
Stay tuned.