Resources with this report: Wikipidia. com, SQL. com, Oracle. com Great SQL:
Methodized Query Terminology is a special-purpose programming vocabulary designed for taking care of data in a relational database software system (RDBMS). Originally based upon relational algebra and tuple relational calculus, SQL includes a data definition language and a data treatment language. The scope of SQL includes data insert, query, upgrade and delete, schema creation and modification, and data access control. Although SQL is often described as, and to a great extent is definitely, a declarative language (4GL), it also contains procedural components. SQL was one of the first business languages pertaining to Edgar Farreneheit. Codd's relational model, while described in his influential 1970 paper " A Relational Model of Info for Huge Shared Data Banks". Inspite of not entirely adhering to the relational style as described by Codd, it became one of the most widely used data source language. SQL became a regular of the American National Specifications Institute (ANSI) in 1986, associated with the International Organization pertaining to Standards (ISO) in 1987. Since then, the normal has been improved several times with added features. But code is not really completely portable among diverse database devices, which can bring about vendor lock-in. The different creators do not flawlessly follow the common, they add extensions, plus the standard may also be ambiguous. How many changes of the normal have there been?
SQL has gone 3 key revisions and 11 small.
SQL1 - Also known as SQL-86. This was the first syndication of SQL by AMERICAN NATIONAL STANDARDS INSTITUTE in 1986. Two minor changes were published on SQL1: SQL-87 and SQL-89. SQL2 - Also referred to as SQL/92, SQL-92, ISO/IEC 9075: 1992, AMERICAN NATIONAL STANDARDS INSTITUTE X3. 135-1992, or FIPS 127-2. This is a major version of SQL in 1992. SQL3 -- Also known as SQL: 1999. This was a major modification of SQL in 1999. Many minor alterations were released on SQL3: SQL: 2003, SQL: 2006 and SQL: 2008. That which was added to the most up-to-date one?
SQL Server 2012...