MariaDB / Intermediate: concurrency and reusable SQL

MariaDB β€” Intermediate: concurrency and reusable SQL

Coordinate transactions, indexes, named queries, privileges and recoverable backups.

6 lessons Β· No account required

What you will learn

  • Reason about concurrent work and execution plans.
  • Use analytic SQL, least privilege and consistent backup design.

  1. Transactions, snapshots and locking

    Coordinate a two-account transfer and reason about concurrent sessions. Separate snapshot reads from locking reads, and design bounded retries.

    Start learning

  2. Indexes and reading EXPLAIN

    Choose an index for a concrete shipment query and read a plan without inventing benchmark results. Balance lookup benefits against write and storage costs.

    Start learning

  3. Views and common table expressions

    Break complex reports into named relations. Distinguish a persistent view definition from a statement-local CTE and reason about recursive termination.

    Start learning

  4. Window functions and ranking

    Add per-row rankings and running totals without collapsing detail. Make partition, ordering and frame rules explicit.

    Start learning

  5. Accounts, roles and authentication

    Design a narrowly scoped reporting identity without weakening administrator authentication. Separate connection verification from object privileges.

    Start learning

  6. Backup design and logical exports

    Choose backup artifacts from recovery requirements. Understand logical consistency, physical preparation and why a successful backup job is not a restore test.

    Start learning
Back to course