Database

Normal Forms

• A Simple Guide to Five Normal Forms in Relational Database Theory (link)

Clustered vs Non-Clustered Index

• What is the difference between clustered and nonclustered indexes? (link)
• Clustered index vs. non-clustered index (link)
• An Introduction to Clustered and Non-Clustered Index Data Structures (link)

Joins

Outer Join

• Using Outer Joins (link), MSDN

Relational Databases

SQLite

SQLite page.

SQL Server

To delete records from the table and also reset the Identity field, use

truncate table [schema].[Table]

SQL Server list of updates (link). Lists service packs and any cumulative patches released.

SQL Compact

SQL Compact is Microsoft's parallel to SQLite. It is a small database engine that can be used both on desktop and on mobile devices.

Utilities

See Database Tools page for tools.