Welcome to the first video in this course, introduction to eschew 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.
And that's it.
In a nutshell, if you have any experience with databases, it probably came with Microsoft Access or
my SD.
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
needs 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 SQL Server 2017, and I
already have it up on my screen the page for download.
So I have included the URL as outlined here in the Class Notes, and this will get you to downloading
the Microsoft SQL Server 2017 Express database engine.
And the server description is that it's a powerful and reliable database management system that allows
you to build lightweight websites and desktop applications.
So this is pretty good, pretty decent.
It's 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 put that download and initially initiate
that download procedure.
And then another bit of software that we're interested in is the Eskimo Server Management Studio.
No, 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 you call S12.
We'll get into all of those things in due time, but for now, you can follow this URL.
Once again, it's in the class notes, and we can just click this download button to initialize this
download, which may take a while.
It's a pretty big file, so as soon as that download is done, we'll reconvene and then we will walk
through that installation process.
Hey, guys, welcome back.
No, 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 screen
we can click.
Basic custom would allow you to select certain features of 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 their picture.
Otherwise you may as well use as a default.
And you can see here that of six 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 we 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.
They 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 exposition installation, they will actually give you an option to see installed
systems.
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 studio.
So if you didn't do it before, you may just follow this link and get that file.
I already have it in 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 installed.
Of course, you can change this 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 will start looking at how we start piecing everything together, what the database
is and why learning this skill is so important.
Stay tuned.