SQL: Definition

SQL (Structured Query Language) is the most database language commonly used. Big brands such as Oracle, MS SQL, MySQL, IBM DB2, and Microsoft Access use this language for their database engine (of course with a little tweak here and there on their own).

SQL is categorized into 3 subset:

1. DML (Data Manipulation Language) - The one responsible for manipulating data on the database. Its syntax extend to SELECT, INSERT, UPDATE, and DELETE.
   
2. DDL (Data Definition Language) - The one responsible for creation of the database objects, such as tables, index, primary and foreign keys. The syntax extend to CREATE, ALTER, and DROP.
   
3. DCL (Data Control Language) - The one responsible for managing access of the database. The syntax extends to GRANT and DENY.