Table of Contents
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.
Types of Database Languages in DBMS
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.
Please provide your feedback or leave comment so that we can improve and provide you a good quality tutorials
If you find this database languages with example tutorial useful then please Like and Share the post on Facebook, Twitter, Linkedin through their icons as given below.
Previous Tutorial – Data Independency in DBMS
Next Tutorial – Entity Relationship Diagram