HOUR 11. Creating Complex Views
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
Creating Views Based on Data in Multiple Tables
Get Sams Teach Yourself Microsoft SQL Server 2005 Express in 24 Hours 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.
