What a MySQL Developer Needs to Know

To perfect your skills as a MySQL developer, consider taking the MySQL for Developers training course. In this 5-day course, you learn to:

  • Describe the MySQL client/server architecture
  • Use MySQL client programs and common options
  • Program MySQL applications with Java and PHP connectors
  • Use a 'NoSQL' approach to store and retrieve data
  • Design efficient tables
  • Create and delete database objects
  • Use expressions in SQL statements
  • Examine database metadata
  • Use SQL statements to modify table data
  • Maintain database integrity with transactions
  • Write multiple table queries
  • Create 'virtual tables' containing specific data
  • Create user-defined variables, prepared statements, and stored routines
  • Create and manage triggers
  • Identify and deal with errors and exceptions in client programs
  • Write queries that are fast and effective, even under heavy loads

You can take this course through the following formats:

  • Training-on-Demand: Start training within 24 hours of registration following lecture material at your own pace through streaming video and booking time to get hands-on experience at a time that suits you.
  • Live-Virtual Event: Attend a live event from your own desk, no travel required. Choose from a selection of events on the schedule to suit different timezones including 11 May, 25 May, 13 July and 19 October 2015 in English, 25 May 2015 in Traditional Chinese, and 19 October 2015 in German.
  • In-Class Event: Travel to an education center to take this class. Below is a selection of the events already on the schedule.
 Location  Date  Delivery Language
Sao Paulo, Brazil
13 July 2015 Brazilian Portuguese
 Brussels, Belgium
18 May 2015 English
London, England
7 September 2015 English
Munich, Germany
18 May 2015 German
Jakarta, Indonesia  22 June 2015 English
Kuala Lumpur, Malaysia
20 July 2015 English
Petaling Jaya, Malaysia
30 April 2015 English
San Pedro Garza Garcia, Mexico
25 May 2015 Spanish
Utrecht, Netherlands 18 May 2015 English
Makati City, Philippines
25 May 2015 English
Pasig City, Philippines
15 June 2015 English
Lisbon, Portugal
19 October 2015 European Portuguese
Cape Town, South Africa
25 May 2015 English
Johannesburg, South Africa
13 July 2015 English
Madrid, Spain
8 June 2015 Spanish
Valencia, Spain
22 June 2015 Spanish
Taipei, Taiwan
22 June 2015 Simplified Chinese
Bangkok, Thailand 6 July 2015 English


The MySQL for Developers training course is the recommended training for those preparing to sit the MySQL 5.6 Developer OCP certification exam.

To register for an event or to learn more about the authentic MySQL curriculum, go to http://education.oracle.com/mysql.