MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

Managing Android App Data with SQLite

Course Summary

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 Syllabus

    Understanding SQLite and SQLite Database Creation
    - 48m 54s

    —Introduction 1m 0s
    —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
    Reading Data from SQLite
    - 38m 26s

    —Introduction 0m 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
    Filtering SQL Queries
    - 34m 50s
    Connecting SQLite Data to Views with Adapters
    - 39m 29s
    Performing Lifecycle Aware Data Loading with Loaders
    - 36m 51s
    Doing More with SQLite Queries
    - 31m 34s
    Interacting with SQLite Data
    - 38m 25s

Course Fee:
USD 29

Course Type:


Course Status:



1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url