New Transact SQL Video Tutorial: Subqueries, Nested Queries, and Derived Tables - An Introduction to Advanced SQL Constructs

Subqueries, Nested Queries, and Derived Tables - An Introduction to Advanced SQL Constructs - view details

Subqueries and derived tables can be some of the hardest constructs for people new to SQL to really grasp. This video is a "First Look" at sub-selects (another word for sub-queries) and the basic concepts of using subqueries in your SELECT statements. Perhaps the most valuable thing that even seasoned query-writers will get from watching this video is the "how"; a major focus of this video is how SQL Server processes subqueries internally. Scott Whigham, author of this site, takes you through how SQL Server will process the subquery in a step-by-step approach.

Note: This video was shot on SQL Server 2005 but the concepts are the same for SQL Server 2000.

Highlights from this video:

• Execution plans: are they different or the same between different subqueries?
• Using a subquery instead of a JOIN and vice-versa
• Correlated subqueries and Simple Subqueries
• Derived Tables; i.e., embedding a SELECT statement in the FROM clause
• Step by step approach to writing subqueries
• SQL Server architecture: Query Processing Sequence

• Category: Subqueries, Nested Queries, and Derived Tables in Transact SQL
• Skill Level: 300 (Intermediate)
• Length: 17:27 (12.7MB)
• Applies to Versions: SQL Server - All Versions
• 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