Part III

• Spreading the data around: Data Normalization
• Referentially speaking: Associating tables using foreign keys
• Reaching across the aisle using JOIN
• Explicit JOIN syntax
• OUTER JOIN
• Why be normal? Denormalization as an informed choice.
• Conclusion
• Further Resources

A Gentle Introduction to SQL Using SQLite by Troy Thibodeaux is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License.