Sunday, 10 April 2016

Basics Of SQL

Overview:
The full name of SQL is Structured Query Language, its pronunciation is ‘SEQUEL’. SQL is Non-Procedural* language and designed for managing data in a RDBMS* ( Relational Database Management System ).  

History:
It’s developed at IBM by Raymond F. Boyce & Donald D. Chamberlin in the year of 1970. The acronym 'SEQUEL' was later changed to SQL because "SEQUEL" was a trademark of the UK-based Hawker Siddeley aircraft company.

In the late 1970, Oracle Corporation Ltd [Then known as Relational Software Inc] realized  the potential of the thought mentioned by Chamberlin & Boyce and developed their own SQL-based  RDBMS, thinking of selling it to C.I.A, U.S Navy and other U.S govt organizations. In June 1979, Oracle launched the first commercially available implementation of SQL, Oracle V2 for VAX computers. IBM also launched System/38, SQL/DS and DB2 just after launching of Oracle V2.

Ad 1