SQL

Also known as Structural Query Language

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.org →

Link to the official site · not written by Vinony

Wikidata facts

Instance of: programming language
Subclass of: query language
Official name: SQL
Based on: first-order logic
Developer: Donald D. Chamberlin
Designed by: Raymond F. Boyce
Official website: www.iso.org/standard/76583.html
Image: SQL ANATOMY wiki.svg
Has use: relational database management system

Show 18 more facts

media type: application/sql
topic's main category: Category:SQL
typing discipline: static typing
topic has template: Template:SQL
IPA transcription: ˈsiːkwəl
Stack Exchange tag: stackoverflow.com/tags/sql
inception: 1974-00-00
manifestation of: relational algebra
short name: SQL
programming paradigm: declarative programming
Commons category: Structured Query Language
used by: relational database management system
file extension: sql
on focus list of Wikimedia project: Wikipedia:Vital articles/Level/4
influenced by: first-order logic
publication date: 1986-00-00
software version identifier: SQL:2023
P13411: sea

Sources (11)

via Wikidata · CC0

~20 min read

Encyclopedic overview

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.

Excerpted from Wikipedia’s “SQL” article, available under the CC BY-SA 4.0 licence.

SQL

Key facts

Official website

Wikidata facts

Encyclopedic overview

Available in 87 languages

What links here1,494 pages

What links here1,494 pages