Structured Query Language
Chapter 6
Contents
2
1
Introduction of Structured Query Language
2
DDL:
create, drop, alter
3
DML: select, insert, update, delete
4
DCL: commit, rollback, grant, revoke
Contents
3
1
Introduction of Structured Query Language
2
DDL:
create, drop, alter
3
DML: select, insert, update, delete
4
DCL: commit, rollback, grant, revoke
Introduction of Structured Query Language
4
Structured Query Language (SQL) is a standard
computer language for relational database
management and data manipulation.
Basic SQL:
Data Definition Language (DDL)
Create, Alter, Drop
Data Manipulation Language (DML)
Select, Insert, Update, Delete
Data Control Language (DCL)
Commit, Rollback, Grant, Revoke
Contents
5
1
Introduction of Structured Query Language
2
DDL: create, drop, alter
3
DML: select, insert, update, delete
4
DCL: commit, rollback, grant, revoke