- 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. EFCodd in 1968ANSI (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)
No comments:
Post a Comment