content
| - %META:TOPICINFO{author="DeeGerhardt" date="1154460148" format="1.1" version="1.2"}%
---++Stuctured Query Language
Structued Query Language, also known as SQL for short is an industry-standard language for creating, updating and, querying relational database management systems. There are three basic components for SQL, these include:
* Data Definition Language (DDL) for creation and modification of relational schema as well as schema objects include relations, indexes, etc.
* Data Manipulation Language (DML) that allows you to insert, delete, update rows in tables and query data in tables
* Data Control Language (DCL) which provides for concurrency control, transactions as well as ddministrative tasks including the set up of database users, users ad table security permissions including grants and roles, etc.
---+++SQL Standard Revisions
* SQL-86
* SQL-87
* SQL-89
* [[http://en.wikipedia.org/wiki/SQL-92][SQL-92]] also known as SQL2
* SQL:1999 also known as SQL3
* SQL:2003
---+++ SQL2003
SQL2003 is the fifth(lastest) revision of the SQL database query language that includes XML-related features, window functions, standardized sequences and columns with auto-generated values (including identity-columns). The following includes the sections of the ISO Information technology on Database languages that comprise the SQL:2003 standard.
* [[http://www.iso.org/iso/en/CatalogueDetailPage.CatalogueDetail?CSNUMBER=34132][ ISO/IEC 9075-1:2003]] Framework (SQL/Framework)
* [[http://www.iso.org/iso/en/CatalogueDetailPage.CatalogueDetail?CSNUMBER=34133][ ISO/IEC 9075-2:2003]] Foundation (SQL/Foundation)
* [[http://www.iso.org/iso/en/CatalogueDetailPage.CatalogueDetail?CSNUMBER=34134][ ISO/IEC 9075-3:2003]] Call-Level Interface (SQL/CLI)
* [[http://www.iso.org/iso/en/CatalogueDetailPage.CatalogueDetail?CSNUMBER=34135 ][ISO/IEC 9075-4:2003]] Persistent Stored Modules (SQL/PSM)
* [[http://www.iso.org/iso/en/CatalogueDetailPage.CatalogueDetail?CSNUMBER=34136 ][ISO/IEC 9075-9:2003]] Management of External Data (SQL/MED)
* [[http://www.iso.org/iso/en/CatalogueDetailPage.CatalogueDetail?CSNUMBER=34137 ][ISO/IEC 9075-10:2003]] Object Language Bindings (SQL/OLB)
* [[http://www.iso.org/iso/en/CatalogueDetailPage.CatalogueDetail?CSNUMBER=34917 ][ISO/IEC 9075-11:2003]] Information and Definition Schemas (SQL/Schemata)
* [[http://www.iso.org/iso/en/CatalogueDetailPage.CatalogueDetail?CSNUMBER=37102 ][ISO/IEC 9075-13:2003]] SQL Routines and Types Using the Java Programming Language (SQL/JRT)
* [[http://www.iso.org/iso/en/CatalogueDetailPage.CatalogueDetail?CSNUMBER=35341][ ISO/IEC 9075-14:2003]] XML-Related Specifications (SQL/XML)
---++Examples
---++SQL Syntax
* [[http://en.wikipedia.org/wiki/Comparison_of_SQL_synta][Wikipedia Comaprison of SQL Syntax]]
CategoryGlossary
|