Hour 20. Creating and Using Views and Synonyms
What You’ll Learn in This Hour:
• What views are
• How views are used
• Views and security
• Storing views
• Creating views
• Joining views
• Data manipulation in a view
• Performance of nested views
• What synonyms are
• Managing synonyms
• Creating synonyms
• Dropping synonyms
In 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. This hour also includes a discussion on synonyms.
What Is a View?
A view is a virtual table. That is, a view looks like a table and acts like a table as far as a user is concerned, but it doesn’t require physical storage. A view is ...
Get Sams Teach Yourself SQL in 24 Hours, Fifth Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
