Android Unit Tests and Database Handler

I'm a little lost on how to properly test the database of my Android application. I have my Database Handler which extends SQLiteOpenHelper. Some solutions advise mocking this class, but how will that get me a separate instance of my database? I also see the suggestion to use an in-memory SQLite database but that seems like a lot of unnecessary juggling...

How should I be testing my database? Any help appreciated.