Database Indexes - UNIQUE, CLUSTERED, NONCLUSTERED
Joins in SQL - INNER, LEFT, RIGHT, OUTER, CROSS, SELF