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.
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.
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.