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 would like to inquire whether have you got the chance to check the solutions provided above in commiunity to resolve the issue. We hope the information provided helps to clear the query. Should you have any further queries, kindly feel free to contact the Microsoft Fabric community.