Structured Query Language

From Wikibooks, open books for an open world
Jump to: navigation, search


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.




Loupe light.svg

Introduction

  1. About the Book 100% developed  as of 21 May, 2012
  2. Database Management Systems (DBMS) 100% developed  as of 21 May, 2012
  3. Relational DBMS (rDBMS) 100% developed  as of 21 May, 2012
  4. SQL: A Language for Working with rDBMS 100% developed  as of 21 May, 2012
  5. SQL: The Standard ISO IEC 9075 and various Implementations 100% developed  as of 21 May, 2012


Chapters

  1. Introduction to SQL 100% developed  as of 13 Dec, 2011
  2. Relational Databases 100% developed  as of 13 Dec, 2011
  3. Data Query Language 100% developed  as of 13 Dec, 2011
  4. Data Manipulation Language 100% developed  as of 13 Dec, 2011
  5. Data Definition Language 100% developed  as of 13 Dec, 2011
  6. Data Control Language 100% developed  as of 13 Dec, 2011
  7. Performance 100% developed  as of 13 Dec, 2011

Appendices

  1. Glossary 100% developed  as of 13 Dec, 2011
  2. Return Codes 100% developed  as of 13 Dec, 2011