User:Planotse/IQA/SQL/Basic Concepts

Presentation
Constraint: an input filter Denormalizing: performance improvement through reduction in number of joins needed for data processing Indexes' tradeoffs: faster retrieval, slower updates Join: a logical connection between two tables Normalizing: eliminating redundant information and making it easier for future updates Primary key: a combination of columns which uniquely specify a row Where vs having: where is a restriction and having is a filter