Every database management system has specific languages and interfaces that help to execute database queries and modifications. Usually, Structured Query Language (SQL) is used by various DBMSs to read, store and modify data within a database.
Types of DBMS languages:
DDL (Data Definition Language): As the name suggests it is used to define a database or its structure. It is used to create tables, schema, or defining integrity constraints on the data. Various commands under DDL are: create, alter, merge and drop.
DML (Data Manipulation Language): DML is used to modify the data within a database as per the user's requests. Insert, update and delete commands used to perform modifications on the data.
DRL (Data Retrieval Language): It is used to retrieve or access data from the database using select command.
TCL (Transaction Control Language): This is generally used for transactions related data. TCL is used to execute the modifications done by DML statements such as commit and rollback of data.