SQL (Structured Query Language)

Can be categorized into several sub-languages:

1. Data Query Language (DQL)
   • Purpose: Querying and retrieving data from the database
   • Key Commands: SELECT
2. Data Definition Language (DDL)
   • Purpose: Defining and modifying database schema and structure.
   • Key Commands: CREATE, ALTER, DROP, TRUNCATE
3. Data Manipulation Language (DML)
   • Purpose: Manipulating data within the database
   • Key Commands: INSERT, UPDATE, DELETE
4. Data Control Language (DCL)
   • Purpose: Controlling access to data within the database
   • Key Commands: GRANT, REVOKE
5. Transaction Control Language (TCL)
   • Purpose: Managing transactions within the database
   • Key Commands: BEGIN TRANSACTION, COMMIT, ROLLBACK