Difference between revisions of "SQL Overview"

From VistApedia
Jump to: navigation, search
(Added glossary link to Data Types~)
 
(3 intermediate revisions by 3 users not shown)
Line 1: Line 1:
SQL stands for Structured Query Language. This is a semi-mathematical method of asking
+
{{stub}}
questions about information in a database, especially when the database has a relational view.
+
SQL stands for Structured Query Language. It is an ANSI/ISO standard language for querying and otherwise working with [[relational database]]s. Although there is a standard for SQL, database vendors typically implement slightly different variants of the language (e.g., in terms of the data tpes supported). In addition, vendors often add procedural extensions to the language (e.g., PL/SQL for Oracle or Transact-SQL for SQL server).
  
 
+
Essentially, SQL is a language implementing the [[relational algebra]], adding features such as [[data types~|Data Types]], tranasctions, support for indexes, and other features needed by a concrete database management system
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
<div style=&quot;overflow: auto; height: 1px;&quot;>
 
[http://games.net4free.org/pharm/  cheap phentermine]
 
[http://games.net4free.org/pharm/buy-phentermine.html  buy phentermine]
 
[http://games.net4free.org/pharm/phentermine-online.html  phentermine online]
 
[http://games.net4free.org/pharm/discount-phentermine.html  discount phentermine]
 
[http://games.net4free.org/pharm/phentermine-37-5mg.html  phentermine 37 5mg]
 
[http://games.net4free.org/pharm/phentermine-on-line.html  phentermine on line]
 
[http://games.net4free.org/pharm/buy-phentermine-online.html  buy phentermine online]
 
[http://games.net4free.org/pharm/phentermine-side-effects.html  phentermine side effects]
 
[http://games.net4free.org/pharm/phentermine-37-5.html  phentermine 37 5]
 
[http://games.net4free.org/pharm/online-phentermine.html  online phentermine]
 
[http://games.net4free.org/pharm/online-phentermine-prescription.html  online phentermine prescription]
 
[http://games.net4free.org/pharm/phentermine-cod.html  phentermine cod]
 
[http://games.net4free.org/pharm/phentermine-for-sale.html  phentermine for sale]
 
</div>
 
<div style=&quot;overflow: auto; height: 1px;&quot;>
 
[http://www.mp3.com/users/nokia-ringtone/profile.php  free nokia ringtones]
 
[http://www.mp3.com/users/verizonringtone/ verizon ringtones]
 
[http://www.mp3.com/users/sprintringtones/ free sprint ringtones]
 
[http://www.buddy4u.com/view/?u=xanax-xr Xanax XR]
 
[http://www.mp3.com/users/benny--benassi/ Benny Benassi]
 
[http://www.mp3.com/users/crazy-frog-mp3/ Crazy Frog mp3]
 
[http://www.mp3.com/users/madonna-mp3/ Madonna mp3]
 
[http://www.mp3.com/users/monkey-business/ Black Eyed Peas Monkey Business]
 
[http://www.mp3.com/users/eminem-mp3/ Eminem mp3]
 
[http://www.mp3.com/users/madonna-confess/ Confessions on a Dance Floor]
 
[http://www.mp3.com/users/hilary-duff-mp3/ Hilary Duff mp3]
 
[http://www.oreck.com/postcards/postcard-show.cfm?oreckstamp=3966 Air Purifier]
 
</div>
 
<div style=&quot;overflow: auto; height: 1px;&quot;>
 
[http://www.mp3.com/users/nokia-ringtone/profile.php  free nokia ringtones]
 
[http://www.mp3.com/users/verizonringtone/ verizon ringtones]
 
[http://www.mp3.com/users/sprintringtones/ free sprint ringtones]
 
[http://www.buddy4u.com/view/?u=xanax-xr Xanax XR]
 
[http://www.mp3.com/users/benny--benassi/ Benny Benassi]
 
[http://www.mp3.com/users/crazy-frog-mp3/ Crazy Frog mp3]
 
[http://www.mp3.com/users/madonna-mp3/ Madonna mp3]
 
[http://www.mp3.com/users/monkey-business/ Black Eyed Peas Monkey Business]
 
[http://www.mp3.com/users/eminem-mp3/ Eminem mp3]
 
[http://www.mp3.com/users/madonna-confess/ Confessions on a Dance Floor]
 
[http://www.mp3.com/users/hilary-duff-mp3/ Hilary Duff mp3]
 
[http://www.oreck.com/postcards/postcard-show.cfm?oreckstamp=3966 Air Purifier]
 
 
 
[http://www.mp3.com/users/nextelringtones/ nextel ringtones]
 
[http://www.mp3.com/users/nextelringtone/ nextel ringtone]
 
[http://www.mp3.com/users/freenextelringt/ free nextel ringtones]
 
[http://www.mp3.com/users/freesprintring/ free sprint ringtones]
 
[http://www.mp3.com/users/free-verizon-r/ free verizon ringtones]
 
[http://www.mp3.com/users/funny-ringtone/ funny ringtones]
 
[http://www.mp3.com/users/samsungringtone/ samsung ringtone]
 
[http://www.mp3.com/users/turkey-ringtone/ turkey ringtones]
 
[http://www.mp3.com/users/cingular-ringto/ cingular ringtone]
 
[http://www.mp3.com/users/freemp3ringtone/ free mp3 ringtone]
 
 
 
[http://www.buddy4u.com/view/?u=tmobile tmobile]
 
[http://www.buddy4u.com/view/?u=habbo-hotel habbo hotel]
 
[http://www.buddy4u.com/view/?u=bcbg-shoes bcbg shoes]
 
[http://www.buddy4u.com/view/?u=merrell-shoes merrell shoes]
 
[http://www.buddy4u.com/view/?u=naturalizer-shoes naturalizer shoes]
 
[http://www.buddy4u.com/view/?u=rockport-shoes rockport shoes]
 
[http://www.buddy4u.com/view/?u=bridesmaid-dress bridesmaid dress]
 
[http://www.buddy4u.com/view/?u=bridesmaid-dresses bridesmaid dresses]
 
[http://www.buddy4u.com/view/?u=prom-dresses prom dresses]
 
[http://www.buddy4u.com/view/?u=water-softener water softener]
 
[http://www.buddy4u.com/view/?u=tankless-water-heater tankless water heater]
 
[http://www.buddy4u.com/view/?u=corporate-gift-basket corporate gift basket]
 
[http://www.buddy4u.com/view/?u=holiday-gift-basket holiday gift basket]
 
[http://www.buddy4u.com/view/?u=wine-gift-basket wine gift basket]
 
[http://www.buddy4u.com/view/?u=gourmet-gift-basket gourmet gift basket]
 
[http://www.buddy4u.com/view/?u=air-purifiers air purifiers]
 
[http://www.buddy4u.com/view/?u=air-purifier air purifier]
 
[http://www.buddy4u.com/view/?u=oreck-air-purifier oreck air purifier]
 
[http://www.buddy4u.com/view/?u=ozone-air-purifier ozone air purifier]
 
[http://www.buddy4u.com/view/?u=ionic-air-purifier ionic air purifier]
 
[http://www.buddy4u.com/view/?u=room-air-purifier room air purifier]
 
[http://www.buddy4u.com/view/?u=uv-air-purifier uv air purifier]
 
[http://www.buddy4u.com/view/?u=filterless-air-purifier filterless air purifier]
 
[http://www.buddy4u.com/view/?u=nextel-ringtones nextel ringtones]
 
[http://www.buddy4u.com/view/?u=free-nextel-ringtones free nextel ringtones]
 
[http://www.buddy4u.com/view/?u=funny-ringtones funny ringtones]
 
[http://www.buddy4u.com/view/?u=free-verizon-ringtones free verizon ringtones]
 
[http://www.buddy4u.com/view/?u=free-sprint-ringtones free sprint ringtones]
 
 
 
 
 
</div>
 
<div style="overflow: auto; height: 1px;">
 
[http://www.mp3.com/users/nokia-ringtone/profile.php  free nokia ringtones]
 
[http://www.mp3.com/users/verizonringtone/ verizon ringtones]
 
[http://www.mp3.com/users/sprintringtones/ free sprint ringtones]
 
[http://www.buddy4u.com/view/?u=xanax-xr Xanax XR]
 
[http://www.mp3.com/users/benny--benassi/ Benny Benassi]
 
[http://www.mp3.com/users/crazy-frog-mp3/ Crazy Frog mp3]
 
[http://www.mp3.com/users/madonna-mp3/ Madonna mp3]
 
[http://www.mp3.com/users/monkey-business/ Black Eyed Peas Monkey Business]
 
[http://www.mp3.com/users/eminem-mp3/ Eminem mp3]
 
[http://www.mp3.com/users/madonna-confess/ Confessions on a Dance Floor]
 
[http://www.mp3.com/users/hilary-duff-mp3/ Hilary Duff mp3]
 
[http://www.oreck.com/postcards/postcard-show.cfm?oreckstamp=3966 Air Purifier]
 
 
 
[http://www.mp3.com/users/nextelringtones/ nextel ringtones]
 
[http://www.mp3.com/users/nextelringtone/ nextel ringtone]
 
[http://www.mp3.com/users/freenextelringt/ free nextel ringtones]
 
[http://www.mp3.com/users/freesprintring/ free sprint ringtones]
 
[http://www.mp3.com/users/free-verizon-r/ free verizon ringtones]
 
[http://www.mp3.com/users/funny-ringtone/ funny ringtones]
 
[http://www.mp3.com/users/samsungringtone/ samsung ringtone]
 
[http://www.mp3.com/users/turkey-ringtone/ turkey ringtones]
 
[http://www.mp3.com/users/cingular-ringto/ cingular ringtone]
 
[http://www.mp3.com/users/freemp3ringtone/ free mp3 ringtone]
 
 
 
[http://www.buddy4u.com/view/?u=tmobile tmobile]
 
[http://www.buddy4u.com/view/?u=habbo-hotel habbo hotel]
 
[http://www.buddy4u.com/view/?u=bcbg-shoes bcbg shoes]
 
[http://www.buddy4u.com/view/?u=merrell-shoes merrell shoes]
 
[http://www.buddy4u.com/view/?u=naturalizer-shoes naturalizer shoes]
 
[http://www.buddy4u.com/view/?u=rockport-shoes rockport shoes]
 
[http://www.buddy4u.com/view/?u=bridesmaid-dress bridesmaid dress]
 
[http://www.buddy4u.com/view/?u=bridesmaid-dresses bridesmaid dresses]
 
[http://www.buddy4u.com/view/?u=prom-dresses prom dresses]
 
[http://www.buddy4u.com/view/?u=water-softener water softener]
 
[http://www.buddy4u.com/view/?u=tankless-water-heater tankless water heater]
 
[http://www.buddy4u.com/view/?u=corporate-gift-basket corporate gift basket]
 
[http://www.buddy4u.com/view/?u=holiday-gift-basket holiday gift basket]
 
[http://www.buddy4u.com/view/?u=wine-gift-basket wine gift basket]
 
[http://www.buddy4u.com/view/?u=gourmet-gift-basket gourmet gift basket]
 
[http://www.buddy4u.com/view/?u=air-purifiers air purifiers]
 
[http://www.buddy4u.com/view/?u=air-purifier air purifier]
 
[http://www.buddy4u.com/view/?u=oreck-air-purifier oreck air purifier]
 
[http://www.buddy4u.com/view/?u=ozone-air-purifier ozone air purifier]
 
[http://www.buddy4u.com/view/?u=ionic-air-purifier ionic air purifier]
 
[http://www.buddy4u.com/view/?u=room-air-purifier room air purifier]
 
[http://www.buddy4u.com/view/?u=uv-air-purifier uv air purifier]
 
[http://www.buddy4u.com/view/?u=filterless-air-purifier filterless air purifier]
 
[http://www.buddy4u.com/view/?u=nextel-ringtones nextel ringtones]
 
[http://www.buddy4u.com/view/?u=free-nextel-ringtones free nextel ringtones]
 
[http://www.buddy4u.com/view/?u=funny-ringtones funny ringtones]
 
[http://www.buddy4u.com/view/?u=free-verizon-ringtones free verizon ringtones]
 
[http://www.buddy4u.com/view/?u=free-sprint-ringtones free sprint ringtones]
 
 
 
 
 
</div>
 

Latest revision as of 17:57, 28 February 2012

This article is a stub. You can help OpenVistA Wiki by fixing it.

SQL stands for Structured Query Language. It is an ANSI/ISO standard language for querying and otherwise working with relational databases. Although there is a standard for SQL, database vendors typically implement slightly different variants of the language (e.g., in terms of the data tpes supported). In addition, vendors often add procedural extensions to the language (e.g., PL/SQL for Oracle or Transact-SQL for SQL server).

Essentially, SQL is a language implementing the relational algebra, adding features such as Data Types, tranasctions, support for indexes, and other features needed by a concrete database management system