In my previous post on MySQL 5.6 Transactions, I demonstrated how transactions can be started, committed, rolled back (either partially or fully) and how to change the autocommit functionality of MySQL. In the post I’ll describe how MySQL handles multiple transactions running at the same time, through the use of Transaction Isolation Levels. Read more…
The concept of transactions is a new topic added to the MySQL 5.6 Developer exam it wasn’t on the old 5.0 Developer exams and hence is not covered in the Developer chapters of the MySQL 5.0 Certification Study Guide (It is however in Chapter 29, in the DBA part of the book). Here are my study notes on transactions, cobbled together from various books and online resources. Read more…
Here’s a list of the topics on the MySQL 5.6 Developer Exam – 1Z0-882. As I prepare for the exam, I’ll add-in some study notes and links to online resources for each topic. Read more…
Back in 2011, I wrote a blog post outlining how to become an Oracle Certified Professional (OCP) – MySQL 5.0 Database Developer. Oracle have since changed the certification process and updated the exam for MySQL 5.6 with new topics, and this in new post I’ll give some tips and advice on how I prepared for the new 5.6 Developer exam.
This post was first written in November 2011, and outlines how to attain the MySQL 5.0 Developer Certification from Oracle. In March 2014, Oracle updated the certification process for MySQL 5.6. You can read more about the MySQL 5.6 Developer Certification here. Read more…
