Data Definition Language(DDL) – It is used to define the structure of a table.
Data Definition Language is used to specify the definitions of Database Schema. The result of the compilation of DDL statements is a set of tables stored in a special file called data dictionary.
DDL Commands are Create table, Alter table and Drop table.
Data Manipulation Language(DML) – It is used to add, retrieve, modify and delete records in a data base. It is a language that enable users to access or manipulate data in the database. It also provides interfaces with programming languages.
DML Commands are select, insert, update and delete
