Structured Query Language (SQL)

The history of Structured Query Language (SQL) and the history of XML actually have a lot in common. SQL is a language for accessing data in a relational database. Relational databases are accessed (that is, they are queried) using SQL commands.

What Is “Relational”?

Relational databases store data in table structures; this is a very simple idea. A table has rows and columns. In a relational database table, each row is a single “item” (or instance) of the subject represented by the table, and each column is a value or attribute of a specific data type (for example, integer, string, Boolean) associated with that item. A “relation” is a table composed of these rows and columns. An example of a relational table follows: ...

Get XML and SQL: Developing Web Applications 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.