(http://www.intuit.ru/department/database/sqlmdintro/, http://www.intuit.ru/department/database/sql/)
SQL
SQL . , - (DBMS - DataBase Management System). . ( ). c - Oracle, Microsoft SQL Server, Informix, DB2, InterBase, Access, MySQL - , SQL.
1986 , ISO (International Organization for Standardization) ANSI (American National Standards Institute) SQL, : SQL86, SQL89, SQL92 SQL99.
SQL86 SQL.
SQL89 1989 . SQL, , SQL89. , . , , SQL, SQL89 SQL ( ) SQL .
SQL92.
SQL99, SQL3, SQL SQL. , Oracle, - .
SQL :
SQL.
SQL.
SQL.
SQL.
SQL SQL-. . , Oracle SQL*Plus, SQL-.
SQL SQL SQL. SQL .
SQL SQL .
SQL SQL (, ++).
SQL
SQL :
, SQL;
|
|
;
.
SQL :
DDL (Data Definition Language);
DML (Data Manipulation Language).
, . , , . , , . , Oracle, , , . , SQL92 "" .
, .
DML :
- SELECT - ;
- INSERT - ;
- DELETE - ;
- UPDATE - .
SQL , , , "" "", "" - "", "" - "" "".
SQL, , . , , SQL . .
SQL . , SQL.