# SQLite vocabulary: Apprentice level

5 SQLite terms at the Apprentice level, each with a short definition and a link to its full page.

Updated: November 19, 2026

[Study these as flash cards](https://www.ask-codey.com/decks/sqlite/apprentice)

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

- Previous level: [Novice](https://www.ask-codey.com/glossary/subjects/sqlite/novice)
- Next level: [Journeyman](https://www.ask-codey.com/glossary/subjects/sqlite/journeyman)

[Every SQLite term, by level](https://www.ask-codey.com/glossary/subjects/sqlite)

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