Categories of SQL Commands

Categories of SQL Commands

1.Data definition language Statements: A Data Definition Language or Data Description Language (DDL) is a Computer language for defining Data Structures. Set of SQL commands used to Create, modify and Delete database structures.Commands like Create,Alter and Drop

2, Data manipulation language (DML) statements: Data Manipulation Language (DML) is a Set of SQL commands used to insert, delete and update data in a database. Command:Insert Into, Delete and Update

3. Data Query Language: SQL command to retrieve data from database.Command: Select

4. DCL (Data Control Language): Data Control Language (DCL) is used to control access to data in a database.Grant and revoke

5. Transaction Control Language: Transaction Control Language (TCL) is used to control transaction processing in a database.Commit, Rollback and Savepoint

Design a site like this with WordPress.com
Get started