• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

self study for 1Z0-882 - Oracle Certified Professional, MySQL 5.6 Developer

 
Greenhorn
Posts: 26
  • Likes 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
what preparation book do you recommend me?

I can't afford the training "MySQL for Developers" (US$ 2,400).



MySQL Architecture

Use MySQL client programs to interface with the MySQL Server interactively and in batch
Describe SQL Modes and their impact on behavior of MySQL
Identify characteristics which have session scope

General MySQL Syntax

Explain MySQL implementation of identifiers including case sensitivity, qualified names, aliases and use of reserved words
Identify MySQL data type properties and appropriate usage
Recognize and use common functions and expressions for all MySQL data types
Identify and use comment syntax
Describe and utilize prepared statements
Describe transactions and transaction isolation levels and the impact they have on database behavior

Creation and Design of MySQL Schema Objects

Design and create normalized databases
Create and modify tables using appropriate data types and indexing
Describe and create table constraints enforcing data integrity
Creating and modifying views
Identify and use various methods to obtain metadata for MySQL database objects
Creation, Design and Use of MySQL Stored Programs
Describe and use triggers
Create and execute stored procedures
Create and use stored functions
Implement error handling within stored procedures

Querying for Data

Execute a basic SELECT statement
Limit rows returned by a SELECT statement
Limit columns returned by a SELECT statement
Apply sorting to SELECT statement results
Execute SELECT statements which aggregate and group data

Modifying Data

Describe and execute INSERT statements
Describe and execute REPLACE statements
Describe and execute UPDATE statements
Describe and execute TRUNCATE statements
Describe and execute LOAD DATA statements
Describe and execute DELETE statements

Joins, subqueries and UNION

Identify, describe and use JOINs in MySQL commands
Describe and utilize subqueries in MySQL commands
Perform operations using UNION clause

MySQL Application Development

Identify key characteristics, features and options for PHP, Java and .NET development using MySQL standard drivers
Write a basic Java application that uses MySQL
Write a basic PHP application that uses MySQL
Write a basic .NET application that uses MySQL
Interpret MySQL error messages
Collect available diagnostic information

Basic Optimizations

Identify statements requiring optimization
Recognize and create optimal indexes for query optimization
Recognize and fix sub-optimal SQL commands
Identify appropriate optimization strategies for InnoDB usage
Optimize performance through data normalization



exam is new on the market https://blogs.oracle.com/certification/entry/0875_01
 
Bartender
Posts: 3648
16
Android Mac OS X Firefox Browser Java
  • Likes 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I haven't got this cert. Are you familiar with the old exam (v5.5)? If so you may able to use the old study guide and learn the new features.
 
Fazile Moser
Greenhorn
Posts: 26
  • Likes 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

K. Tsang wrote:I haven't got this cert. Are you familiar with the old exam (v5.5)? If so you may able to use the old study guide and learn the new features.



No I am not familar with old exam. The study guide from old exams is from 2005. More than 8 years old.
 
Ranch Hand
Posts: 144
MySQL Database Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Fazile, you are absolutely right. I think most people can not afford that kind of price. Back in 2009, I read two books by Paul DuBois for my certification preperation.

MySQL (4th Edition)

MySQL Study Guide

and I think the best source is MySQL website http://dev.mysql.com/

Hope this will help. Thanks
 
Ranch Hand
Posts: 75
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Oracle Press will release a study guide for 'Oracle Certified Professional, MySQL 5.6 Database Administrator' 1Z0-883.

OCP MySQL 5.6 Database Administrator Exam Guide (Exam 1Z0-883) (All-in-One) | Publication Date: October 22, 2014 | ISBN-10: 0071775781 | ISBN-13: 978-0071775786 | Edition: 1

Why not for developer exam?
 
Greenhorn
Posts: 8
Netbeans IDE Python VI Editor
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I am also seeking resources for this cert. I am in a database class right now, which is really interesting, and we are building our dbs and apps using MySQL 5.6. However, I have had to stitch together several resources on MySQL itself.

Is there anything anyone could recommend for direct practice?
 
reply
    Bookmark Topic Watch Topic
  • New Topic