The Database Programming Language
Free
resources updated everyday:
XXXLINKSXX
SQL originated in one of IBM’s research laboratories, as did relational database theory. In the early 1970s, as IBM researchers performed early development on relational DBMS system, they created a data sublanguage to operate on these systems.
"A Relational Model of Data for Large Shared Data Banks," by Dr. E. F. Codd, was published in June 1970 in the Association of Computer Machinery (ACM) journal, Communications of the ACM. Codd's model is now accepted as the definitive model for relational database management systems (RDBMS). The language, Structured English Query Language ("SEQUEL") was developed by IBM Corporation, Inc., to use Codd's model. SEQUEL later became SQL (still pronounced "sequel").
In 1979, Relational Software, Inc. (now Oracle Corporation) introduced the first commercially available implementation of SQL. Today, SQL is accepted as the standard RDBMS language.
Significant Language Features
Sample Program
Source Code: (SELECT)
1. Create a standard SELECT statement
SELECT * FROM employees
WHERE state = ‘CA’
2. Run that statment to test it
3. Add the words: CREATE VIEW viewname AS to the top of the select statement and run it
CREATE VIEW cal_employees AS
SELECT * FROM employees
WHERE state = ‘CA’
4. To use the view
INSERT cal_employees
VALUES(100, ‘fred’, ‘smith’) etc.
DELETE cal_employees
WHERE city = ‘Oakland’
This program create a standard SELECT statement and adding more clauses with the statement.
