Database Languages

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
Translate »