Sqlite is a database engine that is integrated into the android OS and others as well, e.g., iOS. However, it can be used and manipulated as standard PC software much like mySql.
So perhaps before you dive into all the android java examples, you would be wise to have a top level view of how sqlite works:
1st - Download a copy from
http://www.sqlite.org/download.html for your OS and have a look at the documentation.
2nd - download a free sqlite database browser, one that I have used is:
http://code.google.com/p/sqlite-manager/ This will allow you to create an sqlite database and tables through a GUI without having to use the command line.