Glossary
Every term the courses use, defined in one line and then in a paragraph. Written to be read out of order.
Showing 2 of 2 matching “Join”
A database of flexible-shaped records.
Stores whole documents rather than rows with fixed columns. Related data is nested rather than joined. Suits genuinely independent records; fights you when your data is full of relationships.
Answering a question that spans two tables.
Matching rows across tables using a key: orders with their customer names attached. Ordinary and fast when the columns involved are indexed, and very slow when they are not.
See also Foreign key, Index, Normalisation