1Z0-909: Oracle MySQL 8.0 Database Developer

Full Name: Oracle MySQL 8.0 Database Developer

Exam Code: 1Z0-909

Try Sample Exam »

Oracle 1Z0-909 Exam Details:

Exam Name	Oracle MySQL 8.0 Database Developer
Exam Code	1Z0-909
Exam Price	USD $245 (Pricing may vary by country or by localized currency)
Duration	90 minutes
Number of Questions	65
Passing Score	62%
Format	Multiple Choice Questions (MCQ)
Recommended Training	Earn the MySQL 8.0 Database Developer Certified Professional Credential
Sample Questions	MySQL 8.0 Database Developer Oracle Certified Professional
Recommended Practice	1Z0-909 Online Practice Exam

Oracle 1Z0-909 Syllabus Topics:

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