EDUCBA

EDUCBA

MENUMENU
  • Blog
  • Free Courses
  • All Courses
  • All in One Bundle
  • Login
Home Data Science Data Science Tutorials SQL Tutorial How to Install SQL Server

How to Install SQL Server

By Afshan BanuAfshan Banu

How to Install SQL Server

How to Install SQL Server?

The following article provides an outline for How to Install SQL Server. SQL server can be installed by Downloading SQL server from Microsoft.com site where various version is available and launching the appropriate installer once the download is completed. There are three editions for the installation type: Basic, Custom, and Download media; it is always recommended to select custom type as it helps to select the features from the list we wish to install.

How to Download Microsoft SQL Server Management Studio 2017 (SSMS)

SSMS is a tool used to configure, monitor, and administer instances of SQL and SSMS use for data-tier components to monitor, deploy, and upgrade it for the applications and even the important use to build and run scripts and queries.

Start Your Free Data Science Course

Hadoop, Data Science, Statistics & others

Now download the Microsoft SQL Server Management Studio 2017 from:

https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017

Through this link, you can download SSMS 17.0. The latest version of SQL Server Management Studio is 18.0, which is Microsoft SQL Server Management Studio 2018.

Now the below image shows the download page for Microsoft SQL Server Management Studio 2017.

Download SQL server Management Studio

Steps to Install SQL Server

Let us see the steps required to install SQL Server:

Once you download “SSMS-Setup-ENU.exe”, other windows get open for saving SQL Server Management Studio 2017 exe, and once you click the save file button, it starts the downloading.

SSMS-Setup-ENU

Step 1: Next, for the installation, go to the folder where “SSMS-Setup-ENU.exe” is there and then double click the exe file to start the installation.

SQL Server installation Step 1

 

Step 2: After that, the system will ask the permission that is Click yes to continue installing.

Step 3: Next comes the Installation window. Click the Install to begin the installation.

Click the Install

Then install gets start and then starts the Loading Packages.

Loading Packages

Step 4: When the installation of SQL Server is completed, it asks to close the window, so click the close button and restart your computer.

Click the close button

Step 5: Now, to start with Microsoft SQL Server 2017 tool, click the start button and search for Microsoft SQL Server management studio 17; once you get it to click on it, and it gets starts.

SQL Server installation Step 5

Step 6: Once you start SQL Server Management Studio 17, opening the SQL Server Management Studio 17 the first time will take a few minutes but not the next time when using it.

SQL Server installation Step 6-1

And finally, after opening “SQL Server Management Studio 2017”, it comes with the following window and asks to connect server. So click connect and start using the “SQL Server Management Studio 2017”.

SQL Server Management Studio 2017

The installation of SQL Server Management Studio is completed; now, we will discuss the feature and components of the SQL Server Management Studio and how to use it. An integrated environment tool, SQL Server Management Studio, can be used to create and manage SQL and also to develop all components of SQL Server, SQL Data Warehouse and even in business intelligence. SQL Server Management Studio provides a number of graphical commands which helps to access to SQL Server and to create and manage SQL server objects.

Components of SQL Server Management Studio

Given below are the components of SQL Server Management Studio to get familiar with the SQL Server Management Studio tool:

  • Object Explorer: Object Explorer is used to create, manage and view all of the SQL Server objects like the database, table, view, index and all.
  • Template Explorer: Template Explorer is used to build and manage the predefined queries. The predefined queries here help to speed up the development of queries as we just need to customize it.
  • Solution Explorer: Solution Explorer used to view the build and open projects and even to manage queries and scripts for administration task.
  • Visual Database Tools: SQL Server Management Studio includes visual design tools.
  • Query and Text Editors: Query and Text Editors used to write and execute queries and scripts. Once you write the query, execute it with the help of executing button, which is on the top.

Query and Text Editors used to write and execute queries and scripts. Once you write the query, execute it with the help of executing button, which is on the top.

List of Queries

