PRODUCT SUPPORT ANNOUNCEMENT
See the latest about COVID-19 shipping availability and video/Web Edition load errors. Learn more.
Additional sample videos, individual lessons and other formats are available here.
Register your product to gain access to bonus material or receive a coupon.
Actual product comes full screen and in high resolution.
In Lesson 9 we cover advanced query techniques. We begin with a foundation of the SQL language. We follow that up with a tour of the many special types of queries available to you including self join, union queries, and subqueries. Let’s see what techniques are available for queries. Lesson 9.1: Self-Joins Lesson 9.2: Union Queries Lesson 9.3: Subqueries Lesson 9.4: The Propagation of Nulls and Query Results Lesson 9.5: Using User-Defined Functions with Queries