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.
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.
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.