Company: Pluralsight Author: Annapurna Agrawal Full Title: Android: SQLite Fundamentals Year: 2019 Language: English Genre: Educational: Android Development Skill Level: Beginner Price: - - Files: MP4 (+ Exercise Files, Slides .PDF) Time: 02:02:22 Video: AVC, 1280 x 720 (1.778) at 30.000 fps, 120 kbps Audio: AAC at 96 Kbps, 2 channels, 48.0 KHz 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. Lessons: 1. Course Overview 01. Course Overview 2. Familiarizing with SQLite 02. Introducing SQLite 03. Understanding ACID Properties 3. Defining a Schema and Contract Class 04. Overview of Demo App 05. Defining Schema and Contract Class 4. Creating the Database using SQL Helper 06. Creating Model Class 07. Defining Subclass for SQLiteOpenHelper 08. Writing Code to Create Table 5. Inserting Data into Database 09. Introducing Inserting Functionality 10. Validating User Input 11. Inserting Data into SQLite 12. Inserting Data into SQLite Demo 6. Reading and Displaying Data from the Database 13. Fetching Data from SQLite Database 14. Working with Cursor 15. Display Data in RecyclerView 16. Using Selection Parameters to Filter Data Part 1 17. Using Selection Parameters to Filter Data Part 2 7. Modifying Data in SQLite Database 18. Updating Data in SQLite 19. Updating Data in SQLite Demo 20. Deleting Data in SQLite 21. Deleting Data in SQLite Demo 22. Setting up Project for Migration Part 1 23. Setting up Project for Migration Part 2 24. Migrating SQLite Database Schema 8. Comparing SQLite Database 25. Realm vs. Room 26. Why SQLite: Conclusion and References Our members see more. Join us! ------------- Our members see more. Join us!