SQL (novice level):
Primary versus Foreign keys.
Types of JOINs and differences.
What is Normalization?
Why would one de-normalize?

Question

SQL (novice level):
Primary versus Foreign keys.
Types of JOINs and differences.
What is Normalization?
Why would one de-normalize?

Sigiloso · Accepted Answer

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.

SessionM

Pergunta de entrevista da empresa SessionM

Resposta da entrevista

Empresas seguidas

Buscas de vagas