SQL language Type

• Structured Query Language (structured Query Language), abbreviated to SQL, is the core language of database programming.
• The development of SQL began in the 1974, and its development process is as follows:

1. 1974-Presented by Boyce and Chamberlin, then called sequel.
2. 1976-IBM's Sanjase Institute changed to SQL when developing RDBMS SYSTEM R.
3. 1979-Oracle publishes its first SQL-based commercial RDBMS product.
4. 1982-IBM publishes its first RDBMS language sql/ds.
5. 1985-IBM publishes its first RDBMS language DB2.
6. 1986-United States National Standardization Organization ANSI announces SQL as a database industry standard.
7. SQL is a standard database language and a descriptive non-procedural language for collections.

• The ANSI SQL language is divided into six types, namely:

1) DDL (data definition Language): defines the language used to create, modify, and delete objects in the database, such as: databases, data tables, indexes, views, functions, stored procedures, cursors, triggers, schemas, and so on, respectively:

1. Create: Creating
2. Alter: Modify
3. Drop: Delete

2) DML (data Manipulation Language): manipulation language for adding, deleting, and modifying data in data tables, respectively:

1. Insert: Inserting
2. Delete: Remove
3. Update: Updates

3) DQL (data query Language): Queries the language for querying data in a datasheet or view, respectively: SELECT, FORM, WHERE, Oeder by, GROUP by, have, and so on.

4) DCL ( Data Control Language): Control language for controlling the access of users or roles to the database, respectively:

1. Grant: Authorization
2. REVOKE: Revoke Authorization
3. Deny: Deny authorization

5) TPL: The object Processing language , used to control things, to ensure that the data tables affected by DML statements are updated, respectively:

1. SavePoint: Set Save point
2. ROLLBACK: Rolling back things
3. Commit: Commit a thing

6) CCL: pointer Control Language , one or more data tables of the lone operation, respectively: DECLARE CURSOR, FETCH into, UPDATE WHERE the current statement and so on.

SQL language Type