Understand Data Storage
The "Understand Data Storage" module provides you with the instruction and server hardware to develop your hands on skills in the defined topics. This module includes the following exercises: 1) Normalizing Data, 2) Creating Constraints, 3) Composite Primary Key, 4) Creating Indexes.

Introduction
The Understand Data Storage module provides you with the instruction and server hardware to develop your hands on skills in the defined topics. This module includes the following exercises:
- Normalizing Data
- Creating Constraints
- Composite Primary Key
- Creating Indexes
Exercise 1 - Normalizing Data
In this exercise, you will learn the following in Microsoft SQL Server 2008 R2:
- Normalizing database data
Exercise 2 – Creating Constraints
In this exercise, you will learn the following in Microsoft SQL Server 2008 R2:
- Creating Primary Key and Foreign Key constraints
- Creating Composite Primary Key constraint
Exercise 3 - Composite Primary Key
When a primary key constraint is applied to a combination of more than one column, it is a composite key. In this case, the values in one or more columns designated as primary key can be the same, however, at no point; the values in all columns in the primary key for a row can be same.
Exercise 4 – Creating Indexes
In this exercise, you will learn the following in Microsoft SQL Server 2008:
- Creating clustered index on a table
- Creating non-clustered index on a table
See the full benefits of our immersive learning experience with interactive courses and guided career paths.