Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · SQL Server DBA Tutorials · Integration Services Training
   
Transact SQL Training Videos
Transact SQL Videos By Chapter Home  Subscriber Videos  

Chapter: Views in SQL Server Tutorials - (all chapters)

Video Image Views are omnipresent in SQL Server systems today and with good reason: we can control security through them, optimize our queries, and generally provide a "layer of abstraction" using them. Learn all about views including indexed views in this category.

Versions/Editions Covered: SQL Server 2000
Videos in this Chapter: orange = video series 
blue = individual video 
Click "Download" to download the video or click the video title for more information
TitleSkillView / DownloadLength
Creating and Altering Views in the Enterprise Manager (SQL Server 2000)   200 Download 9 mins.
Views: Introduction, When and Where to Use, and Using the Create View Wizard   100 Download 17 mins.
Miscellaneous Bits & Pieces:
Book You Should Probably Own: Ken Henderson's "The Guru's Guide to SQL Server Architecture And Internals"
Did you know that the database role "ddladmin" can TRUNCATE the table (delete all rows) but not SELECT?
Keyboard Shortcut for SQL Server Management Studio: F8 brings up the always-useful Object Explorer

   
 
About Us Video Playback Subscriptions More Video Training More
 
© Copyright 2004-2008 LearnItFirst.com LLC. All rights reserved. All trademarks remain the property of their respective owners. This site is not affiliated in any way with the Microsoft Corporation. Refer a Friend and Get a Free Subscription!
 
11/20/2008 7:02:21 PM