SQLite is the most widely deployed SQL database engine in the world. SQLite is used in common web and mobile applications where simple SQL functions are needed. SQLite allows you to use those functions without having to run a resource heavy database server especially for smaller low scale applications.
This screencast takes you from start to finish of creating a database, implementing it in your PHP script and using it in an application.
Video Producer: http://pinehead.tv/