You can use PSpad for writing SQL lite scripts, you can assign some command line tool as compiler to run your scripts directly from PSPad and catch output.
Where to find basics? I don't know. Use google to find informations: http://www.google.cz/search?q=sql+lite+basics -- <http://forum.pspad.com/read.php?2,57432,57433> PSPad freeware editor http://www.pspad.com
