| 1 | What is sqflite, and how does it let you actually use a genuinely full relational SQLite database directly within a Flutter app? Flutter › SQLite & Local Databases (sqflite) | Flutter | SQLite & Local Databases (sqflite) | Beginner |
| 2 | How do you use SQLite for local relational data in MAUI? .NET MAUI › Local Storage & Data | .NET MAUI | Local Storage & Data | Intermediate |
| 3 | How do you use EF Core with SQLite in a MAUI app? .NET MAUI › Local Storage & Data | .NET MAUI | Local Storage & Data | Intermediate |
| 4 | How do you use SQLite for local relational data in MAUI? .NET MAUI › Local Storage & Data | .NET MAUI | Local Storage & Data | Intermediate |
| 5 | How do you use EF Core with SQLite in a MAUI app? .NET MAUI › Local Storage & Data | .NET MAUI | Local Storage & Data | Intermediate |
| 6 | What are the genuine practical tradeoffs of choosing Hive over SQLite specifically for a Flutter app that genuinely needs to store a fairly large, genuinely complex, and highly relational dataset? Flutter › Hive & NoSQL Local Storage | Flutter | Hive & NoSQL Local Storage | Advanced |
| 7 | How do you properly create a table and perform basic insert, query, update, and delete operations using sqflite's own available methods? Flutter › SQLite & Local Databases (sqflite) | Flutter | SQLite & Local Databases (sqflite) | Beginner |
| 8 | How do you properly implement database migrations in sqflite, correctly handling a schema change such as adding a genuinely new column when a user actually updates to a newer version of your app? Flutter › SQLite & Local Databases (sqflite) | Flutter | SQLite & Local Databases (sqflite) | Intermediate |
| 9 | How do you properly perform a JOIN query in sqflite to combine genuinely related data stored across two or more separate distinct tables, such as combining orders together with their own individual customer information? Flutter › SQLite & Local Databases (sqflite) | Flutter | SQLite & Local Databases (sqflite) | Intermediate |
| 10 | How should you properly organize your sqflite database access code using a dedicated database helper class, keeping your genuine SQL related logic properly and cleanly separated from the rest of your app's own business logic? Flutter › SQLite & Local Databases (sqflite) | Flutter | SQLite & Local Databases (sqflite) | Intermediate |
| 11 | How can you properly optimize sqflite query performance for a genuinely large dataset using database indexes, and what genuine tradeoffs come together with actually adding an index to a given specific table? Flutter › SQLite & Local Databases (sqflite) | Flutter | SQLite & Local Databases (sqflite) | Advanced |
| 12 | How should you properly implement database transactions in sqflite to ensure several genuinely related separate operations either all fully succeed together, or all genuinely fail together entirely, maintaining your overall data's own genuine consistency? Flutter › SQLite & Local Databases (sqflite) | Flutter | SQLite & Local Databases (sqflite) | Advanced |
| 13 | What is Hive, and how does it provide a genuinely lightweight, fast local NoSQL database option specifically for storing structured data directly on a user's own device? Flutter › Hive & NoSQL Local Storage | Flutter | Hive & NoSQL Local Storage | Beginner |
| 14 | How should you properly design your repository layer to genuinely support offline first behavior, correctly falling back to previously cached data whenever the device genuinely currently has no active internet connection? Flutter › REST API Integration in Flutter | Flutter | REST API Integration in Flutter | Intermediate |
| 15 | How do you design an offline-first sync strategy in MAUI? .NET MAUI › Local Storage & Data | .NET MAUI | Local Storage & Data | Advanced |
| 16 | How do you protect data at rest in a MAUI app? .NET MAUI › Local Storage & Data | .NET MAUI | Local Storage & Data | Advanced |
| 17 | How do you design an offline-first sync strategy in MAUI? .NET MAUI › Local Storage & Data | .NET MAUI | Local Storage & Data | Advanced |
| 18 | How do you protect data at rest in a MAUI app? .NET MAUI › Local Storage & Data | .NET MAUI | Local Storage & Data | Advanced |
| 19 | How should you properly handle schema migration in Hive when you genuinely need to add, remove, or meaningfully change a specific field on an already existing HiveObject class after your app has genuinely already been released to real actual users? Flutter › Hive & NoSQL Local Storage | Flutter | Hive & NoSQL Local Storage | Advanced |