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
Post A Comment:
0 comments: