SQL in a Nutshell: A Comprehensive Guide.

Fuente: https://www.linkedin.com/feed/update/urn:li:activity:7111293606803435520/

SQL in a Nutshell: A Comprehensive Guide.

Navigating the world of SQL can be daunting, but it doesn’t have to be! Dive into this brief overview of key SQL concepts, commands, and functions:

🔹 Database Operations:

DDL: CREATE, DROP, ALTER
DML: SELECT, INSERT, UPDATE, DELETE
DCL: GRANT, REVOKE
TCL: COMMIT, ROLLBACK, SAVEPOINT

🔹 Database & Table Structures:

Database, Table, Column(s), All Table(*), Field

🔹 Constraints:

Unique, NOT NULL, Primary Key, Foreign Key, Check, Default

🔹 Window Functions:

ROW_NUMBER(), RANK(), DENSE_RANK(), NTILE(), LAG(), LEAD()

🔹 Conditional Functions & Clauses:

WHERE, AND, OR, NOT, BETWEEN, LIKE, IN, ANY, ALL, EXISTS

🔹 Aggregate Functions:

AVG(), SUM(), COUNT(), MIN(), MAX()

🔹 Data Presentation:

Alias (As), GROUP BY, HAVING, ORDER BY (ASC, DESC)

🔹 Joins:

INNER JOIN, FULL JOIN, LEFT JOIN, RIGHT JOIN

🔹 Modifications:

Add, Remove, Modify – Column, Constraints, Data type, Default

Bookmark this post for quick reference and happy querying!

Credits: Brij kishore Pandey