Implement and Maintain Indexes

Practice Labs Module
Time
40 minutes
Difficulty
Intermediate

The "Implement and Maintain Indexes" 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: Managing Indexes, Full Text Indexes.

Join over 3 million cybersecurity professionals advancing their career
Sign up with
Required fields are marked with an *
or
Sign up with Google
Sign up with Apple
Sign up with Microsoft
View all SSO options

Already have an account? Sign In »

Overview

Introduction

The Implement and Maintain Indexes 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:

  • Managing Indexes
  • Full Text Indexes

Lab time: It will take approximately 30 minutes to complete this lab.

Exercise 1 - Managing Indexes

In this exercise, you will perform the tasks required to implement and maintain indexes.

In this exercise, you will learn the following about Microsoft SQL Server 2012:

  • Inspecting the physical characteristics of indexes
  • Identifying fragmented indexes
  • Identifying unused indexes
  • Implementing indexes
  • Rebuilding vs reorganizing an index
  • Understanding column store indexes

Exercise 2 - Full Text Indexes

In this exercise, you will perform the tasks required to understanding how to create full text indexes.

In this exercise, you will learn the following about Microsoft SQL Server 2012:

  • Creating full text indexes
Learning Partner
Practice Labs

IT & Cybersecurity certification hands on practice labs and practice exams for certifications and skill development.

Comprehensive Learning

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

Courses