Need up to 30 seconds to load.
hello everyone I will come here to my
Channel today I'm going to show you how
to install SQL server on a Windows
operating system so let's begin now to
install SQL Server you need to First
simply go to Fitbit browser in the
address bar UTI simply searched with SQL
Server
download and hit enter and you will get
this
www.microsub.com as a first search
result so here select on SQL Server
downloads
and it will mean to redirect to the
official site of you know Microsoft so
you can close this
and when you scroll down you can see
that we have you know our SQL Server
2019 is available for download for
developer and express so you can just
simply download the express Edition
because it is free and it will give you
more features so just simply click on
download now and you can see that our
installer for SQL 2019 is rightly
downloaded okay so you need to just
simply click on this installer and it
will ask you for administrative
privileges just simply click on yes
and you can just simply minimize the our
browser
and you can see that our SQL Server 2019
Express Edition is rightly launched over
here so here you can choose you know
basic
and you need to accept this license
agreement
and this is where our SQL Server is
going to be installed
so you can see that download size is 266
MB okay and you need to have around you
know 6.5 GB of free space
so just simply click on install and the
area code installation has directly
began
see installing SQL Server will take you
know some time about 10 minutes I would
say so I'll be coming back after
finishing up this process
so we'll come back and now we can
clearly see that our installation is
successful so this is our you know
connection string and this is where you
know our log file is going to be there
so everything that we are doing going to
be on a logged over here
and this is where you know our
installation media folder and this is
where is the installation resources
folder okay so now that you know our SQL
Server is rightly installed it's time to
install ssms so systems is basically you
know is an IDE so just simply click on
that and it is going to you know
redirect to the brow so from here you
need to download these ssms just simply
scroll down and you can see free
download for SQL Server management
studio
18.12.1 just simply click on that and it
will going to download the you know EXE
so let's wait for some time to download
our EXE
so you can see that our ssms is rightly
downloaded so you can just simply click
on the EXE
and it will ask you for an
administrative privileges again click on
yes
and you can minimize your browser
so you can close this SQL Server 2019
for now
okay
and here you can see the installation
wizard for our you know SQL management
studio so just simply click on install
and it will go into you know start
loading package
so again installing these uh you know
Microsoft SQL Server management studio
will take some time so you need to wait
for about you know five minutes I would
say so after that I'll be again coming
back
so welcome back once again guys so you
can see that our Microsoft SQL Server
management studio is rightly installed
so you can just simply close it
so now that you know our SQL server and
our you know SQL Server management
Studio both are installed you can just
simply go to search and just type here
is SMS so once you type that you will be
able to see this Microsoft SQL Server
management studio will be there so
simply open that you know my
microservice will server version Studio
and you can see that our Microsoft
rescue server management studio is ready
launch
so here you can see Server type is
database engine which is totally fine
and server name is also fine and will be
doing Windows authentication so that is
also fine okay if you want to change you
need to do the setup thing so in this
video I am going to proceed with Windows
authentication okay if you need you know
to know about you know how to set SQL
Server authentication please do drop a
comment into our comment sections I'm
going to you know make a video on that
as well okay if you need so for now it
this is totally fine just simply click
on connect
and there you go it is you know rightly
connected with our SQL Express okay so
here you can just simply create a new
file from you know go to file new and
you can create a new query
you can also create a new query by just
you know simply clicking on this new
query window
and you can see that our query window is
rightly opened over here so let's create
a database so create a database
you know I'm going to name the database
as players
I'll end with the semicolon so let's
create a database select and click on
execute
and there you go command you know
completed successfully so let's create a
table
create table
you know
cricketers
and I'll just simply open and close the
bracket and I need to give a couple of
column so let's give the column name as
you know player ID
I'll give the you know data type as int
and I'll give another column as a name
and it will be where CAD to provide you
know
the length so I'll give the length as
50. okay so this is our table just
simply you know select our table click
on execute and you can see comment you
know completed successfully
so let's insert a couple of values so
insert into
cricketers
and
the couple of you know columns are clear
underscore ID then you know name
okay and values
I'll give
you know one let's say
ID and name
let's see if okay it will be single code
okay and the name let's give you know
without
Kohli just simply execute this statement
you can see one row effect
so
let's insert one more
with different ID this time
and let's give
Rohit Sharma
just simply insert our statement and if
you just you know simply
fetch the table so select start from
cricketers
in with a semicolon and just simply
execute this
you can see the output Player 1 without
Kohli and player 2 with Sharma okay so
in this we can easily install Microsoft
SQL server on a Windows operating system
and then I have also shown you how to
install SQL Server management Studio on
your Windows operating system so if you
face any difficulty please do comment in
your comment sections I am always there
to help you and if this video really
helped you then please do subscribe our
channel that will really help me to make
more such videos so thank you very much
for watching this video and God bless
you all
![How to Install Microsoft SQL Server & SSMS on Windows 10/11 [ 2023 Update ] Complete guide](https://i.ytimg.com/vi/iaUXjTL_F9U/mqdefault.jpg)
![How to Install Microsoft SQL Server 2019 & SSMS on Windows 10/11 [ 2023 Update ] Complete guide](https://i.ytimg.com/vi/kGdTg-vGs-E/mqdefault.jpg)
![How to install SSMS on Windows 10 | SQL Server Management Studio v18.6 | [2020]](https://i.ytimg.com/vi/yujGgZPIHJQ/mqdefault.jpg)
