MariaDB / Basic: relational foundations

MariaDB β€” Basic: relational foundations

Model valid data and write deterministic SQL before changing rows.

6 lessons Β· No account required

What you will learn

  • Explain server, engine, type and key contracts.
  • Read, join, aggregate and mutate synthetic records correctly.

  1. MariaDB server, client and storage engines

    Build a reliable mental model of a MariaDB session before reading or changing data. Distinguish SQL behavior from client behavior and storage-engine guarantees.

    Start learning

  2. Schemas, exact values and multilingual text

    Design a small warehouse table whose types express business meaning. Learn how NULL, strict mode and collation affect stored values and comparisons.

    Start learning

  3. Keys and relational integrity

    Model customers and bookings with explicit identity and valid relationships. Make constraints express real rules rather than patching inconsistent records later.

    Start learning

  4. Filtering and deterministic results

    Translate a warehouse question into a precise SELECT. Control missing values, boolean precedence and ordering before using pagination.

    Start learning

  5. Joins, counts and grouped reports

    Build a customer report without losing empty groups or multiplying totals. Understand the grain of every intermediate relation.

    Start learning

  6. Insert, update and delete with a clear boundary

    Change a training inventory predictably, distinguish duplicate handling strategies and verify the business effect before a commit.

    Start learning
Back to course