Pr.Pg Next Pg

What is SQL? tutorials

 

·         SQL stands for Structured Query Language.

·         SQL can be pronounced "ess-que-el" or many developers simply say “sequel”. In any case both pronunciations are ok.

·         Originally developed in the System-R project of IBM (1974)

·         Industry standard for relational databases (SQL92 is an ANSI/ISO standard)

·         SQL is used to communicate with a database.

·         It is the standard language for relational database management systems.

·         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, Ingres, etc.

·         SQL is made up three sub-languages DDL, DML, DCL

·         DDL- Data Definition Language for defining relations, views, integrity constraints, triggers.

·         DML- Data Manipulation Language for updating, and querying

·         DCL- Database Control Language for defining access rights, concurrency control, etc….


 

Pr.Pg border                                              Next Pg