For use with MS SQL server, Microsoft offers two specialized
free SQL download editions:
1.
Developer –
Developer - It has all the features that MS SQL Server provides, but we are
unable to use it in production. It is the best place to begin from the
standpoint of learning.
2.
Express: This
version of the SQL server is also available for free download, but it has fewer
functionality and no business intelligence applications. For installation,
we'll use the MS SQL server download Developer edition.
Step 2) Select
"Download Now"
Our SQL server installation will be configured as
'SQLServer2017-SSEI-Dev.exe'.
Installing SQL Server: Steps
the steps to install SQL in Windows 10 are as follows:
Step 1) Open the.exe file in step one.
Click "SQLServer2017-SSEI-Dev.exe" twice. There
will be three options on the screen below: Basic, Custom, and Download files.
Step 2) Select the version
The 'Basic' option should be selected if you want to use
the basic version, which has all the default configurations needed to learn MS
SQL.
Step 3) Accept the conditions
The screen titled "Microsoft Server License Terms"
will appear. Click "Accept" after reading the License Terms.
Step 4) Select the site
The 'SQL server install location' window will show up below.
1.
Microsoft SQL Server's
default location is “C> Program Files”.
2.
By selecting Browse, we
can also choose to alter the installation place.
3.
To launch the SQL installation for Windows 10 after
choosing the location, click the 'Install' option.
The 'Downloading
install package' progress screen will be below.
displayed. As soon as the
SQL software download is finished, wait.
Installation progress is displayed below the
screen.
Step 5) Complete the setup procedure.
We can "Close" this window because this
configuration is self-sufficient for moving forward with understanding the SQL server.
However, the label and
button are summarized below:
1.
Name of the instance: By
default, this is identified as MSSQLSERVER.
2.
Now connect: This
will open a different command line window so you can test your connection to
the newly installed software. The system will automatically execute the "select
@@Version" command to make sure we can successfully connect to the new
MSSQLSERVER instance.
3. Individualise: Doing so will launch the SQL Installation with the ability to add
features that are not already included in the BASIC installation and to further
modify the system.
4. Install SSMS: This is the IDE that will direct us to the Microsoft SSMS
download page. In our SSMS tutorial, we will go through SSMS in depth.
5. Close: This will bring this window to a close. The user is now
prepared to install the SSMS IDE as described in the SSMS tutorial.
x
x