Hands-On Software Engineering with Golang

Relational databases

The idea of relational databases was introduced by E. F. Codd in 1970 ^[6]. The main unit of data organization in a relational database is referred to as a table. Each table is associated with a schema that defines the names and data types for each table column.

Within a table, each data record is represented by a row that is, in turn, identified by a primary key, a tuple of column values that must be unique among all the table rows. Table columns may also reference records that exist in other tables. This type of column is typically referred to as a foreign key.

The standardized way to access and query relational databases is via the use of an English-like structured query language (SQL), which is actually a subset of ...