Web Skills Work

{ beta }

CHAPTERS

• 1. An Introduction to SQL
• 2. An Overview of the SELECT Statement
• 3. The FROM Clause
• 4. The WHERE Clause
• 5. The GROUP BY Clause
• 6. The HAVING Clause
• 7. The SELECT Clause
• 8. The ORDER BY Clause
• 9. SQL Data Types
• 10. Relational Integrity
• 11. Special Structures

Special Structures

This chapter examines some of the common database structures that can be used to implement complex relationships between entities.

Topics include the following:

• Joining to a Table Twice
• Joining a Table to Itself
• Implementing a Many-to-many Relationship: Keywords
• Wrapping Up: Special Structures

 

RELATED FILES

Visit Website

Code Archive

Sample Applications & Examples

Publisher: SitePoint

Author: Rudy Limeback

Year: 2008