Database Skills: Complete Contents

This posting will be updated each week to contain a complete table of contents for the Database Skills series.

Subseries 1: Table Design Basics

The first group of posts introduces the must-know terms and techniques for table design.

• Introduction
• Primary Keys
• Foreign Keys
• First Normal Form
• Second Normal Form
• Third Normal Form and Calculated Values
• Of Tables and Constraints

Subseries 2: Table Design Patterns

The second subseries details commonly occurring patterns in table design, how to recognize them and when to use them.

There is a complete List of Table Design Patterns. The rest of the entries are:

• A Sane Approach To Choosing Primary Keys
• Cross Reference Validation Pattern
• Limited Transaction Pattern
• False Patterns and the Reverse Foreign Key
• The Primary Key That Wasn't: Impermanent Primary Keys
• Resolutions (Also listed in Queries below)
• Denormalization Patterns

Subseries 3: Development Tools and Procedures

• The Framework And The Database
• Table Structure Changes
• Bad Requirements and Iterative Database Development

Subseries 4: Queries

• Introduction To Queries
• The JOIN is the Cornerstone of Powerful Queries
• How SQL UNION Affects Table Design
• GROUP BY, HAVING, SUM, AVG and COUNT(*)
• Joins Part Two, The Many Forms of JOIN
• Resolutions (Also listed in Table Designs Above)

Subseries 5: System Architecture

• Minimize Code, Maximize Data

Subseries 6: Security

• Introducing Database Security

Subseries 7: Server-Side Code

• Triggers, Encapsulation and Composition (introduction)

Other Postings

• Ringing in 2008