Structured Query Language (SQL) is a widely-used programming language for working with relational databases. The name of the language is generally pronounced as the three letters of its abbreviation
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 can be ordered online.[1] Or you may want to refer to a working draft, which you can download from Whitemarsh Information Systems Corporation.
Introduction
- 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
- Language Elements
- Learning by Doing
The Snippets Corner
Two Parallel Tracks: Standard and Classic |
Standard Track |
Classic Track | ||
Managing Indexes Advanced SELECT features
Transactions / Isolation Levels Some Notes on typical SQL (non-trivial) Tasks |
|
End of Parallel Tracks |
Appendices
References
See also
- Wikibook Microsoft SQL Server
- Wikibook MySQL
- Wikibook Oracle Database
- Wikibook PostgreSQL
- Wikibook SQLite
- Wikipedia: SQL Key Words