Hour 20
Creating and Using Views and Synonyms
What You’ll Learn in This Hour:
▶ Defining views and seeing how they are used
▶ Enhancing security with views
▶ Storing, creating, and joining views
▶ Manipulating data in a view
▶ Using nested views
▶ Managing 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.
Defining Views
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 actually a composition of a table in the form of ...
Get SQL in 24 Hours, Sams Teach Yourself, 7th 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.
