Chapter 3. Implementing the Physical Database

Terms you'll need to understand:

• RAID

• Gigabit

• Database

• Table

• Record

• Row

• Column

• Field

• Filegroups

• Clustered index

• Nonclustered index

• Trigger

• Primary key

• Foreign key

• Constraint

• Stored procedure

• Log file

• Model database

Techniques you'll need to master:

• Hardware setup/file placement

• Database creation

• Object creation

• Setting/altering properties

• Setting constraints