SQLite / Basic: the embedded engine and correct data

SQLite β€” Basic: the embedded engine and correct data

Understand SQLite connections, types, keys, queries, relationships, and controlled mutations.

6 lessons Β· No account required

What you will learn

  • Distinguish storage semantics from domain rules.
  • Predict query rows and verify changed state.

  1. The embedded engine and connection lifecycle

    Build a SQLite-specific model of SQL execution, connection ownership, private memory databases, files, shell commands, and runtime identity.

    Start learning

  2. Storage classes, affinity, and STRICT tables

    Choose SQLite representations from domain meaning and distinguish flexible affinity conversion from the stronger guarantees of STRICT tables.

    Start learning

  3. Keys, constraints, and foreign-key enforcement

    Model stable identity and relationships with SQLite-specific key rules, explicit nullability, checks, and verified connection-level foreign-key enforcement.

    Start learning

  4. SELECT, NULL, order, and limits

    Turn a business question into a predictable SQLite result using explicit projections, predicates, missing-value logic, and complete ordering.

    Start learning

  5. Joins and trustworthy grouped summaries

    Combine related SQLite rows while tracking multiplicity, missing matches, aggregate denominators, and the distinction between row and group filters.

    Start learning

  6. Safe mutations, RETURNING, and UPSERT

    Express a permitted state transition, verify its affected rows, and distinguish ordinary updates from conflict-resolution behavior that can delete or ignore data.

    Start learning
Back to course