Android: SQLite Fundamentals

By Annapurna Agrawal
This course will guide you through how to use Android SQLite to create a database for your application. All the details you need on saving data persistently using SQLite and keeping it private to the application are covered here.
Play course overview
Course info
Level
Beginner
Updated
Nov 25, 2019
Duration
1h 60m
Table of contents
Course Overview
Course Overview 2m
Familiarizing with SQLite
Introducing SQLite 6m Understanding ACID Properties 3m
Defining a Schema and Contract Class
Overview of Demo App 3m Defining Schema and Contract Class 5m
Creating the Database using SQL Helper
Creating Model Class 2m Defining Subclass for SQLiteOpenHelper 4m Writing Code to Create Table 6m
Inserting Data into Database
Introducing Inserting Functionality 7m Validating User Input 4m Inserting Data into SQLite 3m Inserting Data into SQLite Demo 3m
Reading and Displaying Data from the Database
Fetching Data from SQLite Database 5m Working with Cursor 6m Display Data in RecyclerView 6m Using Selection Parameters to Filter Data Part 1 5m Using Selection Parameters to Filter Data Part 2 5m
Modifying Data in SQLite Database
Updating Data in SQLite 8m Updating Data in SQLite Demo 5m Deleting Data in SQLite 4m Deleting Data in SQLite Demo 6m Setting up Project for Migration Part 1 5m Setting up Project for Migration Part 2 4m Migrating SQLite Database Schema 6m
Comparing SQLite Database
Realm vs. Room 3m Why SQLite: Conclusion and References 3m
Description
Course info
Level
Beginner
Updated
Nov 25, 2019
Duration
1h 60m
Description

Most android apps need to save data persistently, like some user settings, structured lists, or files. To save these kinds of data in bulk, android provides full support for SQLite databases which remains private to the app and is persistent until the app is uninstalled. In this course, Android: SQLite Fundamentals, you will learn foundational knowledge of using SQLite in your own app. First, you will learn what SQLite is and how to get started with it. Next, you will discover how to design and create the database and insert data into it for your app. Finally, you will explore how to interact with the data in the database. When you are finished with this course, you will have the skills and knowledge of handling data for your app in a well structured and secure way using SQLite in Android.

About the author
Annapurna Agrawal
About the author

Annapurna is a full stack developer and has experience in Android App and web development. She likes sharing knowledge so that the developers around get boost for their passion.

More from the author
PHP Design Patterns
Intermediate
1h 20m
Feb 14, 2020
Consuming a REST API with Guzzle and PHP
Intermediate
1h 27m
Aug 29, 2019
More courses by Annapurna Agrawal
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi everyone. My name is Annapurna Agrawal, and welcome to my course, Android: SQLite Fundamentals. I'm a full stack developer, and I like Teaching and sharing knowledge. I aim to make your day-to-day development tasks easy. For a very long time, SQLite has been our main choice for storing structured data persistently on mobile. It is a self-contained, serverless, zero-configuration, Android transactional SQL database engine, which is built-in in Android. In this course, we are going to see how to use SQLite to store our app data persistently. Some of the major topics that we will cover include using SQLiteOpenHelper class and the contract class, using cursor to read/write data into the SQLite database, using SQLite methods like insert, update, and delete to work with SQLite, performing database migrations, and we will also discuss why should we use SQLite over other storage options. By the end of this course, you will know all the fundamentals of using SQLite as a persistent storage solution for your Android app. Before beginning the course, you should be familiar with the basics of Android, you should know how to implement RecyclerView into your demo applications, and you should understand how to write SQL queries. I hope you'll join me on this course to learn Android: SQLite Fundamentals, only at Pluralsight.

You're the smartest person in the room

PROVE IT

Your team won't just close the skills gap

THEY'LL HURDLE IT