# SQLite flash cards: Apprentice level

5 SQLite terms at the Apprentice level, as flash cards.

Updated: November 19, 2026

- [Study these as flash cards](https://www.ask-codey.com/decks/sqlite/2/flash)
- [Play Memory with them](https://www.ask-codey.com/games/memory?category=sqlite&level=2)

## Terms in this deck

- [Dot Commands](https://www.ask-codey.com/glossary/dot-commands): Shell commands like .tables and .schema.
- [In-Memory Database](https://www.ask-codey.com/glossary/in-memory-database): A database that exists only in memory.
- [PRAGMA](https://www.ask-codey.com/glossary/pragma): Statements that read or change SQLite settings.
- [ROWID](https://www.ask-codey.com/glossary/rowid): The hidden row number every table has.
- [Type Affinity](https://www.ask-codey.com/glossary/type-affinity): Columns suggest types but don't enforce them.

[Read them in the glossary](https://www.ask-codey.com/glossary/subjects/sqlite/apprentice)

Source: https://www.ask-codey.com/decks/sqlite/apprentice
