Video is locked.

Unlock the full course today

Join today to access over 16,000 courses taught by industry experts or purchase this course individually.

Android Development Essential Training: Local Data Storage with Java

Retrieve data with SQLite queries

From the course: Android Development Essential Training: Local Data Storage with Java

Start my 1-month free trial
  • Course details

    Android developers who need to manage and present data have many tools available to them in the application framework of Android. This course covers a variety of data persistence techniques, including storing data in shared preferences—key-value pairs—in JSON-formatted text files, and in relational databases with SQLite. Join David Gassner as he demonstrates these data management techniques. He also explains how to use relevant design patterns to model data with Java classes, and how to present data to the user with the Android SDK's ListView and RecyclerView components.


    • Click here to view David Gassner’s instructor page

      David Gassner

      Managing Staff Instructor, LinkedIn Learning Technology Library at LinkedIn

      David Gassner is the author of over 60 video-based technical training courses for software developers.

      David is a senior staff instructor who specializes in development platforms and programming languages including Android and Java. He currently creates training content for Android developers and content that covers multiple programming languages including Java, C#, Visual Basic, and Go. He was formerly the president and founder of Bardo Technical Services, an Adobe Solutions Network Training Provider. As an Adobe Certified Expert, he wrote courseware for Adobe and delivered extensive training on Flex, ColdFusion, Dreamweaver and Flash. He was the author of Wiley's Flex 3 Bible and Flash Builder 4 and Flex 4 Bible. He most recently designed and developed Audio Cues—an Android app for running sound in live performances—which is available in the Google Play store.

    Skills covered in this course

  • Welcome

    - [Narrator] Once you've inserted data into a database table, the next thing you normally want to do is to retrieve and display the data. I'm working in a new version of the project named retrieved data and I've refactored the code a bit. I used to have all the code to insert data in the main activity class. I've moved that code into the data source class into a method named seed database. It's exactly the same code as before. It checks to see whether there's any data in the database table and if not, it adds all that data in. And this method is now called from the main activities on create method right after instantiating the data source class. Now that I've store the data in the database, I know want to retrieve the data from the database for display instead of using the original sample data. In order to retrieve data, you could use a raw SQL statement, but as I described previously, that would involve a lot of code. And many times you can use the convenience methods of the database…

  • Practice while you learn with exercise files

    Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.

    Download the exercise files for this course. Get started with a free trial today.

  • Download courses and learn on the go

    Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.

    Watch this course anytime, anywhere. Get started with a free trial today.