SQL Mindmap : Dive Deep into SQL

 SQL Mindmap

Dive Deep into SQL

DDL (Data Definition Language): Commands like CREATE, DROP, TRUNCATE, and ALTER.

DML (Data Manipulation Language): Commands like SELECT, INSERT, UPDATE, and DELETE.

DCL (Data Control Language): Commands like GRANT and REVOKE.

TCL (Transaction Control Language): Commands like COMMIT, ROLLBACK, and SAVEPOINT.

Aliases: Using AS to rename columns or tables.

GROUP BY and ORDER BY: Organizing data with GROUP BY and sorting it with ORDER BY ASC/DESC.

JOINs: Combining tables using INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

Functions: Aggregate functions like AVG(), SUM(), COUNT(), MIN(), and MAX().

Window Functions: Commands like OVER(), ROW_NUMBER(), RANK(), and others for advanced queries.

Logical Operators: Including AND, OR, NOT, BETWEEN, and more.