Managing Android App Data with SQLite
Pluralsight
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 Description
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.
-
+
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 23sReading 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 54sFiltering SQL Queries- 34m 50sConnecting SQLite Data to Views with Adapters- 39m 29sPerforming Lifecycle Aware Data Loading with Loaders- 36m 51sDoing More with SQLite Queries- 31m 34sInteracting with SQLite Data- 38m 25s