SQL Commands

DDL (Data Definition Language)

• Create:

CREATE TABLE employees (
    employee_id INT PRIMARY KEY,
    first_name VARCHAR(50),
    last_name VARCHAR(50),
    hire_date DATE,
);

• Alter:

ALTER TABLE employees
ADD COLUMN email VARCHAR(100);

• Drop:

DROP TABLE employees;

DCL (Data Control Language)

• Grant:

GRANT SELECT, INSERT ON employees TO user_name;

• Revoke"

REVOKE SELECT, INSERT ON employees FROM user_name;

• Deny:

DENY SELECT, INSERT ON employees TO user_name;

DML (Data Manipulation Language)

• Select:

SELECT * FROM employees;

• Insert:

INSERT INTO employees (employee_id, first_name, last_name, hire_date)
VALUES (1, 'John', 'Doe', '2024-01-15');

• Update:

UPDATE employees
SET email = 'john.doe@example.com'
WHERE employee_id = 1;

• Delete:

DELETE FROM employees
WHERE employee_id = 1;