Microsoft has created the SQL Server that is a relational database management system. The primary functionality of SQL is to store and recover the information as mentioned by the client or another application. SQL functions can either run on a similar framework or another over a system. In this tutorial, things are explained like,
- Click on Download now and the downloading will start
After the download is finished, the file will be available as SQLServer2017-SSCI-Dev.
To learn MS SQL in detail available SQL certification courses can be helpful.
SQL Server Installation:
- Click on the file SQLServer2017-SSCI-Dev, and you will find a window with three options: Basic, Custom, and Download Media
- Select Custom, as we want the Developer edition. A path for it will be visible below Media Location. Either retain the default one or specify a customized.
- Here in the image, the default path is retained in Media Location
- Once the path is selected, need to click on Install and the installation will start
- The message will appear as Your SQL Server Installation will begin shortly…Then you will find a pop-up screen
- A pop-up window, SQL Server Installation Center, appears and it contains two columns
- Select Installation from the left-side column. As you select the option, you will find multiple options on the right-side column
- Select the first option from the right-side column, New SQL Server stand-alone installation or add features to an existing installation
- Wait for it to process and you will have a window SQL Server 2017 Setup. Now click on Next
- Select Perform a new installation and click Next
- Select the free edition from Specify a free edition and click on Next
- Accept the license terms
- Now you can see the features of the SQL Server 2017
- In this blog, we will demonstrate by selecting Database Engine Services
- Click on Next
- The next setup is the Instance Configuration
- Give the details in Named instance and Instance ID fields and click on Next
- Here in the snapshot, I have used the Name as SPARATA and the same appears for the Instance ID
- The Server Configuration screen is displayed. Click on Next
- Now on the screen, you will find two authentication modes, Windows authentication mode and
Mix Mode - Select the Mix mode and enter the desired password and confirm the password
- Select the user by clicking on Add Current User, and the current user has been added now
- Click on Next
- Once the Current User is added, the SQL Server is ready to install
- Now, click on Next and the installation process takes place
- Once the installation process is completed, you’re back to SQL Server Installation Center
Now, you will also have to install the SQL Server Management Tools.
This tool will help you connect with the database.
- Click on Install SQL Server Management Tools and get redirected to Microsoft web page
- Download the latest version of SQL Server Management Studio and you will find the downloaded file in your folder as SSMS-Setup-ENU
- Click on the file and install the studio
- Once the installation is completed, search for Microsoft SQL Server Management Studio
- The SQL Server Management Studio is launched, and you will find a popup, Connect to Server
- Enter your Login password and click on Connect
