MySQL / Reliable applications and analytical queries

MySQL β€” Reliable applications and analytical queries

Connect isolation, constraints, plans, reusable relations, analytics, and security.

6 lessons Β· No account required

What you will learn

  • Reason about transaction boundaries and concurrent visibility.
  • Design indexes, read EXPLAIN, use CTEs and windows, and bind values safely.

  1. InnoDB transactions and isolation

    Understand what commits together, what a snapshot sees, and why a correct single-session script can fail under concurrency.

    Start learning

  2. Constraints and purposeful indexes

    Enforce valid relationships while selecting indexes from actual query shapes and write costs.

    Start learning

  3. Reading EXPLAIN without guessing

    Separate estimated access paths, measured execution, and logical query results.

    Start learning

  4. Views, CTEs, and recursive reasoning

    Name intermediate relations without assuming they are cached tables or automatic optimization barriers.

    Start learning

  5. Window functions and analytical frames

    Calculate ranks and running values while retaining individual order rows.

    Start learning

  6. Accounts, roles, and safe query construction

    Apply least privilege and bind values without confusing them with SQL identifiers.

    Start learning
Back to course