Browse Exams — Mock Exams & Practice Tests

1Z0-909 Overview — MySQL 8.0 Database Developer

What 1Z0-909 covers: MySQL 8.0 SQL, schema design, indexes, query optimization, transactions/locking fundamentals, and stored programs (views, triggers, procedures).

On this page

MySQL 8.0 Database Developer focuses on writing correct SQL and building schemas that behave well under real workloads.

What you should be able to do

  • Write correct SELECT queries with joins, subqueries, aggregation, and window-function awareness (concept-level).
  • Design tables with appropriate keys, constraints, and data types; understand normalization trade-offs (concept-level).
  • Create and use indexes effectively and reason about query plan behavior with EXPLAIN.
  • Use transactions correctly and understand isolation/locking at a practical level.
  • Build stored programs (views, procedures/functions, triggers, events) and understand their limitations and pitfalls.
  • Use MySQL 8.0 features commonly used in apps (JSON functions, generated columns, common SQL modes).

Efficient prep strategy

  1. Use the Syllabus as your checklist.
  2. Practice by predicting query outputs and EXPLAIN outcomes for small datasets.
  3. Use the Cheatsheet to lock in patterns and edge-case rules.
Study Plan