Overview

Introduction

The Design Database Objects 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. Implement Full Text and Filtered Index
  2. Create Non Clustered and Column Store Index
  3. Implement Semantic Index
  4. Create Filtered Statistics and Full Statistics

Exercise 1- Implement Full Text and Filtered Index

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

  • Implement Full Text Index
  • Implement Filtered Index

Exercise 2 – Create Non Clustered and Column Store Index

In this exercise, you will create non clustered and column store indexes on the tables of AdventureWorks database.

Exercise 3 – Implement Semantic Index

In this exercise, you will implement semantic index on the AdventureWorks database tables.

Exercise 4 – Create Filtered Statistics and Full Statistics

In this exercise, you will implement filtered and full statistics on the tables of AdventureWorks database.

Comprehensive Learning

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