Hey guys welcome back to this SQL tutorial course. So in this session we'll
be installing Microsoft SQL server. So all you have to do is go to Google and
then type Microsoft SQL server download and you'll get these search
results, now all of these search results click this one where you see SQL
server downloads from the Microsoft site so we are into the site now if I scroll
down we see two free editions we have the developer edition and the Express
Edition, so I'd be downloading the developer edition I click on download
and the download will start now this is the downloaded file over
here SQL server 2017 SSCI development so we get this window here and we have
three options basic, custom and download media. So I click on custom now we see
that we have a media location where the SQL server will be downloaded
and I'll click on install
you see that the download is successful and our installation will begin shortly
here I'll click on installation and I'll select this one so I'll be installing
a standalone installation of the SQL server
so let us wait for this to open
all right so here I click on next now I only have one instance of SQL
server so I'll be installing a new one so I lL select this perform a new
installation of SQL server 2017 and then I'll select this free edition
and click on next after that I'll accept this license agreement and again I'll
click on next so we have all of these features over
here so I would just need the database engine services so I'll select this and
again I'll click on next
so I have to name the instance for the server which I'm installing so I ll
name this server as let's say sparta similarly I will give the same instance
id over here, I'll click on next
so again I'll click on next over here so we see that we have two authentication
modes, windows authentication mode and mix mode. I will select the mixed mode
and then enter the desired password let me put in my password over here
I ll add the current user
so the current user has been added. Now I'll click on next again
right so you're finally ready to install SQL server. I'll click on install
right so once the installation is done I will also have to install the SQL
server management tools so the sequence of a management tools basically help us
to connect with the database. I'll click on this
and this will redirect us to the Microsoft web page and over here I'd
have to download the SQL server management studio and I'll be
downloading the latest version and this is the downloaded file over here
SSMS setup enu, I'll click on this, so here we have these three options repair, uninstall
and close. Now i have these three options because I've already
installed Microsoft SQL server management studio in my system and if
you are installing this for the first time you'll have the install button over
here so you'd have to click on install and the install would be done
automatically right so once you install the SQL server management tools, go to
the search tool and type Microsoft SQL server management studio click on
this and Microsoft SQL server management
studio will start
so over here you'd have to specify the password which you gave while creating
the instance
and then click on connect and to start writing your SQL commands
click on new query over here
and then you can happily implement all of your SQL commands
right so this was the installation of Microsoft SQL server.