Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 9

Displaying posts with tag: MySQL Certification (reset)

Triggers — MySQL 5.6 and 5.7
Employee +4 Vote Up -0Vote Down

MySQL Triggers are changing in 5.7 in a big way. Triggers have been around since 5.0 and have not changed much up to 5.6 but will gain the ability to have multiple triggers on the same event. Previously you had ONE trigger maximum on a BEFORE UPDATE, for example, and now you can have multiple triggers and set their order.

So what is a trigger? Triggers run either BEFORE or AFTER an UPDATE, DELETE, or INSERT is performed. You also get access to the OLD.col_name and NEW.col_name variables for the previous value and the newer value of the column.

So how do you use a trigger? Let say you are updating the price of an inventory item in a product database with a simple UPDATE statement. But you also want to track when the

  [Read more...]
MySQL 5.6 Beta Exam Results
Employee +1 Vote Up -0Vote Down

Congratulations on earning your Oracle Certification credential! — I was happily surprised to see this on the first email of the day. My employer sends out a fair share of corporate correspondence and I will admit to being caffeine deprived early this morning when I started reading my emails. I was expecting some rote corporate communication and i had to read the first sentence twice. So it took a moment for it to sink in that I PASSED THE 5.6 MySQL DBA EXAM!!!!!

The exam was tough — much more comprehensive than any previous exam — and there were a handful of questions that left this long time user of MySQL wondering where the heck did they find that material.

So if you took a 5.6 beta exam, your results are probably in your inbox right now. Congrats to those who earned their new certifications!

  [Read more...]
MySQL 5.6 DBA Beta Exam IS TOUGH!
Employee +1 Vote Up -0Vote Down

I have just finished the MySQL 5.6 DBA Certification Exam Beta and my best advice is to study, study, study. The exam is in beta which means three things. The first is the exam is three hours long and it took me all that time to finish. Normally I am very fast test taker which has helped me earn three college degrees and enough computer related certifications to wallpaper a decent sized house. So if you are a slow reader, suck down a gallon of high octane coffee before your test appointment.

Secondly consider that some of the question will need to be cut out or reworked as the exam becomes production to fit the normal two hour test window Pearson View prefers. But in the beta period you over test and cut out the questions that prove less than satisfactory. So if you see a questions that triggers the ‘where the heck did they find that?’

  [Read more...]
MySQL 5.6 DBA and Developer Certification Exams in Beta, Available NOW!!
Employee +2 Vote Up -0Vote Down

MySQL DBA and Developer Certification Exams are now in beta! Besides covering the new material in MySQL 5.6, you now have to pass one exam to earn the certification where previously you needed to pass two exams. Signup at Pearson Vue and reserve your exam. Testing will start in October.

The exams for older certifications will not be available after October 31st and the Certification Paths for DBA 5.0, Developer 5.0, Cluster DBA 5.1, and Associate will end at the end of the year. Those certifications are still valid once earned forever. For more details.

  [Read more...]
Oracle Selects Pearson VUE to Deliver MySQL Certification Exams
Employee_Team +0 Vote Up -0Vote Down
Effective June 1, 2011, MySQL certification exams will be offered exclusively through a new test delivery partner — Pearson VUE — and will no longer be available through Prometric. This will consolidate all Oracle Certification exams within the operations of a single testing vendor so we can provide better service and global testing coverage for these Oracle certification exams. Pearson VUE currently has over 5,000 test centers worldwide in 165 countries.

To help prepare you for this transition, here are some important dates for you to be aware of:
  • If you are currently following a certification path and are planning to take an exam on/after June 1: Registration has began at Pearson VUE on May 16, 2011 for all scheduled exams on or after June 1. Visit to create a new web account

  [Read more...]
Top Features in MySQL 5.6.2 Development Milestone Release
Employee_Team +2 Vote Up -0Vote Down
Great news was announced today at the Collaborate 11 conference today;  the first development milestone release of MySQL 5.6.2 is now available to the MySQL Community!  This is significant because 5.6.2 builds on the momentum generated by the performance, scalability, InnoDB and Replication improvements that rolled out in version 5.5 just last Dec.  It also marks somewhat of a paradigm shift in how the MySQL Engineering team delivers new, defined sets of stable, development complete features (development "milestones") and cutting edge, currently under development, delivered early and often features via  Both options provide a means for Community users to begin using new versions and, more importantly, new features of MySQL very early on ensuring the final product has undergone the highest degree of testing,  [Read more...]
Save 20% and Get a Free Certification Retake with New MySQL Certification Value Packages
Employee_Team +1 Vote Up -0Vote Down
MySQL developers and DBAs now can choose one of these exclusive MySQL packages to get on the fast track to MySQL certifications while saving 20%.

Included in the package, two Live Virtual Classes (LVCs) can jumpstart your training. With LVCs, you get the same expert instructor and content as classroom training without the need for expensive travel.

Then demonstrate your proficiency using the certification exam vouchers in the package to obtain two certifications.

In addition, you will get the exclusive bonus of a FREE retake with each exam voucher, your one-time insurance, so you can take the exam a

  [Read more...]
Getting excited for the MySQL Conference 2009
+0 Vote Up -0Vote Down
I finally received confirmation that I’m attending the MySQL Conference 2009, yay! I didn’t really dive deep into all the conference has to offer just because I didn’t want to get too excited and then not be able to go. Now that I do know I’m going, I’m full on with excitement and thought I [...]
Stock images are too popular
+0 Vote Up -0Vote Down

I have an ingrained (possibly even genetic) aversion to stock images. Actually, not all stock: just the vacuous kind. You know what I mean: like the politically-correct, gender-balanced, racially-balanced, age-diverse ones where people are all smiling and pointing at a computer screen you can’t see. Ugh!

(Photo credit:

There are many reasons not to use images like this. I guess it’s okay in some situations — for example when you just want a smiling, attractive woman with a customer-service headset to reinforce that you’ve come to the right place for support. However, even these really don’t have to be stock images. One of my former employers used their own employees for such photos, almost exclusively, and

  [Read more...]
Showing entries 1 to 9

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.