Basic Introduction of SQL Server With Example

 SQL=Pronounced "ess-que-el" (Structure query language) is a language that provide interface to RDBMS(Relational Data Base Management System).

SQL is none procedural language.It is used to communicate with database.It is used to perform the task such as insert, update, Delete,and other activities from database.SQL is reducing timing creating and maintaining systems.

There are following Type

1-DDL(Data Definition Language)

*Create

*Alter

*Drop

*Trancate

*Comment

2-DML(Data Manipulation Language)

*Insert

*Update

*Delete

*Lock Table

3-DCL(Data Control Language)

*Commit

*Savepoint

*Grant/Revoke

*Set of Instruction

4-DQL(Data Query Language)

*Select

*Datatypes

*Char

*number

*date

*Long