Sams Teach Yourself SQL in 24 Hours (5th Edition) (Sams Teach Yourself -- Hours)

Team-Fly    
 
Sams Teach Yourself SQL in 24 Hours, Third Edition

By Ronald R. Plew, Ryan K. Stephens

Table of Contents
Part VII.  Summarized Data Structures

Hour 20. Creating and Using Views and Synonyms

During this hour, you learn about performance, as well as how to create and drop views, how to use views for security, and how to provide simplicity in data retrieval for end users and reports . You also will read a discussion on synonyms.

The highlights of this hour include

  • What views are

  • How views are used

  • Views and security

  • Storage of views

  • Creating views

  • Joining views

  • Data manipulation in a view

  • What synonyms are

  • Managing synonyms

  • Creation of synonyms

  • Dropping synonyms

Team-Fly    
Top
 

Related

Категории