SQLite: How to work with relational data | lynda.com tutorial

This SQLite tutorial shows how to access relational data across multiple tables using the JOIN clause. 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-0504

This specific tutorial is just a single movie from chapter five 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