SQL

SQL (Structured Query Language) is the standard language for storing, retrieving, and managing data in a relational database. You use it to ask questions of your data and to add, change, or delete records.

SQL

SQL is used by virtually every relational database system, including PostgreSQL, MySQL, SQLite, SQL Server, and Oracle. While each system adds its own extras, the core commands like SELECT, INSERT, UPDATE, and DELETE work almost the same everywhere.

SQL is often described as a declarative language: you describe what data you want, not the step-by-step instructions for getting it. The database engine figures out the most efficient way to fulfill your request.

Examples

SQL

SELECT name, age FROM users WHERE age >= 18;

Output:

name    age
------  ---
Alice   30
Bob     22

Learn it in a lesson

See also

Back to the Dictionary