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

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

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


Miscellaneous Bits & Pieces:
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.
Keyboard Shortcut for Query Analyzer: CTRL+L shows the estimated execution plan
Helpful Tools for your SQL Server: Check out Microsoft's Best Practices Analyzer Tool - a free download from microsoft.com/sql

Other Websites We Offer
LearnSharePoint.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!
 
9/7/2008 9:20:47 PM