Forum Discussion
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, update, and delete data efficiently.
Features of SQL
Easy to learn and use.
Used to manage large amounts of data.
Supports data retrieval, insertion, updating, and deletion.
Provides security through user permissions.
Works with popular database systems like MySQL, PostgreSQL, Oracle, SQL Server, and SQLite.
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.
3 Replies
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.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.