How to Write INSERT if NOT EXISTS Queries in Standard SQL

How to Write a SQL Exclusion Join

How to Write a UNION in SQL Without Using UNION

Interactive Directory Merging

Mutex Tables in SQL

How to Write Subqueries Without Using Subqueries in SQL

Essential Books

Small Wins, Then Big Wins