Step Snap 1: [Understanding SQL Basics: DDL vs DML]

1. What is DDL (Data Definition Language)?

"Think of DDL as the architect of your database - it designs and builds the structure"

Core Commands:

• CREATE - Build new objects
• ALTER - Modify structure
• DROP - Remove objects
• TRUNCATE - Clear data
• RENAME - Change names

Example:

-- DDL Example: Creating a structure
CREATE TABLE employees (
    id INT,
    name VARCHAR(50),
    department VARCHAR(50)
);

2. What is DML (Data Manipulation Language)?

"Think of DML as the interior designer - it handles everything inside the structure"

Core Commands:

• SELECT - Query data
• INSERT - Add new data
• UPDATE - Modify data
• DELETE - Remove data

Example:

-- DML Example: Working with data
INSERT INTO employees VALUES (1, 'John', 'IT');
SELECT * FROM employees;