June 2006
Beginner
456 pages
10h 3m
English
Now that you’ve learned the basics of creating and working with views, you’re ready to move on to more advanced techniques. These techniques enable you to fully harness the power of views and what they have to offer. In this hour you’ll learn:
• How to create views based on data in multiple tables
• How to work with views and subqueries
• How to add outer joins to a view
• How to utilize functions in the views that you create
• How to use views to secure data
• How to modify data in a view
• How to modify, rename, and delete views
• How to work with indexed views
• How to optimize the views that you build
Read now
Unlock full access