SQL
SQL.png

Structured Query Language
Cross-platform static, strong multi-paradigm database format
Database computer language
IBM
1986

Standard
ISO/IEC 9075
Dialects
SQL-86, SQL-89, SQL-92, SQL:1999, SQL:2003, SQL:2008
Filename extension
.sql
Internet media type
application/x-sql

Relational database management systems (RDBMS)
"A Relational Model of Data for Large Shared Data Banks"
Relational algebra and calculus databases

Data managing

  • data insert
  • query
  • update
  • delete
  • schema creation
  • schema modification
  • data access control

Elements

Clauses
components of statements and queries.

Queries
retrieve criteria-based data

Statements
persistent schemata and data effect
control transactions, program flow, connections, sessions, or diagnostics
statement terminator semicolon (SQL grammar)

whitespace
generally ignored in SQL statements and queries

External articles

  • Donahoo, Michael J, and Gregory D. Speegle. Sql: Practical Guide for Developers. Amsterdam: Elsevier, 2005
  • Fehily, Chris. Sql. Berkeley, Calif: Peachpit, 2008
  • Oppel, Andrew J, and Robert Sheldon. Sql: A Beginner's Guide. New York: McGraw-Hill, 2009
  • Harrington, Jan L. Sql Clearly Explained. Burlington, MA: Morgan Kaufmann, 2010
  • Taylor, Allen G. Sql for Dummies. Hoboken, N.J: Wiley, 2010
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License