SQL을 다루는 3가지 큰 축

1) DDL(Data Definition Language)

• 테이블/인덱스/제약조건 정의
• CREATE, ALTER, DROP

DDL

2) DML(Data Manipulation Language)

• 데이터 조작
• SELECT, INSERT, UPDATE, DELETE

DML

JOIN

Subquery

DISTINCT

CASE / IF

3) TCL(Transaction Control Language)/

DCL(Data Control Language)

• 트랜잭션, 권한
• COMMIT, ROLLBACK
• GRAND, REBOKE

TCL

DCL