DEV Community


Around IT In 256 SecondsAround IT In 256 Seconds

#34: SQL joins

Around IT In 256 Seconds Play Button Pause Button

In relational databases, data is kept in relations, commonly known as tables. Simplifying, when data is normalized, it’s not duplicated. For example, when storing books and authors, you don’t keep an author’s name next to a book record. Instead, you use a so-called foreign key that references the author in another table. Thanks to this level of indirection, books by the same author do not store repeated information. This has many benefits and one, huge drawback. In order to look up a book together with a corresponding author you must somehow correlate these two tables. This is called joining.

Read more:

Get the new episode straight to your mailbox:

Episode source

Editor guide