Given below are some of the queries which we can create and run in SQL Server Management Studio.

1. Create a Database

In SQL Server Management Studio, the Adventure work is the sample databases to your SQL Server instance. The AdventureWorks since the 2012 version has not seen any significant changes; the only differences between the various versions of AdventureWorks are the name of the database.

Now create a database named Employee by following one of the two methods:

  • Right-click on the database folder in Object Explorer, and then select a new database; the new window gets open, then enter Employee for the field database name and then click ok. The database employee gets created, it can be seen in the Object Explorer.
  • Another method is to right-click your server instance in Object Explorer, and then select New Query or the click the New Query command which is on the top of the tool.

The new query window will open and paste the following T-SQL code snippet:

Code:

USE master
GO
IF NOT EXISTS (
SELECT name
FROM sys.databases
WHERE name = N'Employee'
)
CREATE DATABASE Employee
GO

Now execute the query by selecting the entire query and click Execute or select the entire query and press F5 on your keyboard. After executing the query new database Employee is created and appears in the list of databases in Object Explorer. Right-click the Databases node, and then select Refresh, If it doesn’t appear.

2. Create a Table in the New Database

Next, create a table in the newly created Employee database. To create a table in the Employee database switch the connection context to the Employee database, as the query editor is still in the context of the master database, by executing the following statements.

  • — Create a new table called ‘Empdetails’ in schema ’emp’.
  • — Create the table in the specified schema.

Code:

CREATE TABLE emp. Empdetails
(
Emp-Id        INT    NOT NULL   PRIMARY KEY, -- creating a primary key column
Emp-name      [NVARCHAR](20)  NOT NULL,
Emp-location  [NVARCHAR](20)  NOT NULL,
Email     [NVARCHAR](20)  NOT NULL
);
GO

After executing the query, the new Empdetails table is created and displayed in the list of tables in Object Explorer under the Employee database.

3. Insert Data into a New Table

  • — Insert data into the table.

Code:

insert into emp.Empdetails(Emp-Id, Emp-name,Emp-location,Email)
values(101,'john','Bangalore','[email protected]')

After executing the query, the new row is inserted into Empdetails table.

4. Select Data from the Table

  • — Create the table in the specified schema.

Code:

select * from emp. Empdetails

After executing the query, all rows with all column is fetch from the Empdetails table.

Recommended Articles

We hope that this EDUCBA information on “install sql server” was beneficial to you. You can view EDUCBA’s recommended articles for more information.

  1. SQL GROUP BY WHERE
  2. SQL Server Versions
  3. sql projects
  4. SQL now
All in One Excel VBA Bundle
500+ Hours of HD Videos
15 Learning Paths
120+ Courses
Verifiable Certificate of Completion
Lifetime Access
Financial Analyst Masters Training Program
1000+ Hours of HD Videos
43 Learning Paths
250+ Courses
Verifiable Certificate of Completion
Lifetime Access
All in One Data Science Bundle
1500+ Hour of HD Videos
80 Learning Paths
360+ Courses
Verifiable Certificate of Completion
Lifetime Access
All in One Software Development Bundle
3000+ Hours of HD Videos
149 Learning Paths
600+ Courses
Verifiable Certificate of Completion
Lifetime Access
Primary Sidebar
All in One Data Science Bundle1500+ Hour of HD Videos | 80 Learning Paths | 360+ Courses | Verifiable Certificate of Completion | Lifetime Access
Financial Analyst Masters Training Program1000+ Hours of HD Videos | 43 Learning Paths | 250+ Courses | Verifiable Certificate of Completion | Lifetime Access
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Database Management
  • Machine Learning
  • All Tutorials
Certification Courses
  • All Courses
  • Data Science Course - All in One Bundle
  • Machine Learning Course
  • Hadoop Certification Training
  • Cloud Computing Training Course
  • R Programming Course
  • AWS Training Course
  • SAS Training Course

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA
Free Data Science Course

Hadoop, Data Science, Statistics & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more