Structured Query Language (SQL) is a widely-used programming language for working with relational databases. SQL is generally pronounced as the three letters in the name, e.g. ess-cue-ell, or in some people's usage, as the word sequel.
This Wikibook provides a short description of SQL, its origins, basic concepts and components, and a lot of examples. The book follows the specifications of the SQL:2011 standard, which is developed by a common committee of ISO and IEC. Their publications are not freely available. But you may want to refer to a working draft of SQL:2008, which you can download from Whitemarsh Information Systems Corporation.
- About the Book
- Database Management Systems (DBMS)
- Relational DBMS (rDBMS)
- SQL: A Language for Working with rDBMS
- SQL: The Standard ISO IEC 9075 and various Implementations
|Two Parallel Tracks: Standard and Classic|
Managing Rights (GRANT / REVOKE)
NULL Values and the Three Value Logic
|End of Parallel Tracks|
Tips and Tricks
- Violated Foreign Key
- Violated Uniqueness
- Data Normalisation / Entity Relation Ship Diagrams
- Relational Algebra
- Glossary !!!!!!!
- List of Keywords
- Style Guide for Creating Tables
- Style Guide for Naming Objects
- Return Codes (switch from DB2 to standard-compliant codes ???)