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.