How to search data using a subselect | lynda.com tutorial

This SQLite tutorial shows how to use a subselect to search data. Watch more at http://www.lynda.com/SQLite-3-with-PHP-tutorials/essential-training/66386-2.html?utm_medium=viral&utm_source=youtube&utm_campaign=videoupload-66386-1203

This specific tutorial is just a single movie from chapter twelve of the SQLite 3 with PHP Essential Training course presented by lynda.com author Bill Weinman. The complete SQLite 3 with PHP Essential Training course has a total duration of 6 hours and covers the fundamentals of SQLite, including a thorough overview of its unique data type system, expressions, functions, transactions, views, and event triggers

SQLite 3 with PHP Essential Training table of contents:

Introduction
1. Quick Start
2. Getting Started
3. Creating a Database
4. SQLite Data Types
5. Storing and Reading Data
6. SQLite Expressions
7. SQLite Core Functions
8. SQLite Aggregate Functions
9. SQLite Date and Time Functions
10. Sorting and Indexing
11. Transactions
12. Subselects and Views
13. Triggers
14. PHP Interfaces
15. A Simple CRUD Application
16. An Application for Web Site Testimonials
Conclusion