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.
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.
Table of contents
- Introduction 1m
- SQLite Key Concepts 3m
- Designing Your App Tables 4m
- Database Contract Class 1m
- Implementing the Contract Class 3m
- Describing Table Columns 5m
- Adding Column Descriptions to the Contract Class 2m
- Primary Key and Framework Friendly Tables 2m
- Making Your Database Framework Friendly 1m
- Database Creation and Access 4m
- Implementing the Database Open Helper 7m
- Creating the Database 4m
- Verifying Database Structure and Content 8m
- Summary 2m
- Introduction 1m
- Your App Plan 2m
- Accessing Data 2m
- Querying CourseInfo Table 4m
- Querying NoteInfo Table and Connecting Queries to MainActivity 4m
- Move Through Results 4m
- Accessing Result Column Values 3m
- Loading Courses 5m
- Loading Notes and Testing Your App 5m
- Ordering Results 2m
- Ordering Courses and Notes 5m
- Summary 2m
- Introduction 1m
- Your Plan for Populating Course Spinner 1m
- CursorAdapter and SimpleCursorAdapter 3m
- Populating a Spinner with a SimpleCursorAdapter 5m
- Connecting a Cursor to the SimpleCursorAdapter 4m
- Selecting an Item in a SimpleCursorAdapter Populated Spinner 7m
- Using a Cursor with RecyclerView Adapter 4m
- RecyclerView Adapter Cursor Management 3m
- Displaying Cursor Data with a RecyclerView Adapter 4m
- Connecting a Cursor to a RecyclerView Adapter 5m
- Summary 2m
- Introduction 1m
- Making Data Changes 1m
- Updating Data 4m
- Adding Note Update Method 4m
- Saving Changes to a Note 6m
- Inserting and Deleting Data 2m
- Note Database Operations in Your App 2m
- Inserting a New Note 6m
- Deleting Unused Note 4m
- Database Interaction and Activity UI 3m
- Interacting with the Database Using AsyncTask 4m
- Summary 2m
About the author
Jim Wilson is president of JW Hedgehog, Inc., a consulting firm specializing in solutions for the Android, iOS, and Microsoft platforms. Jim has over 30 years of software engineering experience, with the past 15 years heavily focused on creating mobile device and location-based solutions. He has co-founded multiple software-related startups and has served in a consulting role at several more. After nearly a decade as a Microsoft Device Application Development MVP, Jim now focuses on developing A... more