Types of Database languages
We need a method to create all the logical objects like tables, views, procedures and packages in the database and we need some interface between the user and the database, so that we can access the data stored in it. We also need a standardized method to organize these tables and views in the database.
DBMS is software that defines different operations to be carried out in the database. It varies from creating a database, tables, index, constraints to manipulating the data in the database like inserting, deleting, updating, retrieving, sorting etc. In order to perform all these operations, DBMS defines two forms of database languages.
Below are the database languages. Click them for more details.
DDL | Data Definition Language |
DML | Data Manipulation Language |
DCL | Data Control Language |
TCL | Transaction Control Language |