7  SQL Components

Structured Query Language: SQL

7.1 SQL Components

1. Data Definition Language (DDL) deals with database schemas and descriptions

2. Data Manipulation Language (DML) deals with data manipulation to store, insert, modify, delete and update data in database

3. Data Control Language (DCL) includes commands concerned with rights, permissions and other controls of the database system

4. Data Query Language (DQL) includes querying, fetching and viewing the data

5. Transaction Control Language (TCL) to confirm transaction principles

---