Data Storage

The 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:

Overview

Learning Outcomes:

In this module, you will complete the following exercises:

  • Exercise 1 - Normalizing Data

  • Exercise 2 - Creating Constraints

  • Exercise 3 - Creating Indexes

After completing this lab, you will be able to:

  • Normalize a table

  • Create Primary Key and Foreign Key Constraints

  • Create Composite Primary Keys

  • Manage clustered and non-clustered indexes

Exam Objectives:

The following exam objectives are covered in this lab:

  • 5.2 Compare and contrast various database structures.

  • 5.3 Summarize methods used to interface with databases.

Note: Our main focus is to cover the practical, hands-on aspects of the exam objectives. We recommend referring to course material or a search engine to research theoretical topics in more detail.

Courses