SQL Server for Beginners : Part 2

In previous article we get to know about SQL Server. In this article, we are going to learn more about SQL Server Management Studio (SSMS).

SQL Server Management Studio (SSMS) is the tool acting as an interface for SQL Server. It provides a Graphical user interface for connecting and managing the SQL Server.

You can download SQL Server Management Studio from the link given below : https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15

After installation of SSMS you may check that your SQL Server Engine service is running or stopped. It should be in running state for successful operation of SQL Server.

For that you have to open Control Panel → Administrative Tools → Services and look for ‘SQL Server’. It shows that your SQL server service is running or stopped.

After checking the service status, first you have to connect to SQL database engine through SSMS’s User Interface to use SQL server. The first window opened as you launch SSMS is shown below.

To create a database go to Object Explorer → Databases (Right click) → New Database. After there steps, following window will pop up where we have to fill database name, owner and other details.

Once a database is created, to add a table in it, select Table from database and add fill the details for columns required as column name, datatype, allow null or not.

For storing values into the columns of the table, select ‘Edit Top 200 Rows’ and you can store the data in appeared table structure having the same columns which we had set earlier. Then our provided data will be stored in the table.

To show the data stored in the table, we have execute following query in Query editor and output will be shown in a window below.

To understand more about SQL Server watch the video given below :

Thank You..!