Database Languages with Example

• This database languages in DBMS based tutorial covers the basic concepts of database languages in DBMS.
• Database languages introduction, types of database language such as Data Definition Language and Data Manipulation Languages.
• Different Database Languages Commands are also discussed explained in the DBMS Language tutorial.

Frequently Asked Questions

By the end of this tutorial computer science students will be able to  answer of the following questions –

• What do you understand by database language in dbms?
•  What is data definition language?
• What is data manipulation language?
• What is difference between DDL and DML in DBMS ?
• What are different DDL and DML commands?

Why Database Language ?

Database Languages in DBMS are required because just like human being database management system also need communication languages for proper communication with database.

These Database Languages with example are mainly used to create and maintain database. Along with this database languages are used to read data, store and update information in database. Also known as DBMS Languages.

In Database Management System there are following types of DBMS  languages –

• Data Definition Language
• Data Manipulation Language
• Data Control Language
• Transaction Control Language.

Let’s understand them one by one

Data Definition Language(DDL)

Data Definition Language or DDL is used to define the database schema.

In database, it is used to create tables, constraints, indexes ,schema etc. 

The operations that  can be performed on database using DDL are as follows –

CREATE : It is used to create the database.

ALTER:  It is used to alter the structure of database .

DROP : It is used to  drop objects from database  tables.

TRUNCATE: It is used to delete tables in a database.

RENAME: It is used to rename database instances

COMMENT: It is used to Comment

All of the above queries or commands  either define or update the database therefore they all come under Data Definition language

Data Manipulation Language (DML)

DML is used to access and manipulate data in a database. The operations on database which comes under DML are 

SELECT: It is used to read records from table

INSERT: It is used to insert record(s) into the table

UPDATE: It is used to update the data in table

Delete: It is used to delete all the records from the table

 Data Control language (DCL)

The Data Control Language (DCL) is used for controlling the  privileges in Database. In the database, user need privileges to perform any operation  such as for creating tables, Sequences or Views.

GRANT: It is used to grant access to user

REVOKE: It is used to revoke access from user

Transaction Control Language(TCL)

Transaction Control Language (TCL) is used to manage the transactions of a database. These commands are used to manage the changes made by DML commands. The TCL commands are :

COMMIT – It is used to persist the changes made by DML commands

ROLL BACK – It is used to rollback the changes made to the database.