SQL DDL & DML

SQL(Structured Query Language) is a standard programming language used to communicate with, manage and manipulate relational databases.
SQL COMMANDS are the core instructions used to communicate with, manage and manipulate relational databases.

They are 5 types of SQL commands:

1. DDL (Data Definition Language) – Defines databases structure.
2. DQL (Data Query Language) – Retrieves data.
3. DML (Data Manipulation Language) – Modifies data.
4. DCL (Data Control Language) – Manages access permissions.
5. TCL (Transaction Control Language) – Handles database transactions.

DATA DEFINITION LANGUAGE (DDL)
It defines and manages the structure(schema) of your database.
They allow you to create, modify, or delete database objects such as tables, indexes, and views.
They are auto-committed meaning changes are saved permanently and cannot be rolled back in most database engines.

DATA MANIPULATION LANGUAGE (DML)
DML commands manage the records inside the database tables.
Unlike DDL, DML modification can typically be rolled back or undone if they are part of an active transaction before being committed.