Introduction
                                    
                                        Welcome
                                            
                                                ()
                                            
                                            
                                    
                                    
                                        What you should know
                                            
                                                ()
                                            
                                            
                                    
                                    
                                        Using the exercise files
                                            
                                                ()
                                            
                                            
                                    
                                    
                                        Review the starting app
                                            
                                                ()
                                            
                                            
                                    
                             
                            
                                1. SQLite Basics
                                    
                                        Overview of SQLite
                                            
                                                ()
                                            
                                            
                                    
                                    
                                        Define a database table's schema
                                            
                                                ()
                                            
                                            
                                    
                                    
                                        Define a Database SQLite open helper
                                            
                                                ()
                                            
                                            
                                    
                                    
                                        Explore SQLite create table syntax
                                            
                                                ()
                                            
                                            
                                    
                                    
                                        Execute create table statements
                                            
                                                ()
                                            
                                            
                                    
                                    
                                        Create a database wrapper
                                            
                                                ()
                                            
                                            
                                    
                                    
                                        Explore the ContentValues class
                                            
                                                ()
                                            
                                            
                                    
                                    
                                        Insert data into a table
                                            
                                                ()
                                            
                                            
                                    
                                    
                                        Insert data with a foreign key relation
                                            
                                                ()
                                            
                                            
                                    
                             
                            
                                2. SQLite Beyond the Basics
                                    
                                        Inspect the database using a terminal
                                            
                                                ()
                                            
                                            
                                    
                                    
                                        Inspect the database using GUI tools
                                            
                                                ()
                                            
                                            
                                    
                                    
                                        Explore SQLite queries
                                            
                                                ()
                                            
                                            
                                    
                                    
                                        Query data using a raw query
                                            
                                                ()
                                            
                                            
                                    
                                    
                                        Parse cursors and display data in the UI
                                            
                                                ()
                                            
                                            
                                    
                                    
                                        Update records in a table
                                            
                                                ()
                                            
                                            
                                    
                                    
                                        Delete records from a table
                                            
                                                ()
                                            
                                            
                                    
                             
                            
                                3. Working with Room
                                    
                                        Overview of Room
                                            
                                                ()
                                            
                                            
                                    
                                    
                                        Defining database entities
                                            
                                                ()
                                            
                                            
                                    
                                    
                                        Defining a Room database
                                            
                                                ()
                                            
                                            
                                    
                                    
                                        Create a data access object
                                            
                                                ()
                                            
                                            
                                    
                                    
                                        Working with the @Insert annotation
                                            
                                                ()
                                            
                                            
                                    
                                    
                                        Insert data into a table
                                            
                                                ()
                                            
                                            
                                    
                                    
                                        Explore Room queries
                                            
                                                ()
                                            
                                            
                                    
                                    
                                        Query data and display in a RecyclerView
                                            
                                                ()
                                            
                                            
                                    
                                    
                                        Create observable queries
                                            
                                                ()
                                            
                                            
                                    
                                    
                                        Create a schema migration
                                            
                                                ()
                                            
                                            
                                    
                             
                            
                                4. Working with Cupboard
                                    
                                        Overview of Cupboard
                                            
                                                ()
                                            
                                            
                                    
                                    
                                        Define a database schema
                                            
                                                ()
                                            
                                            
                                    
                                    
                                        Insert data into a table
                                            
                                                ()
                                            
                                            
                                    
                                    
                                        Introduction to converters
                                            
                                                ()
                                            
                                            
                                    
                                    
                                        Store lists as JSON using converters
                                            
                                                ()
                                            
                                            
                                    
                                    
                                        Query data and display in a RecyclerView
                                            
                                                ()
                                            
                                            
                                    
                                    
                                        Update records in a table
                                            
                                                ()
                                            
                                            
                                    
                                    
                                        Delete records from a table
                                            
                                                ()
                                            
                                            
                                    
                                    
                                        Create a schema migration
                                            
                                                ()
                                            
                                            
                                    
                             
                            
                                5. Realm Basics
                                    
                                        Introduction to Realm
                                            
                                                ()
                                            
                                            
                                    
                                    
                                        Configure a Realm instance
                                            
                                                ()
                                            
                                            
                                    
                                    
                                        Create a Realm object class
                                            
                                                ()
                                            
                                            
                                    
                                    
                                        Insert data into Realm
                                            
                                                ()
                                            
                                            
                                    
                                    
                                        View your data with the Realm browser
                                            
                                                ()
                                            
                                            
                                    
                             
                            
                                6. Realm Beyond the Basics
                                    
                                        Create relationships between objects
                                            
                                                ()
                                            
                                            
                                    
                                    
                                        Explore Realm queries
                                            
                                                ()
                                            
                                            
                                    
                                    
                                        Query Realm objects
                                            
                                                ()
                                            
                                            
                                    
                                    
                                        Display data in a RecyclerView
                                            
                                                ()
                                            
                                            
                                    
                                    
                                        Explore Realm updates
                                            
                                                ()
                                            
                                            
                                    
                                    
                                        Update Realm objects
                                            
                                                ()
                                            
                                            
                                    
                                    
                                        Delete Realm objects
                                            
                                                ()
                                            
                                            
                                    
                                    
                                        Explore Realm migrations
                                            
                                                ()
                                            
                                            
                                    
                                    
                                        Create a schema migration
                                            
                                                ()
                                            
                                            
                                    
                             
                            
                     
                        
                                
                                    Ex_Files_Android_App_Data_Persist.zip
                                    
                                        (45.0 MB)