Advanced Query Techniques, Downloadable Version
- By Alison Balter
- Published Dec 16, 2013 by Sams. Part of the LiveLessons series.
Downloadable Video
- Sorry, this book is no longer in print.
- 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.
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