Forum Discussion

tanziyaashaq's avatar
tanziyaashaq
Icon for Advocate IV rankAdvocate IV
1 month ago
Solved

undefined

SQL (Structured Query Language) SQL (Structured Query Language) is a standard programming language used to communicate with and manage relational databases. It allows users to store, retrieve, updat...
  • v-csrikanth's avatar
    1 month ago

    Hi  tanziyaashaq 
    Thanks for sharing this overview on SQL. It's a nice, beginner-friendly summary of what SQL is and why it matters.
    Just to build on it a bit for anyone new who check this post:

    • SQL is typically grouped into a few sub-languages, which helps clarify what each command actually does:
    • DDL (Data Definition Language) — CREATE, ALTER, DROP — defines the structure (tables, schemas, indexes).
    • DML (Data Manipulation Language) — SELECT, INSERT, UPDATE, DELETE — works with the data itself.
    • DCL (Data Control Language) — GRANT, REVOKE — handles the permissions/security piece you mentioned.

    TCL (Transaction Control Language) — COMMIT, ROLLBACK, SAVEPOINT — manages transactions.

    ---------------------------------------------------------------
    A simple example:
    CREATE TABLE Customers (

    Id INT PRIMARY KEY,
    Name VARCHAR(100),
    City VARCHAR(50)

    );

    INSERT INTO Customers VALUES (1, 'Alice', 'Seattle');

    SELECT Name, City
    FROM Customers
    WHERE City = 'Seattle';


    ---------------------------------------------------------------

    If anyone wanting to go deeper, the official docs are the best starting point:


    Thanks 
    Srikanth Cheri.