Scribd
Upload
62 views16 pages

Team:B.TECH (CSE 2018-2022) Channel:DBMS: by Navdeep Kaur Assistant Professor Computer Science Department

The document discusses the different types of database languages: 1) Data Definition Language (DDL) is used to define the database structure and schema. It includes commands like CREATE, ALTER, and DROP. 2) Data Manipulation Language (DML) handles user requests to retrieve and manipulate data using commands like SELECT, INSERT, UPDATE, and DELETE. 3) Data Control Language (DCL) deals with user permissions and privileges using GRANT and REVOKE. 4) Transaction Control Language (TCL) controls transactions with commands like COMMIT, ROLLBACK, and SAVEPOINT.

Uploaded by

Vijay Pal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
62 views16 pages

Team:B.TECH (CSE 2018-2022) Channel:DBMS: by Navdeep Kaur Assistant Professor Computer Science Department

The document discusses the different types of database languages: 1) Data Definition Language (DDL) is used to define the database structure and schema. It includes commands like CREATE, ALTER, and DROP. 2) Data Manipulation Language (DML) handles user requests to retrieve and manipulate data using commands like SELECT, INSERT, UPDATE, and DELETE. 3) Data Control Language (DCL) deals with user permissions and privileges using GRANT and REVOKE. 4) Transaction Control Language (TCL) controls transactions with commands like COMMIT, ROLLBACK, and SAVEPOINT.

Uploaded by

Vijay Pal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
You are on page 1/ 16

Team:B.

TECH (CSE 2018-2022)


Channel :DBMS

Data Base Languages


By Navdeep Kaur
Assistant Professor
Computer Science Department
Data Base Language
Data Base Language

The database language by the use of which we


can perform certain operations on the existing
database and also we can use this language to
create a database.
Data Base Language

Example of Data Base Language : Structured


Query Language(SQL)
Data Base Language
Data Base Language Types
Types of Data Base Language

 Data Definition Language


 Data Manipulation Language
 Data Control Language
 Transaction Control Language
Data Definition Language

DDL stands for Data Definition Language. It is used to define


database structure or pattern.
 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.
 Using the DDL statements, you can create the skeleton of the
database.
 Data definition language is used to store the information of
metadata like the number of tables and schemas, their names,
indexes, columns in each table, constraints, etc.
Data Definition Language

 Create: It is used to create new database or Table .


 Alter: It is used to alter the structure of the exsisting
database.
 Drop: It is used to drop table from database.
 Truncate: It is used to remove all records from a table.
 Rename: It is used to rename DataBase or Table
 Comment: It is used to comment on the data dictionary.
Data Manipulation Language

DML stands for Data Manipulation Language. It
is used for accessing and manipulating data in
a database. It handles user requests.
Data Manipulation Language

Here are some tasks that come under DML:


 Select: It is used to retrieve data from a database.
 Insert: It is used to insert data into a table.
 Update: It is used to update existing data within a table.
 Delete: It is used to delete all records from a table.
 Merge: It performs UPSERT operation, i.e., insert or update
operations.
Data Control Language

DCL(Data Control Language) : DCL includes commands such as


GRANT and REVOKE which mainly deals with the rights,
permissions and other controls of the database system.
Data Control Language

Here are some tasks that come under DCL:


 Grant: It is used to give user access privileges to a database.
 Revoke: It is used to take back permissions from the user.
Transaction Control Language

 TCL commands deal with the transaction within


the database.
Transaction Control Language

 COMMIT– commits a Transaction.


 ROLLBACK– rollbacks a transaction in case
of any error occurs.
 SAVEPOINT–sets a savepoint within a
transaction.
 SET TRANSACTION–specify characteristics
for the transaction.
Be Passionate and Be creative

You might also like