Overview

Introduction

The Working with Views module provides you with the instruction and server hardware to develop your hands on skills in the defined topic. This module includes the following exercise:

Learning Outcomes

In this module, you will complete the following exercises:

  • Exercise 1 - Creating a View using Transact SQL

After completing this lab, you will be able to:

  • Create views with Transact-SQL

Exam Objectives

The following exam objective is covered in this lab:

  • 1.3 Understand when to use views and how to create a view by using T-SQL

Lab Duration

It will take approximately 20 minutes to complete this lab.

Exercise 1 - Creating a View using Transact SQL

Views are virtual tables that help you to provide a convenient way of looking at information from two or more joined tables or a subset of data from a single table. You can define the rows and columns of the view through a SELECT query. In other words, views are nothing but stored SELECT statements.

Unlike the table data, the database does not store the view data but stores only its definition. It recreates the data using the SELECT statement in the view's definition whenever you query a view. If a view contains more columns, and if it performs more joins, the view becomes slower. It is good to use finite number of columns with fewer joins as possible when creating views.

Learning Outcomes

After completing this exercise you will be able to:

  • Create views with Transact-SQL

Comprehensive Learning

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