The Android SDK includes an implementation of SQLite, a simple relational database engine that stores its data in local persistent storage on the device. You can learn about the basic SQLite product at http://www.sqlite.org, but everything you really need is included in the Android SDK, including classes and interfaces you need to program with it, and all of the documentation. The classes and interfaces you use in Android to work with SQLite are all in a single package, android.database.sqlite.
- [Narrator] The Android SDK includes…an implementation of SQLite,…a simple relational database engine…that stores its data…in local persistent storage on the device.…You can learn about the basic SQLite product…at www.sqlite.org, but everything you really need…is in the Android SDK,…including classes and interfaces…you need to program with it,…and all of the documentation.…There is some useful conceptual information on this page…named Saving Data in SQL Databases…on the Android Developer site.…
You'll find information about…defining schema and contracts,…creating databases using an SQL helper class,…and many other useful subjects.…And in order to find the documentation…for the individual classes,…look at the documentation for the package…android.database.sqlite.…Here you'll find information about…which version of Android supports which version of SQLite,…and you'll find references and documentation…for all the different classes and interfaces…that you'll need.…
We'll be using a class named SQLiteOpenHelper,…another one named SQLiteDatabase,…
- Modeling data in POJO classes
- Customizing a ListView item display
- Displaying data in a RecyclerView
- Creating a custom array adapter
- Managing shared preferences with Java
- Creating and importing JSON data files
- Accessing SQLite from the command line
- Retrieving data with SQLite queries
Skill Level Intermediate
Android App Development: Data Persistence Librarieswith Annyce Davis3h 59m Intermediate
Android App Development: RESTful Web Serviceswith David Gassner2h 25m Intermediate
1. Display Static Data
2. Store Data in Shared Preferences
About shared preferences4m 41s
3. Store Data in Text Files
4. Manage Relational Data with SQLite
Next steps1m 43s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.