What is SQL?
The Structured
Query Language (SQL) is the set of instructions used to interact with
a relational database. SQL is used to
query, insert, update and modify data. . Most relational databases support SQL.
Whenever you interact with such a database, the software translates your into
SQL statement that the database knows how to interpret.
SQL History:
SQL developed in the early 1970s
at IBM by Raymond Boyce and Donald Chamberlin. In 1979, a company called Relational
Software, which later became Oracle, saw the commercial potential of SQL and
released its own modified version, named Oracle V2. The current standard
SQL version is monitored by the American National Standards Institute (ANSI).
Different
Command Types in SQL:
DDL: Data definition Languages
DML: Data manipulation Language
DCL: Data control Language
TCL: Transaction Control Language