It is a non procedural language which is used to communicate with any database such as Oracle, sqlserver etc.
This Language was developed by the German Scientist Mr. E.F.Codd in
1968
ANSI (American National Standard Institute) approved this concept and in
1972 sql was released into the market
Features of SQL:
SQL is not a case sensitive language it means that all the commands of Sql are not case sensitive
Every command of sql should ends with a semicolon (;) (It is exemption for
SQL Server)
SQL can be pronounced as Sequel (Structured English Query Language)
SQL can be called as Common Language Interface, which is used to communicate with any type of database
SQL can be called as NLI (Natural Language Interface). It means that all the
SQL Commands are almost similar to normal English language
Structured query language is mainly divided into 4 sub languages
1. DDL (Data Definition Language)
2. DML (Data Manipulation Language)
3. TCL (Transaction Control Language)
4. DCL(Data Control Language) SQL
DROP
SELECT
COMMIT GRANT
SP_RENAME
UPDATE
ROLLBACK REVOKE
CREATE
DELETE
SAVE TRANSACTION
ALTER
INSERT
TRUNCATE
0 comments:
Post a Comment