Free 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 - download

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!

---

• Source: http://www.LearnTransactSQL.com
• Category: SQL Server Videobooks
• Skill Level: 100 (Beginner)
• Length: 17:00 (9.45MB)
• Source Videobook Entry (Subscriber-only version)

---

To download this video, visit the Free Videos page, click "download" and enter the correct security code.

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

---

Keywords Associated with this video: , beginner, beginning, for beginners, introduction, step by step