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 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
Get Sams Teach Yourself SQL in 24 Hours, Second 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.