Expected 1Z0-909 Exam Topics, as suggested by Oracle :

• Module 1: Demonstrate connector use, management and configuration/ Secure credentials and connections
• Module 2: Explain application development with NoSQL and XDevAPI/ Handle and interpret errors and warnings
• Module 3: Explain the programming constructs used in stored routines/ Choose between connectors for a given application
• Module 4: Resolve consistency problems with isolation levels/ Set SQL Modes to change MySQL behavior
• Module 5: Use MySQL Shell to access document stores/ Retrieve data from the database by using a connector
• Module 6: Understand locking mechanisms within MySQL/ Control transactions in applications
• Module 7: Create and execute stored routines/ MySQL Schema Objects and Data
• Module 8: Rewrite queries for optimization/ Store and process string data
• Module 9: Analyze queries for optimization/ Aggregate and summarize data/ Data-driven Applications
• Module 10: Create and access a document store/ JSON and Document Store/ Store and process numeric data
• Module 11: Store and process spatial data/ Design, create, and alter views
• Module 12: Schedule database operations/ Store and process temporal data