Home > Store > Data > Access

Advanced Query Techniques, Downloadable Version

Advanced Query Techniques, Downloadable Version

Downloadable Video

  • Your Price: $5.99
  • About this video
  • 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.

Additional sample videos, individual lessons and other formats are available here.

Register your product to gain access to bonus material or receive a coupon.

Audio & Video

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Description

  • Copyright 2014
  • Edition: 1st
  • Downloadable Video
  • ISBN-10: 0-13-378640-4
  • ISBN-13: 978-0-13-378640-8

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

Updates

Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership