Always be learning. Invest in you.
Personalized learning experiences, courses taught by real-world professionals.
Start my 1-month free trial

SQLite and Android

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

Unlock the full course today

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

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.


    • David Gassner

      David Gassner

      Managing Staff Instructor, LinkedIn Learning Technology Library at LinkedIn
      View on 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.

      View all courses by David Gassner
  • Welcome

    - [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, 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…

  • 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.

    Download on the App Store
    Get it on Google Play
    Watch this course anytime, anywhere. Get started with a free trial today.

Course Contents