Unit 6: Data persistence

• Unit 6 Pathway 1: Introduction to SQL (optional)
  • Unit 6 Pathway 1 Activity 1: Introduction to Databases and SQL
  • Unit 6 Pathway 1 Activity 2: Use SQL to read and write to a database
    • Before you begin
    • Key concepts of relational databases
      • What is a database?
      • What is SQLite?
      • Representing data with SQLite
    • Download the starter data set
      • Use the Database Inspector
    • Read data with a SELECT statement
      • SELECT
      • Read email data using a SELECT statement
    • Use SELECT statements with aggregate functions and distinct values
      • Reduce columns with aggregate functions
      • Filter duplicate results with DISTINCT
    • Filter queries with a WHERE clause
      • Logical operators with WHERE clauses
      • Search for text using LIKE
    • Group, order, and limit results
      • Group results with GROUP BY
      • Sort results with ORDER BY
      • Restrict the number of results with LIMIT
    • Insert, update, and delete data in a database
      • Insert data into a database
      • Update existing data in a database
      • Delete a row from a database
    • Summary
• Unit 6 Pathway 2: Use Room for data persistence
  • Unit 6 Pathway 2 Activity 1: Kotlin Flows in Practice
  • Unit 6 Pathway 2 Activity 2: Flows
    • Kotlin flows on Android
      • Creating a flow
      • Modifying the stream
      • Collecting from a flow
  • Unit 6 Pathway 2 Activity 3: Using Room Kotlin APIs
  • Unit 6 Pathway 2 Activity 4: Persist Data with Room
    • Before you begin
      • Prerequisites
      • What you’ll learn
      • What you’ll build
      • What you need
    • App overview
    • Starter app overview
      • Starter code overview
      • Problems with the starter code
      • Code walkthrough
    • Main components of Room
      • Add Room dependencies
    • Create an item Entity
    • Create the item DAO
    • Create a Database instance
    • Implement the Repository
      • Implement AppContainer class
    • Add the save functionality
      • UI state class walkthrough
      • Update the ItemEntry ViewModel
        • ItemEntryBody() composable walkthrough
      • Add a click handler to the Save button
    • View the database content using Database Inspector
    • Solution code
    • Summary
  • Unit 6 Pathway 2 Activity 5: Read and update data with Room
    • Before you begin
      • Prerequisites
      • What you’ll learn
      • What you’ll build
    • Starter app overview
      • Starter code
    • Update UI state
      • HomeScreen composable function walkthrough
      • Emit UI state in HomeViewModel
    • Display the Inventory data
    • Display item details
    • Implement Item details screen
    • Implement sell item
    • Delete item entity
    • Edit item entity
    • Update item entity
    • Solution code
  • Unit 6 Pathway 2 Activity 6: Practice: Build Bus Schedule app
    • Before you begin
      • Introduction
      • Prerequisites
      • What you’ll need
      • What you’ll build
    • Download the starter code
    • Add dependencies
    • Create a Room entity
    • Create a data access object
    • Create a database instance
    • Update the ViewModel
    • Solution code
• Unit 6 Pathway 3: Store and access data using keys with DataStore (optional)
  • Unit 6 Pathway 3 Activity 1: Introduction to Datastore
  • Unit 6 Pathway 3 Activity 2: Preferences Datastore
  • Unit 6 Pathway 3 Activity 3: Save preferences locally with DataStore
    • Before you begin
      • Introduction
      • Prerequisites
      • What you’ll need
      • What you’ll build
    • Download the starter code
    • Set up dependencies
    • Implement the user preferences repository
      • Write to the DataStore
      • Read from the DataStore
      • Exception handling
    • Initialize the DataStore
    • Use the UserPreferencesRepository
      • Provide the repository to the ViewModel
      • Store the layout preference
      • Read the layout preference
    • Solution code
  • Unit 6 Pathway 3 Activity 4: Project: Create a flight search app
    • Before you begin
      • Prerequisites
      • What you’ll build
      • What you’ll need
    • Overview
    • Get the flights database
    • Plan your app
      • Plan your UI
      • Use Room to integrate the flights database
      • Persist user state with Preferences DataStore
    • Build the Flight Search app
• Unit 6 Quizzies