Views in SQL Server - What They Are and When to Use Them - Video Series Video Category: T-SQL Basics: Queries, Datatypes, Collations and Unicode, and more Skill Level: 100 (Beginner) Versions/Editions Covered: SQL Server 2005 , SQL Server 2000 , SQL Server 2008 Views are one of the most common SQL object types and are also part of the SQL standard. Knowing (a) what views are, (b) how to use them, and (c) when to use them is vital for anyone who wants to work with any relational database (SQL Server included). This series of videos focuses on everything you need to understand the concepts of what views are, the syntax and tools you can use to create/alter/drop views, and even how to update data in the underlying tables using the view.

Videos in this Series:

Title Skill Length Download Pt. 1 - An Introduction to Using Views in SQL Server   100 8 mins. Download Pt. 2 - Using Views in the Real World   100 12 mins. Download Pt. 3 - Create View Syntax and Creating Views in SQL Server   100 16 mins. Download Pt. 4 - Updateable Views in SQL Server (How to Update the Database Through a Vie...   200 12 mins. Download

< Return to list of all videos

Miscellaneous Bits & Pieces:

Helpful Tools for your SQL Server: Lumigent's Log Explorer is a great tool that allows you to read the transaction log and even undo transactions - very helpful in a crunch Microsoft SQL Server was originally licensed from Sybase in 1989 and proceeded to be a co-operative design until Microsoft SQL Server 7.0 - the first stand-alone version produced solely by Microsoft Helpful Tools for your SQL Server: Be sure to download the "SQL Server 2000 Security Tools" from microsoft.com/sql