Data Storage

Practice Labs Module
Time
47 minutes
Difficulty
Intermediate

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:

Join over 3 million cybersecurity professionals advancing their career
Sign up with
or

Already have an account? Sign In »

Overview

Introduction

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:

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.

Lab Duration

It will take approximately 30 minutes to complete this lab.

Exercise 1 - Normalizing Data

Normalization is the process of organizing the database design to minimize data duplication. A table with more columns is a feature of a non-normalized database. For example, consider a table named Faculty with the following fields:

  • FacultyID
  • FacultyName
  • HireDate
  • CourseName
  • Gender
  • Salary

Learning Outcomes

After completing this exercise, you will be able to:

  • Normalize a table

Exercise 2 - Creating Constraints

Learning Outcomes

After completing this exercise, you will be able to:

  • Create Primary Key and Foreign Key Constraints
  • Create Composite Primary Keys

Exercise 3 - Creating Indexes

Creating indexes on tables allow you quickly to gain access to data. An index holds the keys constructed from one or more columns in the table or view. SQL Server stores these keys in a structure and accesses the row or rows linked with the key values faster. The two types of indexes in SQL Server are clustered index and non-clustered index.

Learning Outcomes

After completing this exercise, you will be able to:

  • Manage clustered and non-clustered indexes.
Learning Partner
Comprehensive Learning

See the full benefits of our immersive learning experience with interactive courses and guided career paths.