subsets of sql

11- Data Manipulation Language(DML)-(SELECT, INSTERT, UPDATE...)
2DML statements affect records in table. These are
3basic operations we perform on data such as selecting
4few records from a table, inserting new records,
5deleting unnecessary records, updating existing records.
6
72-Data Definition Language (CREATE , ALTER , DROP)...
8DDL statements are used to modify database or
9table schema. These statements handle the design
10and storage of database objects.
11
123-Data Control Language (GRANT , REVOKE)...
13DCL statements control the level of access that
14users have on database objects
15
164- Transaction Control Language (BEGIN TRAN, COMMIT TRAN, ROLLBACK)...
17
18TCL statements allows us to control and manage
19transactions to maintain the integrity of data
20withing SQL statements.