MySQL 8.0 Certifications
Official Oracle MySQL certifications to validate your database skills
MySQL 8.0 Database Developer
Exam Details
- Exam Code: 1Z0-909
- Cost: $245 USD
- Duration: 90 minutes
- Questions: 60-70 multiple choice
- Passing Score: 63%
How to Take the Exam
- Online proctored or test center
- Register at Pearson VUE
- Preparation: MySQL Developer Guide
- Valid for 5 years
Detailed Syllabus
- MySQL architecture and components
- Connecting to MySQL server
- Using MySQL client programs
- Numeric, string, and temporal data types
- JSON data type and functions
- Built-in functions and operators
- DML statements (SELECT, INSERT, UPDATE, DELETE)
- DDL statements (CREATE, ALTER, DROP)
- Window functions and CTEs (MySQL 8.0)
- Stored procedures and functions
- Triggers and events
- Error handling
- Connectors and APIs
- Transaction handling
- Performance considerations
Official Resources:
Oracle Certification Page |
Pearson VUE Registration
MySQL 8.0 Database Administrator
Exam Details
- Exam Code: 1Z0-908
- Cost: $245 USD
- Duration: 120 minutes
- Questions: 75-85 multiple choice
- Passing Score: 60%
How to Take the Exam
- Online proctored or test center
- Register at Pearson VUE
- Preparation: MySQL Administrator Guide
- Valid for 5 years
Detailed Syllabus
- MySQL server architecture
- Storage engines (InnoDB, MyISAM)
- MySQL 8.0 data dictionary
- Installation methods (binary, package, source)
- Configuration files and variables
- Server options and system variables
- User account management
- Roles and privileges (MySQL 8.0)
- Encryption and SSL configuration
- Logical backups (mysqldump, mysqlpump)
- Physical backups (Enterprise Backup, file copy)
- Point-in-time recovery
- Optimizing queries (EXPLAIN, indexes)
- Server tuning (buffer pools, caches)
- Monitoring tools (Performance Schema, Sys Schema)
- Replication setup and management
- Group Replication (MySQL 8.0)
- InnoDB Cluster
Official Resources:
Oracle Certification Page |
Pearson VUE Registration