User:Kelti/sandbox


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

      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.


      Printer.svg

      A printable version of Kelti is available. (edit it)
      Wikipedia-logo.png

      Wikipedia has related information at SQL
      Wikiversity-logo.svg

      Wikiversity has learning materials about Introduction to SQL

      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

      The Basics

      Create a Table
      Elementary Examples
      Type System
      Operators, Functions
      Design your Data

      The SQL Language

      Old pages whose content will be moved to new pages below:

      • 100% developed  as of 13 Dec, 2011 Relational Databases (The content should be devided into two pages: one explaining fundamentals of relational databases and another presenting our example database.)
      • 100% developed  as of 13 Dec, 2011 Data Query Language (The term DQL is unusual and should be eliminated. The content should be integrated within DML.)
      • 100% developed  as of 13 Dec, 2011 Data Manipulation Language
      • 100% developed  as of 13 Dec, 2011 Data Definition Language
      • 100% developed  as of 13 Dec, 2011 Data Control Language
      • 100% developed  as of 13 Dec, 2011 Performance (Should be moved to CREATE INDEX page)

      New pages to be developed:

      DML 1

      0% developed  as of 1 March, 2012 Simple Queries

      DML 2

      0% developed  as of 1 March, 2012 INSERT: Insert new Rows
      0% developed  as of 1 March, 2012 UPDATE: Change existing Data
      0% developed  as of 1 March, 2012 DELETE: Delete Rows
      0% developed  as of 1 March, 2012 Transactions: Atomic Changes, Concurrent Processes, ACID postulate

      DML 3

      0% developed  as of 1 March, 2012 Extended Queries
      0% developed  as of 1 March, 2012 Three Value Logic

      DDL

      0% developed  as of 1 March, 2012 Predefined Data Types
      0% developed  as of 1 March, 2012 Define Tables
      0% developed  as of 1 March, 2012 Define Functions and Procedures

      DCL

      0% developed  as of 1 March, 2012 Managing Rights


      Appendices

      0% developed  as of 1 March, 2012 The Example Database
      100% developed  as of 1 March, 2012 Glossary
      0% developed  as of 1 March, 2012 List of Keywords
      0% developed  as of 1 March, 2012 Style Guide for Creating Tables
      0% developed  as of 1 March, 2012 Style Guide for Naming Objects
      0% developed  as of 1 March, 2012 Bibliographie
      100% developed  as of 13 Dec, 2011 Return Codes (switch from DB2 to standard-compliant codes ???)
      Last modified on 9 May 2012, at 10:31