Sql Introduction to Database
SQL INTRODUCTION Diaz, Francis Lorenzo A. BSM CS 3B G2
History of SQL
SQL began life as SEQUEL11, the Structured English Query Language, a component of an IBM research project called System/R. System/R was a prototype of the first relational database system; it was created at IBM’s San Jose laboratories by Donald D. Chamberlin and Raymond F. Boyce in 1974, and SEQUEL was the first query language to support multiple tables and multiple users. In the late 1970s, SQL made its first appearance in a commercial role as the query language used by the Oracle RDBMS. This was quickly followed by the Ingres RDBMS, which also used SQL, and by the 1980s, SQL had become the de facto standard for the rapidly growing RDBMS industry. In 1989, SQL became an ANSI standard commonly referred to as SQL89; this was later updated in 1992 to become SQL92 or SQL2, the standard in use on most of today’s commercial RDBMSs (including MySQL).
SQL was invented and developed by IBM in early 1970’s. IBM was able to demonstrate how to control relational databases using SQL. The SQL implemented by ORACLE CORPORATION is 100% compliant with the ANSI/ISO standard SQL data language. Oracle’s database language is SQL, which is used for storing and retrieving information. SQL allows users to access data in relational database management systems, such as Oracle, Sybase, Informix, Microsoft SQL Server, Access, and others, by allowing users to describe the data the user wishes to see. A table is a primary database object of SQL that is used to store data. A table holds data in the form of rows and columns
Characteristics of SQL
SQL is an ANSI and ISO standard computer language for creating and manipulating databases.
SQL allows the user to create, update, delete, and retrieve data from a database.
SQL is very simple and easy to learn.
SQL works with database programs like DB2, Oracle, MS Access, Sybase, MS SQL Sever etc.
Advantages of SQL:
High Speed: SQL Queries can retrieve large amounts of
History of SQL
SQL began life as SEQUEL11, the Structured English Query Language, a component of an IBM research project called System/R. System/R was a prototype of the first relational database system; it was created at IBM’s San Jose laboratories by Donald D. Chamberlin and Raymond F. Boyce in 1974, and SEQUEL was the first query language to support multiple tables and multiple users. In the late 1970s, SQL made its first appearance in a commercial role as the query language used by the Oracle RDBMS. This was quickly followed by the Ingres RDBMS, which also used SQL, and by the 1980s, SQL had become the de facto standard for the rapidly growing RDBMS industry. In 1989, SQL became an ANSI standard commonly referred to as SQL89; this was later updated in 1992 to become SQL92 or SQL2, the standard in use on most of today’s commercial RDBMSs (including MySQL).
SQL was invented and developed by IBM in early 1970’s. IBM was able to demonstrate how to control relational databases using SQL. The SQL implemented by ORACLE CORPORATION is 100% compliant with the ANSI/ISO standard SQL data language. Oracle’s database language is SQL, which is used for storing and retrieving information. SQL allows users to access data in relational database management systems, such as Oracle, Sybase, Informix, Microsoft SQL Server, Access, and others, by allowing users to describe the data the user wishes to see. A table is a primary database object of SQL that is used to store data. A table holds data in the form of rows and columns
Characteristics of SQL
SQL is an ANSI and ISO standard computer language for creating and manipulating databases.
SQL allows the user to create, update, delete, and retrieve data from a database.
SQL is very simple and easy to learn.
SQL works with database programs like DB2, Oracle, MS Access, Sybase, MS SQL Sever etc.
Advantages of SQL:
High Speed: SQL Queries can retrieve large amounts of