SQL can be divided into four different parts: 

1. Data Manipulation Language ( DML):
It is used to retrieve, store, modify, delete, insert and update data in the database. Examples: SELECT, UPDATE, INSERT statements

2. Data Definition Language ( DDL):
It is used to create and modify the structure of database objects in the database. Examples: CREATE, ALTER, DROP statements

3. Data Control Language ( DCL):
It is used to create roles, permissions, and referential integrity as well it is used to control access to the database by securing it. Examples: GRANT, REVOKE statements

4. Transactional Control Language ( TCL).
It is used to manage different transactions occurring within a database. Examples: COMMIT, ROLLBACK statements


Mukesh Rajput

Mukesh Rajput

I am a Computer Engineer, a small amount of the programming tips as it’s my hobby, I love to travel and meet people so little about travel, a fashion lover and love to eat food, I am investing a good time to keep the body fit so little about fitness also..

Post A Comment:

0 comments: