Overview

Introduction

The Create and Alter Views 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. Create and Modify Views
  2. Implement Partitioned View

Exercise 1- Create and Modify Views

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

  • Create a view using T-SQL (complex statements)
  • Modify the view

Exercise 2 – Implement Partitioned View

In this exercise, you will create implement partitioned view. To implement a partitioned view, you need to create member tables holding product order details to partition data based on ranges of data values in the product id column. To define the data ranges for each member table, you need to use a CHECK constraint on the product id column.

Comprehensive Learning

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