Course Description

Prepare to pass exam: MySQL 8.0 Database Developer

An MySQL 8.0 Database Developer Oracle Certified Professional credential acknowledges that the candidate has the required knowledge and skills to use connectors and APIs and how to support data-driven applications using the MySQL database. This certification shows that the professional can design, develop, and maintain MySQL schema objects and control transactions in SQL and applications. It also demonstrates the mastery of the professional on how to optimize query performance, create and execute stored programs, and manage JSON and document store.

To prepare for the MySQL 8.0 Database Developer exam, focus on mastering key concepts such as database design, query optimization, and advanced SQL features. Utilize official Oracle study materials, hands-on practice with MySQL, and engage in community forums to enhance your understanding and skills. Familiarize yourself with the exam format and take practice tests to build confidence and identify areas for improvement.

In addition to foundational knowledge, make sure to explore advanced topics like stored procedures, triggers, and performance tuning to fully grasp the capabilities of MySQL 8.0. Hands-on experience with real-world scenarios will deepen your understanding and help you apply theoretical concepts effectively. Collaborate with peers or join study groups to share insights and resources, which can be invaluable for your exam preparation.

Exam topics covered

Connectors and APIs

• Choose between connectors for a given application
  
• Demonstrate connector use, management and configuration
• Retrieve data from the database by using a connector
• Handle special values
• Secure credentials and connections

Data-driven Applications

• Use prepared statements
  
• Set SQL Modes to change MySQL behavior
• Handle and interpret errors and warnings
• Display query results
• Aggregate and summarize data
• Advanced Report Generation

MySQL Schema Objects and Data

• Design, create, and alter views
  
• Store and process string data
• Store and process numeric data
• Store and process temporal data
• Store and process spatial data

Transactions

• Control transactions in SQL
  
• Control transactions in applications
• Resolve consistency problems with isolation levels
• Understand locking mechanisms within MySQL

Query Optimization

• Use indexes for optimization
• Analyze queries for optimization
• Rewrite queries for optimization

MySQL Stored Programs

• Create and execute stored routines
  
• Explain the programming constructs used in stored routines
• Create and execute triggers
• Schedule database operations

JSON and Document Store

• Create and store JSON documents
  
• Process data in JSON documents
• Explain application development with NoSQL and XDevAPI
• Create and access a document store
• Use MySQL Shell to access document stores