Hour 20. Creating and Using Views and Synonyms

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
 


Sams Teach Yourself SQL in 24 Hours
Sams Teach Yourself SQL in 24 Hours (5th Edition) (Sams Teach Yourself -- Hours)
ISBN: 0672335417
EAN: 2147483647
Year: 2002
Pages: 275

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net