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
Consuming a REST API with Guzzle and PHP
Intermediate
1h 27m
Aug 29, 2019
Working with Date and Time in PHP
Beginner
2h 16m
Jun 27, 2019
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
[Autogenerated] Hi, everyone. My name is on a bona approval on Welcome to my course on what s you like fundamentals. I'm a four star develop. Oh, and I like teaching and sharing knowledge. I aim to make your day to day development task easy. For a very long time, Escalate has been our main Joyce for storing structure data persistently on mobile. It is a self contained silver less zero configuration under transactional SQL database engine, which is Burton in Android. In this course, we are going to see howto use esque alight to store our AB data Persistently, some off the meter topics that will cover includes using escalate open helper class on the contract class using goes oh to the right data into the Escalade database using SQL methods like insult update on delete to work with the skylight performing DW migrations on. We will also discuss why should we use a skylight over other storage options? By the end of the scores, you will know all the fundamentals off using escalate as a persistent storage solution for your android app. Before beginning the course, you should be familiar with the basics off Android. You should know how to implement recycle of you into your demo applications, and you should understand how to write SQL queries. I hope you'll join me on this goals to loan under an Escalade fundamentals only at your insight.

You're the smartest person in the room

PROVE IT

Your team won't just close the skills gap

THEY'LL HURDLE IT