SQL
SQL
(
/
ˌ
ɛ
s
ˌ
k
juː
ˈ
ɛ
l
/
(
listen
)
S-Q-L
,
[4]
/
ˈ
s
iː
k
w
əl
/
"sequel";
Structured Query Language
)
[5]
[6]
[7]
[8]
is a
domain-specific language
used in programming and designed for managing data held in a
relational database management system
(RDBMS), or for stream processing in a
relational data stream management system
(RDSMS). It is particularly useful in handling
structured data
where there are relations between different entities/variables of the data. SQL offers two main advantages over older read/write
APIs
like
ISAM
or
VSAM
: first, it introduced the concept of accessing many records with one single command; and second, it eliminates the need to specify
how
to reach a record, e.g. with or without an
index
.
Page Revisions
| Year | Metadata | Sections | Top Words | First Paragraph |
| 2018 |
208324 characters 19 sections 33 paragraphs 11 images 812 internal links 56 external links |
sql 0.736 relational 0.295 sequel 0.160 chamberlin 0.142 query 0.137 database 0.119 9075 0.113 codd 0.113 iso 0.111 standards 0.094 postgresql 0.091 iec 0.090 boyce 0.085 drda 0.085 alternatives 0.078 |
SQL
(
/
ˌ
ɛ
s
ˌ
k
juː
ˈ
ɛ
l
/
(
|
|
| 2017 |
194004 characters 11 sections 27 paragraphs 11 images 801 internal links 47 external links |
sql 0.732 relational 0.313 sequel 0.162 query 0.139 9075 0.135 database 0.122 iso 0.101 chamberlin 0.101 codd 0.101 drda 0.101 iec 0.095 alternatives 0.093 standards 0.081 13249 0.067 boyce 0.067 |
SQL
(
/
ˌ
ɛ
s
.
k
juː
ˈ
ɛ
l
/
(
|
|
| 2016 |
238810 characters 22 sections 61 paragraphs 15 images 839 internal links 53 external links |
sql 0.728 query 0.229 relational 0.215 nulls 0.145 unknown 0.145 select 0.125 null 0.110 oracle 0.102 view 0.101 database 0.093 column 0.088 books 0.086 postgresql 0.083 sequel 0.083 9075 0.083 |
SQL
(
/
ˈ
ɛ
s
|
|
| 2015 |
235202 characters 22 sections 61 paragraphs 13 images 832 internal links 48 external links |
sql 0.727 query 0.229 relational 0.215 nulls 0.145 unknown 0.145 select 0.125 null 0.109 oracle 0.102 view 0.101 books 0.100 database 0.093 column 0.088 postgresql 0.083 sequel 0.083 9075 0.083 |
SQL
(
/
ˈ
ɛ
s
|
|
| 2014 |
217193 characters 25 sections 55 paragraphs 10 images 813 internal links 42 external links |
sql 0.728 query 0.254 relational 0.213 nulls 0.152 unknown 0.152 select 0.130 null 0.121 oracle 0.095 column 0.092 database 0.091 postgresql 0.087 sequel 0.087 9075 0.087 codd 0.087 comparisons 0.079 |
SQL
(
/
ˈ
ɛ
s
|
|
| 2013 |
210340 characters 25 sections 56 paragraphs 7 images 800 internal links 38 external links |
sql 0.723 query 0.259 relational 0.205 nulls 0.154 unknown 0.154 select 0.133 null 0.123 oracle 0.096 column 0.094 database 0.093 postgresql 0.089 transaction 0.089 9075 0.088 codd 0.088 comparisons 0.081 |
SQL
(
/
ˈ
ɛ
s
|
|
| 2012 |
204935 characters 26 sections 54 paragraphs 8 images 793 internal links 33 external links |
sql 0.720 query 0.260 relational 0.206 nulls 0.155 unknown 0.155 select 0.133 null 0.123 oracle 0.097 column 0.095 postgresql 0.089 transaction 0.089 9075 0.089 codd 0.089 database 0.087 comparisons 0.081 |
SQL
(
/
[invalid input: 'icon']
ˈ
ɛ
s
|
|
| 2011 |
191087 characters 22 sections 47 paragraphs 8 images 775 internal links 27 external links |
sql 0.693 relational 0.346 query 0.266 select 0.151 column 0.117 database 0.116 rdbms 0.111 null 0.100 oracle 0.090 sequel 0.089 transaction 0.089 valued 0.083 codd 0.083 dbms 0.083 unknown 0.083 |
SQL
(officially
/
[invalid input: 'icon']
ˈ
ɛ
s
|
|
| 2010 |
154181 characters 22 sections 54 paragraphs 3 images 385 internal links 27 external links |
sql 0.794 relational 0.238 query 0.192 9075 0.178 dbms 0.139 database 0.113 select 0.108 solely 0.096 column 0.085 sequel 0.080 psm 0.079 null 0.072 iso 0.066 oracle 0.065 persistent 0.064 |
SQL (officially pronounced /ˌɛskjuːˈɛl/ (deprecated template) like "S-Q-L" but often pronounced /ˈsiːkwəl/ (deprecated template) like "sequel"), [1] often referred to as Structured Query Language , is a database computer language designed for managing data in relational database management systems (RDBMS), and originally based upon relational algebra and calculus [2] . Its scope includes data insert, query, update and delete, schema creation and modification, and data access control. SQL was one of the first commercial languages for Edgar F. Codd 's relational model , as described in his influential 1970 paper, "A Relational Model of Data for Large Shared Data Banks" [3] . Despite not adhering to the relational model as described by Codd , it became the most widely used database language. [4] [5] |
|
| 2009 |
102224 characters 22 sections 56 paragraphs 3 images 221 internal links 24 external links |
sql 0.801 relational 0.206 query 0.191 9075 0.178 dbms 0.138 select 0.108 database 0.107 solely 0.095 sequel 0.095 column 0.084 psm 0.079 unknown 0.079 null 0.077 iso 0.065 persistent 0.064 |
SQL ( Structured Query Language ) ( pronounced /ˌɛs.kjuːˈɛl/ (deprecated template) ES -ky oo - EL ) [1] [2] is a database computer language designed for managing data in relational database management systems (RDBMS), and originally based upon Relational Algebra . Its scope includes data query and update, schema creation and modification, and data access control. SQL was one of the first languages for Edgar F. Codd 's relational model in his influential 1970 paper, "A Relational Model of Data for Large Shared Data Banks" [3] and became the most widely used language for relational databases. [4] [5] |
|
| 2008 |
95254 characters 18 sections 49 paragraphs 3 images 235 internal links 21 external links |
sql 0.818 query 0.202 9075 0.156 dbms 0.156 database 0.152 relational 0.128 select 0.107 dml 0.097 psm 0.097 sequel 0.094 ddl 0.078 iso 0.070 persistent 0.063 rdbms 0.063 transaction 0.063 |
SQL ( Structured Query Language ) ( Template:PronEng [ citation needed ] ) is a database computer language designed for the retrieval and management of data in relational database management systems (RDBMS), database schema creation and modification, and database object access control management. [2] [3] |
|
| 2007 |
81058 characters 18 sections 45 paragraphs 2 images 209 internal links 13 external links |
sql 0.820 query 0.192 9075 0.159 dbms 0.159 database 0.144 relational 0.131 select 0.109 dml 0.099 psm 0.099 books 0.082 sequel 0.080 ddl 0.080 column 0.073 databases 0.072 iso 0.072 |
SQL (usually Template:PronEng or sometimes /ˈsiːkwəl/ ) is a database computer language designed for the retrieval and management of data in relational database management systems (RDBMS), database schema creation and modification, and database object access control management. [1] [2] SQL is an acronym for Structured Query Language. |
|
| 2006 |
54533 characters 16 sections 31 paragraphs 3 images 192 internal links 23 external links |
sql 0.612 relational 0.292 sequel 0.231 database 0.210 codd 0.164 ddl 0.164 oracle 0.135 dml 0.123 retrieval 0.123 alternatives 0.113 query 0.113 ansi 0.101 postgresql 0.099 transaction 0.099 ibm 0.091 |
SQL (commonly expanded to Structured Query Language — see History for the term's derivation) is the most popular computer language used to create, modify, retrieve and manipulate data from relational database management systems . The language has evolved beyond its original purpose to support object-relational database management systems . It is an ANSI / ISO standard. |
|
| 2005 |
35921 characters 15 sections 29 paragraphs 0 images 100 internal links 19 external links |
sql 0.654 relational 0.333 database 0.241 codd 0.190 sequel 0.153 ddl 0.152 oracle 0.146 38 0.114 dml 0.114 ansi 0.107 alternatives 0.105 query 0.105 ibm 0.095 transaction 0.092 boyce 0.076 |
SQL (commonly expanded to Structured Query Language - see History for the term's derivation) is the most popular computer language used to create, modify and retrieve data from relational database management systems . The language has evolved beyond its original purpose to support object-relational database management systems . It is an ANSI / ISO standard. |
|
| 2004 |
25996 characters 7 sections 25 paragraphs 0 images 85 internal links 19 external links |
sql 0.659 database 0.229 ddl 0.203 query 0.175 relational 0.167 sequel 0.164 codd 0.152 dml 0.152 ansi 0.107 fourth 0.102 dcl 0.102 zip 0.102 record 0.101 oracle 0.083 sas 0.082 |
Structured Query Language ( SQL ) is the most popular computer language used to create, modify and query databases. |
|
| 2003 |
12733 characters 4 sections 19 paragraphs 0 images 31 internal links 3 external links |
sql 0.685 query 0.238 database 0.208 ddl 0.207 rows 0.143 dml 0.138 pronunciation 0.138 column 0.126 ansi 0.122 table 0.115 proprietary 0.115 relational 0.113 select 0.113 sequel 0.111 transaction 0.111 |
Structured Query Language , or SQL , is a declarative programming language for use in quasi- relational databases . Many of the original SQL features were inspired by, but in violation of, tuple calculus , but recent extensions to SQL include a more relational algebra flavour. |
|
| 2002 |
8139 characters 1 sections 13 paragraphs 0 images 27 internal links 0 external links |
sql 0.661 query 0.252 relational 0.199 database 0.192 rows 0.189 pronunciation 0.182 select 0.150 sequel 0.147 ansi 0.128 table 0.127 column 0.111 oracle 0.100 pl 0.100 revised 0.100 procedural 0.096 |
SQL stands for Structured Query Language , a language for use in quasi- relational databases . Many of the original SQL features were inspired by, but in violation of, tuple relational calculus , but recent extensions to SQL include a more relational algebra flavour. |
|
| 2001 |
2091 characters 0 sections 11 paragraphs 0 images 11 internal links 0 external links |
sql 0.692 revised 0.330 1992 0.251 query 0.209 stands 0.209 variations 0.184 oracle 0.165 pl 0.165 1986 0.165 1998 0.137 databases 0.137 proprietary 0.125 nature 0.125 2001 0.115 corporation 0.115 |
SQL3 supports objects, which weren't previously supported in other versions, but as of late 2001, few if any database management systems implement SQL3. |