Structured Query Language

For a thorough look at one SQL variant, see also MySQL and Oracle Programming/SQL Cheatsheet.

For the SQL Dialects References, see also SQL Dialects Reference.

Structured Query Language (SQL) is a widely-used query language for using database. This Wikibook provides a detailed description of SQL, its origins, its programming, and its uses. This book follows the specifications of the SQL:2008 standard published in 2008 by the ISO. A draft of SQL:2008 is freely available as a zip archive at http://www.wiscorp.com/sql200n.zip from Whitemarsh Information Systems Corporation.

Chapters

1. Introduction to SQL
2. Relational Databases
3. Data Query Language
4. Data Manipulation Language
5. Data Definition Language
6. Data Control Language
7. Performance

Appendices

1. Glossary
2. Return Codes