O'Reilly logo

Sams Teach Yourself Microsoft SQL Server 2005 Express in 24 Hours by Alison Balter

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required