SQL Server for Beginners Part-II

SQL Server Management Studio:

SQL Server is a relational database Management system developed by Microsoft.It is an integrated environment to handle any SQL infrastructure.

• SQL Server Management studio also known as SSMS. The SSMS is an integrated environment to handle any SQL infrastructure. It is free and basically provides a graphical user interface to interact with SQL server.
• The SQL Server management studio are used for create database(db), create table as well as administer your SQL Server configuration.

Tasks perform with SSMS:

• Create and maintain user accounts and roles
• Create and maintain backups ( manual or scheduled)
• Import and export data from/to other databases
• Replicate(creating a copy or also says duplication of data ) databases across multiple machines

Installation of SQL Server Management Studio:

Open the setup and select install.

Accessing Management Studio:

• When you open the SQL server management studio from the start menu, a window will open similar to the window shown in the picture below.

To better understand this concept please do watch the below video.It will resolve your all doubts: