SQL

There are three sets of SQL statements:

• DDL
  Data Definition Language
• DCL
  Data Control Language
• DML
  Data Manipulation Language

DDL statements define or alter objects.

Some DDL commands are:

• create table
• create view
• alter table
• ...

DCL statements are used to grant and revoke access to database objects and change ownership of those objects from one user to another.

Some of the DCL statements are:

• GRANT
• REVOKE

DML statements alters (manipulates) data in the database.

Some of the DML statements are:

• INSERT
• UPDATE
• DELETE