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:

  • Working with Views
  • Encrypting the Text of The View

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

Exercise 1 - Working with Views

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

  • Creating views
  • Altering views
  • Dropping views
  • Creating indexed views
  • Encrypting view’s definition

Exercise 2 - Encrypting the text of the view

You can encrypt the text of the CREATE VIEW statement using the WITH ENCRYPTION option. This prevents users from viewing the statement even if they have a SYSADMIN role.

Comprehensive Learning

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