MySQL / Relational foundations and precise SQL

MySQL β€” Relational foundations and precise SQL

Model the shop and write correct reads and scoped changes.

6 lessons Β· No account required

What you will learn

  • Explain keys, types, NULL, and relationship cardinality.
  • Use joins, aggregates, subqueries, and guarded DML.

  1. Relational thinking and the shop laboratory

    Build a precise model of customers, orders, products, and historical order lines before writing reports.

    Start learning

  2. Selecting, filtering, and missing values

    Turn a business request into a deterministic query and reason about SQL three-valued logic.

    Start learning

  3. Joins and relationship cardinality

    Combine related facts while preserving the intended number of result rows.

    Start learning

  4. Aggregation and questions inside questions

    Summarize the correct population and compare groups without losing the meaning of missing values.

    Start learning

  5. Safe INSERT, UPDATE, and DELETE

    Treat data changes as explicit, reviewable transitions and keep the shared fixture unchanged.

    Start learning

  6. Types, normalization, and schema evolution

    Choose representations that preserve meaning and plan schema changes without assuming DDL is ordinary transactional DML.

    Start learning
Back to course