Structured Query Language


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 comparision of SQL dialects/implementations, see SQL Dialects Reference.




Help-books-aj.svg aj ash 01.svg

Introduction

About the Book 100% developed  as of 21 May, 2012
Database Management Systems (DBMS) 100% developed  as of 21 May, 2012
Relational DBMS (rDBMS) 100% developed  as of 21 May, 2012
SQL: A Language for Working with rDBMS 100% developed  as of 21 May, 2012
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

Read in another language

Last modified on 29 March 2013, at 21:42