filmov
tv
What is SQL ? What are Main Types of SQL Statements / Commands

Показать описание
What is SQL?
SQL (Structured Query Language) is a language used to store, manipulate, and retrieve data in databases.
Main Types of SQL Statements / Commands:
Command Type Purpose Example
DDL
(Data Definition Language) Define or modify database structure - CREATE
- ALTER
- DROP
- TRUNCATE
DML
(Data Manipulation Language) Manage data in the database - INSERT
- UPDATE
- DELETE
DQL
(Data Query Language) Fetch data from the database - SELECT
DCL
(Data Control Language) Set permissions - GRANT
- REVOKE
TCL
(Transaction Control Language) Manage transactions - COMMIT
- ROLLBACK
- SAVEPOINT
SQL (Structured Query Language) is a language used to store, manipulate, and retrieve data in databases.
Main Types of SQL Statements / Commands:
Command Type Purpose Example
DDL
(Data Definition Language) Define or modify database structure - CREATE
- ALTER
- DROP
- TRUNCATE
DML
(Data Manipulation Language) Manage data in the database - INSERT
- UPDATE
- DELETE
DQL
(Data Query Language) Fetch data from the database - SELECT
DCL
(Data Control Language) Set permissions - GRANT
- REVOKE
TCL
(Transaction Control Language) Manage transactions - COMMIT
- ROLLBACK
- SAVEPOINT