SQL
E5275
SQL (Structured Query Language) is a standardized programming language used to manage, query, and manipulate data in relational database management systems.
Aliases (19)
- Transact-SQL ×5
- Structured Query Language ×3
- T-SQL ×3
- ANSI SQL ×2
- Data Query Language ×1
- ISO SQL ×1
- Oracle SQL ×1
- SEQUEL ×1
- SQL-86 ×1
- SQL-89 ×1
- SQL-92 ×1
- SQL:2003 ×1
- SQL:2006 ×1
- SQL:2008 ×1
- SQL:2011 ×1
- SQL:2011 (partially) ×1
- SQL:2016 ×1
- SQL:2019 ×1
- Transact-SQL (T-SQL) ×1
Statements (71)
| Predicate | Object |
|---|---|
| instanceOf |
database language
→
programming language → query language → |
| abbreviationOf |
Structured Query Language
→
|
| canBeEmbeddedIn |
.NET languages
→
C → Java → PHP → Python → |
| category |
ANSI standard
→
ISO standard → |
| dataModel |
relational
→
|
| designedFor |
relational model
→
|
| domain |
relational database management systems
→
|
| fullName |
Structured Query Language
→
|
| hasComponent |
Data Control Language
→
Data Definition Language → Data Manipulation Language → Data Query Language → |
| hasStandard |
SQL-86
→
SQL-89 → SQL-92 → SQL:1999 → SQL:2003 → SQL:2006 → SQL:2008 → SQL:2011 → SQL:2016 → SQL:2019 → |
| influencedBy |
SEQUEL
→
|
| introducedInDecade |
1970s
→
|
| originatedAt |
IBM
→
|
| paradigm |
declarative
→
|
| primaryUse |
controlling access to data
→
defining database schemas → managing data in relational databases → manipulating data in relational databases → querying data in relational databases → |
| standardizedBy |
ANSI
→
ISO → |
| supportsFeature |
constraints
→
joins → stored procedures → subqueries → transactions → triggers → views → |
| supportsOperation |
ALTER TABLE
→
CREATE INDEX → CREATE TABLE → CREATE VIEW → DELETE → DROP TABLE → GRANT → INSERT → REVOKE → SELECT → UPDATE → |
| usedBySystem |
IBM Db2
→
MariaDB → Microsoft SQL Server → MySQL → Oracle Database → PostgreSQL → SQLite → |
| usedFor |
OLAP systems
→
OLTP systems → analytics → business applications → data warehousing → reporting → |