Exam 98-364: Database Fundamentals/Understanding Data Storage

This lesson covers Understanding Data Storage. It looks at normalization, keys and indexes.

Activity 1 - Understand Normalization

This objective may include but is not limited to: understanding the reasons for normalization, the five most common levels of normalization, how to normalize a database to third normal form.

1. Read Chapter 4: Database Design Principles.
2. Read Database Normalization Tips.

Activity 2 - Understand Primary, Foreign, and Composite Keys

This objective may include but is not limited to: understanding the reason for keys in a database, choosing appropriate primary keys, selecting appropriate data type for keys, selecting appropriate fields for composite keys, understanding the relationship between foreign and primary keys.

1. Read PRIMARY KEY Constraints.
2. Read FOREIGN KEY Constraints.

Activity 3 - Understand Indexes

This objective may include but is not limited to: understanding clustered and non-clustered indexes and their purpose in a database.

1. Read Tables and Index Data Structures Architecture.
2. Read Indexes.

References

• Exam 98-364 Database Administration Fundamentals Student Study Guide
• Microsoft: Database Fundamentals Exam Details