- Course
Managing Android App Data with SQLite
Persistent data storage is at the heart of most modern applications. In this course, you will learn how to use SQLite, the most widely used persistent data storage solution for Android.
- Course
Managing Android App Data with SQLite
Persistent data storage is at the heart of most modern applications. In this course, you will learn how to use SQLite, the most widely used persistent data storage solution for Android.
Get started today
Access this course and other top-rated tech content with one of our business plans.
Try this course for free
Access this course and other top-rated tech content with one of our individual plans.
This course is included in the libraries shown below:
- Core Tech
What you'll learn
SQLite is the persistent storage solution of choice for the overwhelming majority of Android applications. In this course, Managing Android App Data with SQLite, you'll learn how to create Android applications that effectively leverage the persistent storage capabilities of SQLite. First, you'll explore how to create and access a SQLite database in a way that conforms to the standards and best practices of Android app development. Next, you'll dig into the rich query capabilities of SQLite including row selection criteria and row ordering. Then, you'll discover how to use adapters to connect SQLite data to views like RecyclerView, Spinner, and ListView. Additionally, you'll walk through how to perform lifecycle aware queries using LoaderManager and CursorLoader. Finally, you'll learn how to update, delete, and insert data within a SQLite database, including how to maintain a responsive user experience. By the end of this course, you'll have the skills and knowledge to create Android applications of your own that persistently manage data within a SQLite database.
Managing Android App Data with SQLite
-
Introduction | 1m
-
SQLite Key Concepts | 3m 25s
-
Designing Your App Tables | 4m 1s
-
Database Contract Class | 1m 20s
-
Implementing the Contract Class | 3m 21s
-
Describing Table Columns | 4m 55s
-
Adding Column Descriptions to the Contract Class | 1m 54s
-
Primary Key and Framework Friendly Tables | 1m 49s
-
Making Your Database Framework Friendly | 1m 26s
-
Database Creation and Access | 4m 5s
-
Implementing the Database Open Helper | 6m 54s
-
Creating the Database | 3m 53s
-
Verifying Database Structure and Content | 8m 21s
-
Summary | 2m 23s
-
Introduction | 46s
-
Your App Plan | 1m 43s
-
Accessing Data | 1m 43s
-
Querying CourseInfo Table | 4m 19s
-
Querying NoteInfo Table and Connecting Queries to MainActivity | 3m 39s
-
Move Through Results | 4m 4s
-
Accessing Result Column Values | 3m 15s
-
Loading Courses | 4m 32s
-
Loading Notes and Testing Your App | 5m 29s
-
Ordering Results | 1m 58s
-
Ordering Courses and Notes | 4m 58s
-
Summary | 1m 54s