Who should take the Oracle 1Z0-908: MySQL 8.0 Database Exam

This course is designed for Database Administrators and Database production Systems Administrators.

Reference: https://education.oracle.com/mysql-80-database-administrator/pexam_1Z0-908

Topics of Oracle 1Z0-908: MySQL 8.0 Database Exam

The Oracle 1Z0-908 exam tests the abilities and knowledge of the candidates by checking the following objectives:

Architecture

• Understand how InnoDB stores data and logs
• Configure buffers and caches
• Configure client connections to the server
• Understand and use the Data Dictionary
• Understand how MySQL stores data

Server Installation and Configuration

• Start and stop MySQL
• Identify the files and folders created during the installation
• Upgrade MySQL
• Install and use the MySQL server and client programs
• Configure MySQL variables
• Launch multiple MySQL servers on the same host
• Configure MySQL by using options and option files

Security

• Secure the MySQL host environment
• Create user accounts and roles
• Provide the password and login security
• Secure MySQL server connections
• Recognize common security risks
• Use authentication plug-ins
• Configure MySQL Enterprise Firewall
• Encrypt MySQL data
• Control user and role permissions
• Prevent SQL injection attacks

Monitoring and Maintenance

• Troubleshoot problems with locked resources
• Monitor MySQL processes and status
• Configure MySQL Enterprise Audit
• Monitor database growth and explain capacity planning
• Configure and view MySQL log files
• Use MySQL Enterprise Monitor to view activity in MySQL

Query Optimization

• Create indexes to improve server performance
• Analyze queries with MySQL Enterprise Monitor
• Examine how MySQL optimizes queries
• Monitor and understand index statistics

Backups and Recovery

• Distinguish between the different types of backup
• Back up the binary log
• Implement a backup strategy
• Explain when and how to use raw file backups
• Use mysqldump and mysqlpump to perform logical backups
• Backup and restore data with MySQL Enterprise Backup

High Availability Techniques

• Configure a MySQL InnoDB cluster
• Explain the role of replication threads
• Perform an InnoDB cluster recovery
• Explain the role of the binary log in replication
• Describe MySQL InnoDB Cluster and Group Replication
• Explain how replication provides high availability and scalability
• Monitor and troubleshoot replication
• Configure replication
• Configure multisource replication

Oracle 1Z0-908: MySQL 8.0 Database Administrator Certification Path

The Oracle Certified Expert, Oracle 1Z0-908: MySQL 8.0 Database Administrator certification is for Database Development Systems Managers and Database Administrators with at least 1 year of RAC and Grid Infrastructure experience. It is also recommended to understand high availability concepts and clustering. To earn this certificate, you should have the ability to install, manage, monitor, and recover RAC databases, Clusterware, and ASM environments. You will get a complete understanding of the architecture of the Clusterware, ASM, and RAC databases while preparing for the exam with the help of 1Z0-908 practice test. After earning this certification, you will gain the skills of installing, setup, backup and recovery, tuning, and monitoring of these components.

The candidates should have to complete one of the following Certification or Training:

• Certifications:

• Oracle Database 11g Certified Professional

• Oracle Database 12c Certified Professional

• Oracle Certified Expert, Oracle Real Application Clusters 11g and Grid Infrastructure Administrator

• Oracle Database 10g Real Applications Clusters Certified Expert

• Oracle Database Administration 2019 Certified Professional

1Z0-908 practice exams are great sources for the preparation of the exam but they do not meet the requirement of the training. To meet the requirement of the training course must be offered by Oracle University Training Center, Oracle Authorized Education Center, Oracle Authorized Partner, or Oracle Workforce Development Program. Courses can be a live virtual class, training on demand, learning subscription, or instructor-led in-class.