SQL DML & DDL

SQL Data Manipulation Language (DML):
DML is a syntax for executing queries and DML component of SQL comprises have four basic statements:
SELECT - Retrieve rows from tables
UPDATE - Modify the rows of tables
DELETE - Remove rows from tables
INSERT - Add new rows to tables.

SQL Data Definition Language (DDL):
DDL is used to create and destroy databases, database table and database objects. These commands will primarily be used by database administrators during the setup and removal phases of a database project. DML component of SQL comprises have four basic statements:
CREATE - Creates a new database table
ALTER - Alters / changes a database table
DROP - delete a database table