Ideas for introducing databases to Android development students I teach an Android development course to students who have had two full years of Java experience - including a year of data structures.  In the past, my students have used services such as Firebase, Parse, and Couchbase to store their data.  

Recently, I've had some experience with Cupboard for Android (https://bitbucket.org/littlerobots/cupboard) which maps Java classes to database tables and maps Java class member variables to the table columns.  Cupboard allowed me to create, modify, delete, and query my SQLite database using instantiated objects instead of writing SQL every time.

Now I have a new interest in learning SQLite and in turn teaching it to my students.  I am looking for recommendations of resources for an intro unit on SQLite.
SQlite is small and as the name suggest "lite" is great for storing data for mobile applications. Apart from that It can easily be used for other small scale web applications without hiccups (100k or more rows). 

Resources


The official guide is great. Also checkout the reference of the sqlite package once you are comfortable with using SQlite.
Here's a tutorial that provides step-by-step guide. 
Also the sqlite page have some docs for Android Bindings.


That said, SQlite is one of the most tested(tests are larger than code itself) and have a brilliant code base which makes it very suitable for mobile applications.