Oracle Certified Associate, MySQL 5
Recently I passed the exam to become an Oracle Certified Associate, MySQL 5. I scored very well with minimal studying.
The Oracle website here gives a good overview of the exam. Obviously I’m not going to give out exam questions and answers but I’ll tell you how I prepared.
The exam was 50 questions and you have 90 minutes to complete it. Time really is not a factor – I’m a slow reader, and I finished in under an hour.
If you are comfortable with select/insert/update/delete, including simple joins, then you’re halfway there. If you have solid experience with SQL, even if it’s with another database, you’re well on your way.
Download and install MySQL. Create databases, users, grant permissions, switch databases, etc etc. You may not need all that but it’s good experience.
Run through this example from Oracle.
Know the common functions: manipulating dates, times, strings, etc.
10% of the test is importing/exporting data. Read all about the various options and practice them.
Know the basic concepts of transactions. I have years experience with this in PL/SQL and I find that the basic concepts transfer over well.
If you do all that and understand what you’re doing, you’ll do fine!