Hello guys in this article we will see how we can easily download and
install Microsoft SQL server 2019 with the SQL server management studio so for
that you need to go to the browser.
Step 01
let's first download SQL server on google
type SQL server press enter.
Search MS SQL on Google
Step 02
As you know that SQL Server is owned by Microsoft
so this is the website you need to click on this microsoft.com.
Express Downlaod
Step 03
Nowhere let's
click on downloads now we have reached the download section here you can see developer and
express edition is visible so here we will be
downloading 2019 express edition here it is clicked on download now it is
downloading on the left now we have downloaded it you can double click here or
you can just click on the arrow and click on open.
open File
Step 04
Minimize this now you can see
the express edition installation type is visible basic custom and download
media through this you can download the files and you can install later custom
installation means you can select what you want to install or what you want to
leave here is the basic installation for beginners click on it now the license
terms are visible you need to click on accept here you need to specify the installation the location that is where Microsoft SQL server will get installed so it will get
installed on the c drive program files and a new folder will get created if you want to change the location click
on browse from here,
Basic version
Step 05
You can select the location where you need to install
Microsoft SQL server I'll keep the same so click on cancel the download size is
266 MB you just need to click on install here now the installation packages are
getting downloaded so guys now the download completed it is now installing
waiting for install
Step 06
so
guys we have installed an SQL server the first is our instance name that is the
address connection string the second one is a log folder I hope you know what
is a log is wherein whenever you will start SQL server or even if there is
an error everything will get reported under log file log folder the next one is
wherein we installed SQL server express edition this is the resources folder now
we can straightaway connect now from here let's connect here it got connected.
connect command
check connection command
Step 07
now you can see the SQL server is visible which means we have installed SQL
server correctly now going further here it is giving an option to install ssms that
means SQL server madman studio so SQL server management studio is a software
application or a tool through which you can easily work on SQL server.
install server management studio
Step 08
you can
easily create databases tables manage and you can also work as an administrator
there itself so let's install click on install ssms yes open with any browser now
here you need to download SQL server management studio here is the link we will
also, add this link in the description click on it it will download
download ssms file
Step 09
on the left you
can see it's around 6 35 Mb so it will take an ample amount of time so guys now
you can see we have downloaded the setup for SQL server manual studio click on
the arrow open let's minimize this now guys the path is visible to install SQL
server manual studio here is the location if you want to change it you can
change it from here by clicking change you can change the location from here
and click on ok so SQL server will get
installed in the in this folder click on install.
install ssms file
Step 10
Guys now you can see all the
components have been installed now click on close now let's start it go to
start type SQL server here it is management studio click on it so here is our
SQL server manual studio
