SQL Review

DDL( Data definition language)

Works in object level. Bringing objects to existence. Can be tables, views, sequences ect. .

• Create
• Alert
• Drop 
• Rename
• Truncate

DML ( Data manipulation language)

Works with already existence objects. DDL get the tables and DML populate the tables.

• Select
• Insert
• update
• Delete
• Call
• Explain call

DCL

• Grant
• Revoke

TCL

• Commit
• Rollback