Read, Update, Manipulate, and Store data in a database using Database Languages. The following are the database languages −
Let us begin with Data Definition Language:
The language is used to create database, tables, alter them, etc. With this, you can also rename the database, or drop them. It specifies the database schema.
The DDL statements include −
The language used to manipulate the database like inserting data, updating table, retrieving record from a table, etc. is known as Data Manipulation Language −
Grant privilege to a user using the GRANT statement. In the same way, revoke the privilege using the REVOKE statement. Both of these statements come under the Data Control Language (DCL). −
Manage transactions in the Database using the Transaction Control Language −