1.DDL – Data Definition Language.DDL is used to define the structure that holds the data.
2.DML– Data Manipulation Language
DML is used for manipulation of the data itself. Typical operations are Insert, Delete,Update and retrieving the data from the table
3.DCL–DataControlLanguage DCL is used to control the visibility of data like granting database access and set privileges to create table etc.
4.TCL-TransactionControl Language