tailieunhanh - Instructor Inputs - Session 10

Begin the session by sharing the objectives with the students. Slide 2 Querying and Managing Data Using SQL Server 2005 Creating Views A View is: Used to view data from tables Similar to creating tables but it does not contain any data as it derives its data from the underlying tables Created by using CREATE VIEW statement | Instructor Inputs Session 10 Session Overview This session includes sections two and three of Chapter 6 and section one of Chapter 7 of the Student Guide. Slide 1 Querying and Managing Data Using SQLServer 2005 Objectives Ver. V In this session you will learn to r Create and manage views Implement a full-text search Implement batches Session 10 Slide 1 of 31 Begin the session by sharing the objectives with the students. Slide 2 Querying and Managing Data Using SQL Server 2005 _ _ Creating Views A View is r Used to view data from tables r Similar to creating tables but it does not contain any data as it derives its data from the underlying tables r Created by using CREATE VIEW statement Syntax CREATE VIEW viewname Ver. column_name column_name . WITH ENCRYPTION SCHEMABINDING AS select_statement WITH CHECK OPTION Let s see how. Session 10 Slide 2 of 31 NUT Instructor Inputs .