Q47607

Also known as Structural Query Language, sql

Structured Query Language (SQL) (pronounced S-Q-L; or alternatively as "sequel") is a domain-specific language used to manage data, especially in a relational database management system (RDBMS). It is particularly useful in handling structured data, i.e., data incorporating relations among entities and variables.

AI overview

SQL is a specialized computer language used to organize, retrieve, and manage data stored in databases, particularly those that organize information into related tables. It's widely important because most businesses and organizations rely on databases to store and access their critical information, making SQL an essential tool for anyone working with data.

AI-generated from the Wikipedia summary — may contain errors.

Key facts

Programming language.name: SQL (Structured Query Language)
Programming language.paradigm: Declarative
Programming language.family: Query language
Programming language.designer: Donald D. ChamberlinRaymond F. Boyce
Programming language.developer: ISO/IEC JTC 1 (Joint Technical Committee 1) / SC 32 (Subcommittee 32) / WG 3 (Working Group 3)
Programming language.typing: Static, strong
Programming language.implementations: Many
Programming language.influenced: CQL, LINQ, SPARQL, SOQL, PowerShell, JPQL, jOOQ, N1QL, GQL
Programming language.latest_release_version: SQL:2023
Programming language.influenced_by: Datalog
Programming language.operating_system: Cross-platform
Programming language.wikibooks: Structured Query Language
File format.name: SQL (file format)
File format.extension: .sql
File format.mime: application/sql
File format.owner: ISO/IEC
File format.genre: Database
File format.standard: ISO/IEC 9075

via Wikipedia infobox

Official website

ISO/IEC 9075-1:2023 - Information technology — Database languages SQL — Part 1: Framework (SQL/Framework)

Information technology — Database languages SQL — Part 1: Framework (SQL/Framework)

iso.org →

Link to the official site · 9,859 chars · not written by Vinony

Wikidata facts

Official name: SQL
Official website: www.iso.org/standard/76583.html
Image: SQL ANATOMY wiki.svg

Show 10 more facts

media type: application/sql
IPA transcription: ˈsiːkwəl
Stack Exchange tag: stackoverflow.com/tags/sql
inception: 1974-00-00
short name: SQL
Commons category: Structured Query Language
file extension: sql
publication date: 1986-00-00
software version identifier: SQL:2023
P13411: sea

Sources (11)

via Wikidata · CC0

~20 min read

Article

23 sections

Contents

History
Interoperability and standardization
Overview
Reasons for incompatibility
Standardization history
Current standard
Syntax
Procedural extensions
Alternatives
Distributed SQL processing
Criticisms
Design
Orthogonality and completeness
Null
Duplicates
Impedance mismatch
SQL data types
Predefined data types
See also
Notes
References
Sources
External links

Introduced in the 1970s, SQL offered two main advantages over older read–write APIs such as ISAM or VSAM. Firstly, it introduced the concept of accessing many records with one single command. Secondly, it eliminates the need to specify how to reach a record, i.e., with or without an index.