SQL : Introduction to Sql

SQL (Structured Query Language) is a special-purpose programming language designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system. Although SQL is both an ANSI and an ISO standard, many database products support SQL with proprietary extensions to the standard language.

• SQL is used to communicate with a database. According to ANSI (American National Standards Institute).

• it is the standard language for relational database management systems. SQL statements are used to perform tasks such as update data on a database, or retrieve data from a database.

           Some common relational database management systems that use SQL are: Oracle, Microsoft SQL Server, Access, Ingres, etc.
 There are 2 types of SQL servers.

• SQL Server

• SQL plus Server

SQL Server :-
         
               SQL Server is a relational database management system (RDBMS). It is a full-featured database primarily designed to compete against competitors Oracle Database (DB) and MySQL.

SQL plus Server:-     
               SQL plus  is a interactive and batch query tool that is installed with every Oracle Database Server or Client installation. It has a command-line user interface, a Windows Graphical User Interface (GUI).

History :-

      The language, Structured English Query Language (SEQUEL) was developed by IBM Corporation.  

      "A Relational Model of Data for Large Shared Data Banks", in June 1970 in the Association of Computer Machinery (ACM)  journal, Communications of the ACM. SEQUEL later became SQL (still pronounced "sequel"). In 1979, Relational Software, Inc. (now Oracle) introduced the first commercially available implementation of SQL. Today, SQL is accepted as the standard RDBMS language.

---