- , . , , .
, , . , .
, , , .
27. .
(). () Database Administrator (DBA).
28. .
́ ́ (. Data Warehouse) - , - . .
29.- .- .
- () (), , - : , .
- , , Oracle Database, Informix, DB2, PostgreSQL.
- () , [1], , [2
30. SQL . SQL. SQL.
1. , , SQL , , .. SQL .
2. SQL , , , , , ( ) .
(Interactive) (Embedded). , , .
|
|
|
SQL , . SQL, , , ( ) .
SQL SQL, , ( ). . , , SQL , SQL. SQL SQL (" passed off ") .
SQL :
- (Data Manipulation Language, DML)
- (Data Definition Language, DDL)
- (Data Control Language, DCL).
, , . .
, , . 4 :
| SELECT | () |
| INSERT | () |
| UPDATE | () |
| DELETE | () |
- , , ( ), . :
| CREATE DATABASE | ( ) |
| CREATE TABLE | ( ) |
| CREATE VIEW | ( ) |
| CREATE INDEX | ( ) |
| CREATE TRIGGER | ( ) |
| CREATE PROCEDURE | ( ) |
| ALTER DATABASE | ( ) |
| ALTER TABLE | ( ) |
| ALTER VIEW | ( ) |
| ALTER INDEX | ( ) |
| ALTER TRIGGER | ( ) |
| ALTER PROCEDURE | ( ) |
| DROP DATABASE | ( ) |
| DROP TABLE | ( ) |
| DROP VIEW | ( ) |
| DROP INDEX | ( ) |
| DROP TRIGGER | ( ) |
| DROP PROCEDURE | ( ) |
. " ". :
| GRANT | ( ) |
| REVOKE | ( ) |
SQL:
- SQL
- SQL.
