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 sort view results

How to look at top values

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 live online training, plus books, videos, and digital content from nearly 200 publishers.