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
0 Comment to "How to create a database on SQL Server management studio? A tutorial."
Post a Comment