Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · SQL DTS Training Videos · SQL Programming Videos
   
SQL Server 2000 Training Videos
SQL Server 2000 Videos in Series Home  Subscriber Videos  

Views in SQL Server - What They Are and When to Use Them (Video Series)

Video Image 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:


Miscellaneous Bits & Pieces:
SQL Server 2000 Resource Kit - More Helpful Tools: SQL DMO has many nice examples of using DMO to script your SQL Server administration
Security Tip: Be very wary of assigning logins to be members of any of the fixed server roles. The server roles in SQL Server 7.0 and 2000 have a few "holes": did you know that any member of a server role can indescriminately make other logins members of that same role? Another gotcha: the Database Creators role allows its members to drop any database!
You can use the "SQL Server 2000 Web Services Toolkit" to work with XML Data and web services with your SQL Server. Check out Microsoft's Download page and search for "SQL Server 2000 Web Services Toolkit" for more

Other Websites We Offer
LearnSqlServer.com
Don't Forget!
Become a Guru
 
   
 
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 3:21:34 PM