Did you have a look at chapter 3 SQLite Database in the User's Guide ?
There you find a full example with explanations.
Another example is here SQLiteDB.
You should also have a look at the SQLiteViewer.
You should also use the search function just below the Basic4Android logo.