Re: SQLIte, OReilly is coming out with a new book, Using SQLite, in August. It's not clear to me how much of an introduction it offers to SQL (versus SQLite specifics), but I'm guessing there's some introductory material in there as well.

http://oreilly.com/catalog/9780596521196/