Forum Discussion
undefined
- 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.
Hi tanziyaashaq
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.
Thank you.