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)