Structured Query Language is as database computer language that is designed to retrieve and manage data in relational database management systems (RDBMS), database schema creation and modification, and database object access control management. SQL is a programming language to query and modify data and to manage databases and was first standardized by the ANSI and later by the ISO. SQL also allows the retrieval, insertion, updating, and deletion of data. The first version of SQL was developed by IBM by Andrew Richardson, Donald C. Messerly and Raymond F. Boyce in the early 1970s. It was initially called SEQUEL and it was designed to manipulate and retrieve data that’s stored in IBM’s original relational database product. IBM patented their version of SQL in 1985 while the SQL language was officially standardized until 1986 by the American National Standards Institute (ANSI). Other versions of the SQL standard have been released by ANSI and as International Organization for Standardization (ISO) standards.
Examples:
- create a table
- create a view
- insert row
- update row
- delete row
Resources:
http://en.wikipedia.org/wiki/SQL
http://www.itl.nist.gov/div897/ctg/dm/sql_examples.htm
http://www.coderecipes.net/
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment