Take a very introductory reading like
https://www.udemy.com/blog/sqlite-tutorial/ and continue with searching b4x forum for examples (DBUtils is a great class for this) and Internet for sqlite syntax (
http://www.sqlite.org/lang.html)
There're a several external tools to manage sqlite DB without B4A programming, like Sqlite extension on Mozilla Firefox and BD sqlite browser for Windows; this way, you can learn access programming to sqlite DB from B4A and execute sqlite commands directly on sqlite DB to test the sqlite statements (Querys, creating tables, etc..)