SessionM interview question
SQL (novice level): Primary versus Foreign keys. Types of JOINs and differences. What is Normalization? Why would one de-normalize?
Interview Answer
Anonymous
27 Jul 2018
PK is indexed. FK links to PK. INNER and OUTER (LEFT, RIGHT, FULL) determine which data is returned from which tables. Design best practice to reduce data redundancy. Reporting databases are often de-normalized.