EARTH WEEK
Now through April 22, save up to 70% on digital learning resources. Learn more.
Register your product to gain access to bonus material or receive a coupon.
Accessible from your Account page after purchase. Requires the free QuickTime Player software.
Videos can be viewed on: Windows 8, Windows XP, Vista, 7, and all versions of Macintosh OS X including the iPad, and other platforms that support the industry standard h.264 video codec.
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