Android: SQLite Fundamentals

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.
Course info
Rating
(14)
Level
Beginner
Updated
Nov 25, 2019
Duration
1h 59m
Table of contents
Description
Course info
Rating
(14)
Level
Beginner
Updated
Nov 25, 2019
Duration
1h 59m
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
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
Cookies and Sessions in PHP
Intermediate
1h 57m
Sep 23, 2020
PHP Design Patterns
Intermediate
1h 19m
Feb 14, 2020
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.