SQL Sub-Sets

1.       Querying the database- SELECT statements are used to retrieve the data from tables.

Example – Various SELECT statements.

2.       DML –

ü  Data Manipulation Language.

ü  It is considered as sub language of SQL.

ü  As name suggests the statements under this category is used to manipulate the data stored in a table.

ü  There are 4 commonly statements  under this category-

INSERT

UPDATE

DELETE

MERGE

3.       DDL –

ü  Data Definition Language.

ü  It is also considered as sub language of SQL.

ü  As name suggests the statements under this category is used to create, modify and remove the table or other objects in a database.

ü  There are 3 commonly statements falls under this category-

CREATE

ALTER

DROP

4.       DCL –

ü  Data Control Language.

ü  It is also considered as sub language of SQL.

ü  As name suggests the statements under this category is used to control (access/deny) the data objects.

ü  There are 2 commonly statements falls under this category-

GRANT

REVOKE

5.       TCL –

ü  Transactional Control Language.

ü  It is also considered as sub language of SQL.

ü  As name suggests the statements under this category is used to initiating, committing or rollback of a transaction.

ü  The main statements Which falls under this category

BEGIN TRANSACTION

COMMIT

ROLLBACK

As we proceed I will provide all the queries.