New Transact SQL Video Tutorial: Views: Introduction, When and Where to Use, and Using the Create View Wizard

Views: Introduction, When and Where to Use, and Using the Create View Wizard - view details

Views are one of the most popular techniques to access data in the database. This video is the perfect introduction to the view which is really nothing more than a stored query. When should you use views? How do you create views? What happens to the data when you remove the view from the database? All of these questions and more are answered in this great video from our author, Scott Whigham.

Highlights from this video:

• Best Practices for Using Views
• Designing Manageable and Reusable SQL
• Using Views to Control Security and Data Access
• Using the Enterprise Manager to Create/Manage Views
• CREATE VIEW syntax
• ANSI-89 vs. ANSI-92 JOIN syntax (SQL-1 vs. SQL-2)
• Designing Views with the Query Designer
• CROSS JOINs and How to Run Out of Disk Space Quickly
• Why You Should Always, Always, Always Test Your Queries Before Posting to Production
• Internal Acrhitecture of Query Analyzer

Note: This should be considered a "Must-See" video for all newbies!

• Category: Views in SQL Server
• Skill Level: 100 (Beginner)
• Length: 17:00 (9.45MB)
• Applies to Versions: SQL Server 2000
• Full Details

---

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required

Note: You must have the TSCC codec installed to view this video