SQL (Structured Query Language) is essential for interacting with relational databases. Here are core commands categorized for clarity:

DDL - Data Definition Language 🛠️

  • CREATE
    CREATE TABLE users (id INT, name VARCHAR(255));

    sql_create_table
    *Use to define database structure*

  • ALTER
    ALTER TABLE users ADD COLUMN email VARCHAR(255);

    sql_alter_table
    *Modify existing tables*

  • DROP
    DROP TABLE users;

    sql_drop_table
    *Delete tables*

DML - Data Manipulation Language 📝

  • SELECT
    SELECT name FROM users WHERE age > 18;

    sql_select_query
    *Retrieve data*

  • INSERT
    INSERT INTO users (name, age) VALUES ('Alice', 25);

    sql_insert_data
    *Add new records*

  • UPDATE
    UPDATE users SET age = 30 WHERE id = 1;

    sql_update_record
    *Modify existing data*

  • DELETE
    DELETE FROM users WHERE id = 1;

    sql_delete_record
    *Remove records*

🔗 Expand Your Knowledge

Explore advanced SQL concepts or learn database design principles to deepen your understanding.