I am venket and this is the introduction to SQL Server tutorial. In this video, we'll download
and install the latest free version of SQL Server. As of this recording, the latest version is SQL
Server 2019. Now, these are the four different editions we have in SQL Server 2019. Both,
the Enterprise and the Standard editions are for production use. So, obviously they have license
costs. The Enterprise edition has got more features than any other edition in SQL Server
2019, and obviously the most expensive. Both these editions, that is Express and Developer are free
to download and install. The Express edition has a size limit of 10 GB, that is you can only
use it to build small data driven web and mobile applications up to 10 GB in size. The Developer
edition on the other hand, has all the features of the Enterprise edition. It's also free,
but you can only use it for non-production use. So, if you're learning SQL Server, then this
is the edition that you want to download and install. Now, fire up your favourite browser
and then search the internet with the search string "download sql server". You should see, this
Microsoft SQL Server downloads page. Click on that and then when we scroll down a bit, you should see
the Developer edition. This is free to download and install. So, click "download now" button.
Double click on the downloaded executable and if you get any security prompt click "yes".
On this screen, you have to select the installation type. Basic installation works
for us. So, let's select that. Accept license terms and then click the "install" button.
The installer automatically downloads and installs sql server. How long the process takes obviously
depends on the speed of your internet connection
There we go. Installation complete and what we have just installed is SQL Server database engine.
Now, we need another piece of software called "SQL Server Management Studio" and to install
"SQL Server Management Studio", click this button "Install SSMS". SSMS by the way stands for
SQL Server Management Studio. When I click that, it again takes us to the Microsoft downloads
page and when we scroll down a bit, here, we have the link to download SQL Server
Management Studio. So click on that. There we go download complete. Double click on the executable
to install. Click "Yes" on any security prompts and then finally click "Install" button.
There we go, SQL Server Management Studio is also successfully installed. Finally, close this SQL
Server installer window. Now, click on the "Start" button and you must find SQL Server Management
Studio under "Recently added" tab. If you don't find it here, scroll down in the "Programs" list
and then within letter "M" you'll find Microsoft SQL Server Tools,
and in this folder we have Microsoft SQL Server Management Studio. Click on that to launch.
We want to connect to SQL Server "Database Engine", so select that from the drop-down
list and then the "Server Name" is the same as our computer name. If you don't know your
computer name, click on the "Start" button and then search for this app "System Information".
We can find the system name right here. So, the server name is the system name
and then we want to use "Windows Authentication" to connect to SQL Server. So, select that from the
"Authentication" drop-down list and then click "Connect". There we go. We are now connected
to SQL Server database engine. Click on this "New Query" tab. This opens up a windows, where we can
write and execute SQL queries. Now, you can find all of our free software training courses under
"Free Online Courses". On this page, you'll find many frontend, backend and database courses.
If you go on to Page 2, we have our SQL Server Tutorial for Beginners course right here. This
course starts from the basics and covers all the advanced concepts as well. On this page,
you'll find all our SQL Server videos, text articles and slides in sequence. Your feedback
means a lot. So, if you have a few minutes, please provide your rating for this course
and your valuable feedback on the "Reviews" tab. Thank you for listening. Enjoy SQL coding.