Understand Data Storage

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:

1. Normalizing Data
2. Creating Constraints
3. Composite Primary Key
4. 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