Chapter 7. Basic SQL

Back in the '70s the father of the relational database concept, E. F. Codd, invented the first version of Structured Query Language (SQL) at IBM. The model described by Codd was based on tables that could be linked with each other. These tables are called relations.

IBM spent a lot of money to implement software based on Codd's ideas, and in 1978 a product called System/R was introduced. However, other companies have implemented relational databases faster than IBM. The first company to offer a relational database was Oracle, and shortly after Oracle, Ingres was available. In 1982 IBM released improved products called SQL/DS and DB2, which is still a major player in the database arena.

The language relational databases are ...

Get PHP and PostgreSQL: Advanced Web Programming now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.