MSSQL Programming and Query Writing Video Tutorial: Subqueries, N ested Queries, and Derived Tables - An Introduction to Advanced SQL Constr ucts

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

---

• Source: http://www.learnitfirst.com/Course/150/Video/440/Intro-to-Subqueries-Nested-Queries-and-Derived-Tables.aspx
• Course: http://www.learnitfirst.com/Course/150/SQL-2005-Programming.aspx
• Skill Level: 300 (Intermediate)
• Length: 17:27 (12.7MB)
• Full Details

---

To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: synchronized query, sub select, nested query, virtual table, materialize

This video comes from the SQL Server Programming and Queries online training course, SQL Server Programming (SQL Server 2005/2000): Transact SQL. And be sure to check out even more MSSQL Programming and Query Writing training videos.