Android: SQLite Fundamentals

Focused View

Annapurna Agrawal

2:02:22

11 View

1. Course Overview

1. Course Overview.mp4

01:46

2. Familiarizing with SQLite

1. Introducing SQLite.mp4

05:44

2. Understanding ACID Properties.mp4

02:57

3. Defining a Schema and Contract Class

1. Overview of Demo App.mp4

03:28

2. Defining Schema and Contract Class.mp4

05:21

4. Creating the Database using SQL Helper

1. Creating Model Class.mp4

01:43

2. Defining Subclass for SQLiteOpenHelper.mp4

03:42

3. Writing Code to Create Table.mp4

06:02

5. Inserting Data into Database

1. Introducing Inserting Functionality.mp4

06:54

2. Validating User Input.mp4

04:18

3. Inserting Data into SQLite.mp4

03:05

4. Inserting Data into SQLite Demo.mp4

03:10

6. Reading and Displaying Data from the Database

1. Fetching Data from SQLite Database.mp4

05:19

2. Working with Cursor.mp4

06:04

3. Display Data in RecyclerView.mp4

06:22

4. Using Selection Parameters to Filter Data Part 1.mp4

05:26

5. Using Selection Parameters to Filter Data Part 2.mp4

04:42

7. Modifying Data in SQLite Database

1. Updating Data in SQLite.mp4

07:34

2. Updating Data in SQLite Demo.mp4

05:08

3. Deleting Data in SQLite.mp4

03:47

4. Deleting Data in SQLite Demo.mp4

06:19

5. Setting up Project for Migration Part 1.mp4

05:07

6. Setting up Project for Migration Part 2.mp4

05:07

7. Migrating SQLite Database Schema.mp4

05:07

8. Comparing SQLite Database

1. Realm vs. Room.mp4

05:07

2. Why SQLite - Conclusion and References.mp4

03:03

Description

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.

What You'll Learn?

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Android Development

SQLite

Annapurna Agrawal

Instructor's Courses

Annapurna is a full stack developer, who has now been playing around with Kotlin, PHP, jQuery, CSS, and HTML. She is a software engineer from India and likes teaching and has years of experience in web and mobile development. She is one of the trainers in the Google Developers Group at Bhubaneswar, Odisha in India and also the lead of the Google WomenTechMaker Group Bhubaneswar. Besides all this, she practices yoga and meditation, YouTubing, and hanging out with friends. You are definitely going to get the best of quality here from her. Stay tuned and keep smiling!

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.