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.
See the full benefits of our immersive learning experience with interactive courses and guided career paths.