MySQL

1. DDL
Data Defination Launguage

CREATE
     -To Create database and its objects like table/index/view/store procedure/function/triggers

ALTER
    -Alters the structure of existing database

DROP
     -Delete the object from database


TRUNCATE
     - Removes all records from tables

COMMENT
   - Add comment to data disctionary

RENAME
  -Rename and object

2. DML
Data Manipulation Language

SELECT
-Retrieve date from  database

INSERT
-Insert data into table

UPDATE
-Update existing data within table


DELETE
-Delete all records from database table

3.DCL
Data Control Language

GRANT
-Allow user access privileges to  databases

REVOKE
-Withdraw user access privileges given by using GRANT command

4.DQL
Data Query Language

SELECT
SHOW
HELP

5.DTL
Data Transaction Launguage

START TRANSACTIONS, SAVEPOINT  COMMIT, ROLLBACK