Apologies in advance but this blog might start to look like online revision notes (and a LaTeX scratchpad) for the next six weeks.
Projection
Selection
Rename
Conditional Join
Natural Join
(Page 100 onwards of Database Management Systems, Third Edition)