Creating a Database with SQLite, DAO, and Room

This course will teach you how to implement databases into your Android apps so you can query and modify data from within the app itself.
Course info
Rating
(10)
Level
Advanced
Updated
Jun 18, 2021
Duration
1h 10m
Table of contents
Description
Course info
Rating
(10)
Level
Advanced
Updated
Jun 18, 2021
Duration
1h 10m
Your 10-day individual free trial includes:

Expert-led courses

Keep up with the pace of change with thousands of expert-led, in-depth courses.
Description

Most apps today require the ability to query and modify information from a database, making implementation an essential skill. In this course, Creating a Database with SQLite, DAO, and Room, you’ll learn to implement database management into Kotlin apps. First, you’ll explore important database concepts like designing schema. Next, you’ll discover how to implement a database into your app and handle data. Finally, you’ll learn more advanced data handling functions like joining tables and using queries with parameters. When you’re finished with this course, you’ll have the skills and knowledge needed to implement and manage SQLite databases in Kotlin.

About the author
About the author

I'm Anthony Alampi, an interactive designer and developer living in Austin, Texas. I'm a former professional video game developer and current web design company owner with over 15 years of programming experience and over 7 years of design experience. User-centric design is my passion, and I believe that when users come first, they come back! You can view my personal portfolio at: https://www.anthonyalampi.com/

More from the author
Customizing Styles and Themes with Resources
Intermediate
1h 9m
Jul 28, 2021
More courses by Anthony Alampi
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hello there. I'm Anthony Alampi. I'm the owner of X Factor Consultants, a digital design and web consulting company based in Austin, Texas. We design user‑friendly websites and mobile apps for the Android platform. When developing Android apps, you may want your app data to persist between usages. This course is meant to help you learn how to leverage the power of Android's Room API in conjunction with DAOs and SQL databases to do just that. We'll talk about how to develop a schema using Room entities and create a local database that can be accessed via DAOs. Then, we'll query our database with a number of different advanced operations. Finally, we'll discuss how repository patterns can make your app easier to maintain and go on to implement one of our own. Once you've completed this course, you should feel comfortable integrating databases into your own Android apps. I hope you'll join me on this journey to learn more about Android databasing with the Creating a Database with SQLite, DAO, and Room course, at Pluralsight.