Structured Query Language
From Wikibooks, open books for an open world
Structured Query Language (SQL) is a widely-used programming language for working with relational databases. 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.
For a thorough look at special SQL implementations, see MySQL or Oracle Programming/SQL Cheatsheet.
For a comparison of SQL dialects/implementations, see SQL Dialects Reference.
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
Chapters
- Introduction to SQL
- Relational Databases
- Data Query Language
- Data Manipulation Language
- Data Definition Language
- Data Control Language
- Performance