Monday 6 March 2017

How to create a database on SQL Server management studio? A tutorial.

SQL stands for Structured Query Language. SQL is used to communicate with a database. SQL statements are used to perform tasks such as update data on a database, or retrieve data from a database. Some common relational database management systems that use SQL are Oracle, Sybase, Microsoft SQL Server, Access etc. Although most database systems use SQL, most of them also have their own additional proprietary extensions that are usually only used on their system.

SQL code is divided into four main categories:
  • Queries are performed using  SELECT statement, which is further divided into clauses, including SELECT, FROM, WHERE and ORDER BY.
  • Data Manipulation Language (DML) is used to add, update ,select or delete data like SELECT,UPDATE,INSERTE, DELETE commands
  • Data Definition Language (DDL) is used for managing tables and index structures. Examples of DDL statements include CREATE, ALTER, TRUNCATE and DROP.
  • Data Control Language (DCL) is used to assign and revoke database rights and permissions. Its main statements are GRANT and REVOKE.

Here is a tutorial for how to create a database on sql server management studio

First you have to select server type which is database engine  and then you have to  type your computer name on server name . if you don’t know your pc name then go to mycomputer then right click on it and then select properties .if you give windows authentication then there is no need to type user name or password but if you select sql server authentication then you must have to type login or password after that click on connect button.

Right click on database and select new database

Give database name and then press ok button.

Your database is created.

Written by,
Rameeshah Shahid

Share this

See All Articles

0 Comment to "How to create a database on SQL Server management studio? A tutorial."

Post a Comment