DBMS Languages

DBMS languages are required to practically implement the design of the database. They are of following types:

DDL (Data Definition Language)

DCL (Data Control Language)

DML (Data Manipulation Language)

TCL (Transaction Control Language)

DDL (Data Definition Language)

DDL is used to store and  access the information of metadata like the number of tables and schemas, their names, indexes, columns in each table, constraints, etc.

Some of the tasks of DDL are: 

Create: 

It is used to create objects in the database.

Alter: 

It is used to alter the structure of the database.

Drop: 

It is used to delete objects from the database.

Rename: 

It is used to rename an object.

Comment: 

It is used to comment on the data dictionary.

DML (Data Manipulation Language)

It is used for accessing and manipulating data in a database.  It handles user requests.

Some of the tasks of DML are: 

Select: 

It is used to retrieve data from a database.

Insert: 

It is used to insert data into a table.

Update: 

It is used to update existing data within a table.

Delete: 

It is used to delete all records from a table.

Call: 

It is used to call a structured query language.