SQL

concept · part of Databases

A standardized language for managing relational databases, supporting querying, updating, inserting, and deleting data.

Inside SQL (12)

DML — Data Manipulation Language commands such as INSERT, UPDATE, DELETE, COPY INTO that can be executed by stored procedures.
ACID — A set of properties (Atomicity, Consistency, Isolation, Durability) that guarantee reliable processing of database transactions.
CALL — The SQL command used to invoke a stored procedure as a standalone statement.
DDL — Data Definition Language commands such as CREATE, ALTER, DROP, SHOW, USE that can be executed by stored procedures.
DROP TABLE — A SQL command to remove a table from the database.
GROUP BY — An SQL clause to group rows sharing a column value into summary rows, used with aggregate functions.
Indexing — A database optimization technique using a sorted pointer copy of a column to speed up reads at the cost of slower writes.
JOIN — An SQL operation to combine rows from multiple tables based on a related column.
ORDER BY — An SQL clause to sort the result set by one or more columns.
SELECT — An SQL operation to retrieve specific columns from a table.
SHOW TABLES — A SQL command to list tables and their metadata in a schema or account.
WHERE — An SQL clause to filter rows based on a condition.

This is the text view of an interactive 3D knowledge graph — open this page with JavaScript enabled to explore it visually.