Sqlite

A great tutorial that covers the sqlite syntax as well of apis for various languages can be found here.
http://www.tutorialspoint.com/sqlite/sqlite_overview.htm