Views in SQL Server - What They Are and When to Use Them - Video Series Video Category: Transact-SQL Basics: Queries, Stored Procedures, Functions 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:

To turn off the system databases and objects inside Enterprise Manager edit the registration by right-clicking the server name and choosing "Edit SQL Server Registration Properties". Uncheck the box at the bottom next to "Show system databases and objects" Many people get confused about licensing for their SQL Server when their SQL Server is used for the company website. Bottom line: buying one license for your SQL Server because the web server is only one user is not sufficient. Microsoft requires that each connection that takes advantage of the data from your SQL Server be licensed. If you see a file/folder that is blue in color in Windows Explorer that is an indication that the file is compressed