Monday Jul 06, 2015

Gain MySQL DBA Expertise Where You Are

Did you know that you can take the very popular MySQL for Database Administrators course where ever you are? Our training formats are adapted to help you get the same high-quality training in an education center or from your own desk. So you can learn to configure the MySQL Server, set up replication and security and perform backups and performance tuning and protect MySQL databases at your chosen location.

The available training formats are:

ONLINE TRAINING

You can take this online course at your own pace as a Training-on-Demand offering, starting training within 24 hours of registration. You will follow lecture material through streaming video and book time to do hands-on exercises when suits your schedule.

LIVE-VIRTUAL TRAINING

If you want to attend a live-event, you can do so from your own desk by choosing a live-virtual event. Choose from a selection of events on the schedule to suit different timezones. Events on the schedule include:

  • Traditional Chinese: 21 September 2015
  • French: 5 October 2015
  • English: 13 and 27 July, 17 August, 21 September, 12, 19 and 26 October and 16 November 2015

IN-CLASS TRAINING

And if you want to travel to an education center to attend a class, below is a selection of the in-class events already on the schedule including an impressive array of delivery languages and locations across 5 continents:

AFRICA

 Location  Date  Delivery Language
Nairobi, Kenya 28 September 2015 English
Pretoria, South Africa 17 August 2015 English

AMERICAS

 Location  Date  Delivery Language
Sao Paulo, Brazil 20 July 2015 Brazilian Portuguese
Bogota, Colombia 7 September 2015 Spanish
Mexico City, Mexico 5 October 2015 Spanish
Monterrey, Mexico 20 July 2015 Spanish
San Pedro Garza Garcia, Mexico 5 October 2015 Spanish

ASIA

 Location  Date  Delivery Language
Shanghai, China
6 July 2015 Simplified Chinese
Causeway Bay, Hong Kong
27 July 2015 English
Jakarta, Indonesia
14 September 2015 English
Tel Aviv, Israel
13 December 2015 Hebrew
Seoul, Korea
7 September 2015 Korean
Darul Ehsan, Malaysia
21 September 2015 English
Kuala Lumpur, Malaysia
17 August 2015 English
Petaling Jaya, Malaysia
29 July 2015 English
Pulau Pinang, Malaysia 17 August 2015 English
Makati City, Philippines 20 July 2015 English
Taipei, Taiwan 21 September 2015 Traditional Chinese
Bangkok, Thailand 14 September 2015 English

AUSTRALIA

 Location  Date  Delivery Language
Brisbane, Australia 19 October 2015 English

EUROPE

 Location  Date  Delivery Language
Brussels, Belgium
21 September 2015 English
Ballerup, Denmark
26 October 2015 English
London, England  3 August 2015 English
Helsinki, Finland
26 October 2015 English
Dublin, Ireland
12 October 2015 English
Milan, Italy
14 September 2015 Italian
Rome, Italy
5 October 2015 Italian
Turin, Italy
14 December 2015 Italian
Utrecht, Netherlands
21 September 2015 English
Warsaw, Poland
7 September 2015 Polish
Edinburgh, Scotland
26 October 2015 English
Madrid, Spain
27 July 2015 Spanish
Kista, Sweden
26 October 2015 English
Basel, Switzerland
5 October 2015 German
Bern, Switzerland 5 October 2015 German
Zurich, Switzerland 5 October 2015 German
Istanbul, Turkey 19 October 2015 Turkish
The MySQL for Database Administrators course is the recommended training for the Oracle Certified Professional MySQL 5.6 Database Administrator certification exam. Oracle's certifications are a real mark of your expertise. Taking the recommended training is one step in your preparation to pass this exam. You will also need significant hands-on experience of the topics examined.

For more information on the authentic MySQL curriculum, go to http://education.oracle.com/mysql.

Monday Jun 29, 2015

Getting Started on MySQL Cluster

If you are starting out with MySQL Cluster, the MySQL Cluster training course could help you get up and running faster. In this 4-day course, you learn to:

  • Install and configure MySQL Cluster nodes
  • Design simple and advanced cluster topologies
  • Secure cluster nodes and data
  • Back up and restore cluster data
  • Troubleshoot common cluster problems
  • Monitor and optimize cluster performance
  • Use enterprise tools to manage large cluster deployments

You can take this course as a:

  • 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. Events on the schedule include 5 October 2015 in Traditional Chinese and 11 August, 25 August, 29 September, and 10 November 2015 in English.
  • In-Class Event: Travel to an education center to take this class. Below is a selection of the in-class events already on the schedule:

 Location  Date  Delivery Language
Sao Paulo, Brazil 10 August 2015 Brazilian Portuguese
Causeway Bay, Hong Kong 25 August 2015 English
Singapore 11 August 2015 English
Bangkok, Thailand 12 October 2015 English
To register for an event, or to learn more about the authentic MySQL curriculum, go to http://education.oracle.com/mysql.

Monday Jun 22, 2015

Beginners on MySQL Should Start Here

If you are beginning to use the MySQL database, the world's most popular open source database, consider taking the MySQL for Beginners training course. You will learn to:

  • Explain the relational database model
  • Describe the features and benefits of MySQL
  • Install and configure the MySQL server and clients
  • Design efficient databases
  • Use Structured Query Language (SQL) to build your database and query data
  • Use appropriate MySQL tools

You can take this course in 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 do hands-on exercises when suits you.
  • Live-Virtual Event: Attend a live event from your own desk - no travel required. You can choose from a selection of events on the schedule to suit different timezones. Dates on the schedule include 14 July and 20 October in Traditional Chinese, 4 and 11 August, 20 October, and 17 November in English and 15 September and 15 December 2015 in German.
  • In-Class Event: Travel to an education center to attend an event. Below is a selection of in-class events already on the schedule.

AFRICA

 Location  Date  Delivery Language
Nairobi, Kenya 14 September 2015 English
Capetown, South Africa 11 August 2015 English
Johannesburg, South Africa 11 August 2015 English
Pretoria, South Africa 27 July 2015 English

AMERICAS

 Location  Date  Delivery Language
Sao Paulo, Brazil 6 July 2015 Brazilian Portuguese
Mexico City, Mexico 27 July 2015 Spanish
San Pedro Garza Garcia, Mexico 4 August 2015 Spanish
ASIA

 Location  Date  Delivery Language
Darul Ehsan, Malaysia 10 August 2015 English
Petaling Jaya, Malaysia 1 September 2015 English
Pulau Pinang, Malaysia 5 October 2015 English
Bangkok, Thailand 1 September 2015 English
EUROPE

 Location  Date  Delivery Language
Brussels, Belgium
20 July 2015 English
London, England
1 September 2015 English
Hamburg, Germany
23 November 2015 German
Munich, Germany
27 July 2015 German
Rome, Italy
14 September 2015 Italian
Utrecht, Netherlands
20 July 2015 English
Lisbon, Portugal
21 September 2015 European Portuguese
Madrid, Spain
13 October 2015 Spanish
To register for an event or to learn more about the authentic MySQL curriculum, go to http://education.oracle.com/mysql.

Monday Jun 15, 2015

Writing Programs With MySQL on Big Data Platforms

Many of the Internet's most popular websites rely on MySQL. With Hadoop integration, MySQL is a key component of many big data platforms. In addition, MySQL brings you the best of both worlds with SQL and NoSQL. After taking the MySQL for Developers course, you will be able to write programs that take advantage of the power and flexibility of MySQL using languages such as Java and PHP. You will have developed the skills to build a database that's optimal for your application, while creating fast and effective queries.

You can take the MySQL for Developers course in the following formats:

  • Training-on-Demand: Start training within 24 hours of registration, following lecture material through streaming video and booking time to get hands-on experience when suits your schedule.
  • 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. Dates on the schedule include 20 July and 26 October 2015 in Traditional Chinese, 19 October 2015 in German, and 13 July, 17 August, 19 October and 30 November 2015 in English.
  • In-Class Event: Travel to an education center to attend an event. Below is a selection of the events already on the schedule.
 Location  Date  Delivery Language
 Brussels, Belgium
 7 September 2015  English
 Sao Paulo, Brazil
 13 July 2015  Brazilian Portuguese
 London, England
 12 October 2015  English
 Munich, Germany
 17 August 2015  German
 Causeway Bay, Hong Kong
 17 August 2015  English
 Dublin, Ireland
 27 July 2015  English
 Milan, Italy
 20 July 2015  Italian
 Turin, Italy
 28 September 2015  Italian
 Nairobi, Kenya
 21 September 2015  English
 Kuala Lumpur, Malaysia
 20 July 2015  English
 Petaling Jaya, Malaysia
 3 August 2015  English
 Pulau Pinang, Malaysia
 20 July 2015  English
 Utrecht, Netherlands
 7 September 2015  English
 Pasig City, Philippines
 6 July 2015  English
 Warsaw, Poland
 14 September 2015  Polish
 Lisbon, Portugal
 19 October 2015  European Portuguese
 Johannesburg, South Africa
 13 July 2015  English
 Madrid, Spain
 7 September 2015  Spanish
 Valencia, Spain
 9 November 2015  Spanish
 Taipei, Taiwan
 20 July 2015  Traditional Chinese
 Bangkok, Thailand
 5 October 2015  English

The MySQL for Developers course is the recommended training for those preparing to sit the MySQL 5.6 Developer OCP certification exam. Taking this training course is one step in your preparation to sit the exam. Oracle's certification exams are a real proof of your expertise. To reach this level of expertise before sitting the exam, you will need to get significant hands-on experience of the topics examined.

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

Monday Jun 08, 2015

MySQL Enterprise Monitor and Performance Tuning

MySQL Enterprise Monitor provides real-time monitoring of your MySQL server and can let you correlate server activity and issues with the workloads that were running at a particular time. The MySQL Performance Tuning course provides you with hands-on experience using MySQL Enterprise Monitor and much more.

You can take the MySQL Performance Tuning course through the following formats:

  • Training-on-Demand: Start training within 24 hours of registering. You follow lecture material at your own pace through streaming video and book time to do hands-on exercises when suits your schedule.
  • Live-Virtual Event: Attend a live event from your own desk - no travel required. You can choose from a selection of events on the schedule to suit different time zones. Dates on the schedule include 23 June, 13 July, 11 August, 22 September, and 2 November 2015.
  • In-Class Event: Travel to an education center to attend a class. Events on the schedule include:

 Location  Date  Delivery Language
Sao Paolo, Brazil
27 July 2015 Brazilian Portuguese
Ballerup, Denmark  16 November 2015 English
Helsinki, Finland
16 November 2015 English
Munich, German
8 June 2015 German
Milan, Italy
12 October 2015 Italian
Turin, Italy
30 November 2015 Italian
Riga, Latvia
18 August 2015 Latvian
Oslo, Norway
21 September 2015 English
Warsaw, Poland
14 June 2015 Polish
Kista, Sweden
16 November 2015 English
To register for an event or to learn more about the authentic MySQL curriculum, go to http://education.oracle.com/mysql.

Monday Jun 01, 2015

Ensuring Your Success with MySQL and PHP

MySQL and PHP is a great combination for those creating and maintaining dynamic web applications. To ensure your success with your websites, take the MySQL and PHP - Developing Dynamic Web Applications training course. In this 4-day, instructor-led class you learn about:

* LAMP

* PHP Foundations

* MySQL Foundations

* PHP connecting to MySQL

* Linking between tables

* SQL Data Manipulation Language

* Forms

* Joins

* Session handling

* Template systems

You can take this class through:

  • Live-Virtual Events: Attend an event from your own desk, no travel required. Choose from a selection of events suiting different timezones. Events already on the schedule include 15 June and 1 September 2015 in Traditional Chinese, and 20 June, 21 July, 29 September, and 6 October 2015 in English.
  • In-Class Events: Travel to an education center to take this class. Events already on the schedule include:
 Location  Date  Delivery Language
 Causeway Bay, Hong Kong  21 July 2015  English
 Petaling Jaya, Malaysia  24 August 2015  English
 Taipei, Taiwan  15 June 2015  Traditional Chinese
 Taipei, Taiwan  1 September 2015  Traditional Chinese
 Bangkok, Thailand  19 October 2015  English
To register for an event or to learn more about the authentic MySQL curriculum, go to http://education.oracle.com/mysql.

Saturday May 23, 2015

20 Years of MySQL with 20% Discount on Training-Certification Packages

MySQL's first release was 20 years ago. And now the most popular open source database is used by a huge number of individuals and companies across the globe.

Join us in celebrating 20 years of MySQL.

If you are a MySQL expert, you might want to prove your knowledge through a MySQL certification.

Those who want to improve and prove their MySQL knowledge could take advantage of the Discount Value Packages, getting 20% off the price of a live-virtual class plus a certification.

Oracle's certifications are a recognized proof of your knowledge and the MySQL certifications are at expert level. Therefore, to pass one of these certification exams, you must do significant preparation.

The MySQL certifications have been created by MySQL engineers and technical consultants with 10 or more years of experience working with MySQL users. So by taking an Oracle MySQL certification, you are measuring yourself against a serious bank of MySQL knowledge.

Here are some steps when preparing to take a MySQL certification:

  1. Go to the web page for the certification you are preparing for: Oracle Certified Professional MySQL 5.6 Database Administrator or Oracle Certified Professional MySQL 5.6 Developer.
  2. Click on the Exam Topics tab to see what subjects will be covered in the exam and do a self-assessment to determine your knowledge gaps. These are the areas you need to concentrate on during your preparation.
  3. Click on the Exam Preparation tab. You will see the recommended training and additional resources such as the MySQL Reference Manual.
  4. In addition to the Recommended Training course(s), your exam preparation plan must include significant hands-on practice or on-the-job experience performing the tasks described on the Exam Topics tab. Oracle University courses may not cover all exam topics and an integrated exam preparation approach is recommended.

For full information on the authentic MySQL Curriculum, go to http://education.oracle.com/mysql.

Monday May 18, 2015

Stored Routines in MySQL for Security, Performance and More

A large number of database administrators are tasked with supporting stored routines even if they do not actually have to create stored routines. Understand the role of stored routines in centralized client functionality, security, performance and function libraries by taking the MySQL for Database Administrators training course

You can take the MySQL for Database Administrators course in the following formats:

  • Training-on-Demand: Start training within 24 hours of registration, following lecture materials at your own pace through streaming video and booking time on a lab environment when suits your schedule.
  • 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 22 June and 21 September 2015 in Traditional Chinese, 8 June, 13 July, 27 July, 17 August, 21 September, and 12 October 2015 in English and 5 October 2015 in French.
  • In-Class Event: Travel to an education center to attend an event. Below is a selection of the events already on the schedule.

AUSTRALIA

 Location  Date  Delivery Language
 Brisbane, Australia  6 July 2015  English
 Melbourne, Australia  18 May 2015  English

AFRICA

 Location  Date  Delivery Language
 Nairobi, Kenya  28 September 2015  English
 Pretoria, South Africa  17 August 2015  English

AMERICAS

 Location  Date  Delivery Language
 Sao Paulo, Brazil  20 July 2015  Brazilian Portuguese
 Bogota, Columbia  7 September 2015  Spanish
 Mexico City, Mexico  8 June 2015  Spanish
 San Pedro Garza Garcia, Mexico  8 June 2015  Spanish
 Roseville, MN, United States  15 June 2015  English
 Columbus, OH, United States  22 June 2015  English
ASIA

 Location  Date  Delivery Language
 Shanghai, China
 6 July 2015  Simplified Chinese
 Bangalore, India
 8 June 2015  English
 Causeway Bay, Hong Kong
 27 July 2015  English
 Jakarta, Indonesia
 15 June 2015  English
 Seoul, Korea
 15 June 2015  Korean
 Darul Ehsan, Malaysia
 21 September 2015  English
 Kuala Lumpur, Malaysia
 17 August 2015  English
 Petaling Jaya, Malaysia
 29 July 2015  English
 Pulau Pinang, Malaysia
 17 August 2015  English
 Pasig City, Philippines
 8 June 2015  English
 Taipei, Taiwan
 22 June 2015  Traditional Chinese
 Bangkok, Thailand
 15 June 2015  English

EUROPE

 Location  Date  Delivery Language
Ballerup, Denmark
8 June 2015 English
London, England
8 June 2015 English
Espoo, Finland
8 June 2015 English
Dublin, Ireland
12 October 2015 English
Tel Aviv, Israel
14 June 2015 English
Milan, Italy
15 June 2015 Italian
Rome, Italy
5 October 2015 Italian
Utrecht, Netherlands
15 June 2015 English
Warsaw, Poland
7 September 2015 Polish
Edinburgh, Scotland
26 October 2015 English
Madrid, Spain
27 July 2015 Spanish
Kista, Sweden
8 June 2015 English
Basel, Switzerland
5 October 2015 German
Bern, Switzerland
5 October 2015 German
Zurich, Switzerland
5 October 2015 German
Istanbul, Turkey
19 October 2015 Turkish
The MySQL for Database Administrators training course is the recommended training for those preparing to sit the MySQL 5.6 Database Administrator OCP certification exam.

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

Monday May 11, 2015

Starting and Stopping a Cluster with MySQL Cluster Manager

MySQL Cluster Manager makes ti easy to start and stop an entire cluster. You can reconfigure all data nodes in the cluster with a single command that not only changes the setting but also restarts each node in turn without bringing down the cluster.

To learn more about MySQL Cluster and MySQL Cluster Manager take the MySQL Cluster training course. You can take this 4-day instructor-led course as a:

  • 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 time zones. Events on the schedule include 23 and 30 June, 11 August, 29 September, 13 October 2015.
  • In-Class Event: Travel to an education center to attend an event. Events already on the schedule include:

 Location  Date  Delivery Language
Sao Paulo, Brazil 8 June 2015 Brazilian Portuguese
Jakarta, Indonesia 29 June 2015 English
Mexico City, Mexico 15 June 2015 Spanish
Singapore 11 August 2015 English
Bangkok, Thailand 12 October 2015 English
To register for an event or learn more about the authentic MySQL curriculum, go to http://education.oracle.com/mysql.

Monday Apr 27, 2015

Importing and Backing Up with mysqldump

The mysqldump utility lets you 'dump' table contents to text, either for backup purposes or for importing into other databases. mysqldump supports two types of database backup

  • Physical backup which preserves only the data, typically in comma separated (CSV) or other delimited text files but also in XML format.
  • Logical backup which contains SQL statements that can reproduce table structure, table data or both

To learn about importing and exporting data as well as other key topics for getting started on a MySQL database, take the MySQL for Beginners training course.

You can take this 4-day course through the following formats:

  • Training-on-Demand: Start training within 24 hours of registration, following lecture material through streaming video and booking access to perform hands on exercises when suits your schedule.
  • 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; 24 May, 1 June, 2 June, 4 August and 20 October 2015 in English and 15 September and 15 December 2015 in German.
  • In-Class Event: Travel to an education center to attend a class. Below is a selection of the events already on the schedule.

 Location  Date  Delivery Language
Brussels, Belgium
18 May 2015 English
Sao Paolo, Brazil
6 July 2015 Brazilian Portuguese
London, England
1 September 2015 English
Berlin, Germany
27 April 2015 German
Hamburg, Germany
21 September 2015 German
Munich, Germany
27 July 2015 German
Jakarta, Indonesia
1 June 2015 English
Rome, Italy
14 September 2015 Italian
Turin, Italy
8 June 2015 Italian
Darul Eshan, Malaysia
10 August 2015 English
Kuala Lumpur, Malaysia
8 June 2015 English
Petaling Jaya, Malaysia
5 May 2015 English
Pulau Pinang, Malaysia
2 June 2015 English
Mexico City, Mexico
25 May 2015 Spanish
Utrecht, Netherlands
18 May 2015 English
Lisbon, Portugal
21 September 2015 European Portuguese
Capetown, South Africa
11 August 2015 English
Johannesburg, South Africa
11 August 2015 English
Pretoria, South Africa
27 July 2015 English
Madrid, Spain
6 July 2015 Spanish
Bangkok, Thailand 8 June 2015 English
To register for an event or learn more about the authentic MySQL curriculum, go to http://education.oracle.com/mysql.

Monday Apr 20, 2015

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.

Monday Apr 13, 2015

Is The Performance of Your MySQL Database Important?

How important is the performance of your MySQL database? If you want to learn more about tuning the performance of MySQL servers, consider taking the MySQL Performance Tuning training course. In this course you learn to:

  • Understand performance tuning concepts
  • Benchmark your MySQL server
  • Tune MySQL server settings
  • Investigate performance metrics with a range of system databases, command-line and graphic tools
  • Design your database for optimal performance
  • Optimize slow queries
  • Troubleshoot common performance problems
  • Scale your hardware and application environment as your database grows

You can take the MySQL Performance Tuning course in the following formats:

  • Training-on-Demand: Start training within 24 hours of registration, following lecture material at your own pace through streaming video and getting hands-on experience at a time that suits your schedule.
  • Live-Virtual Event: Attend a live event from your own desk, no travel required. Choose from a selection of events on schedule to suit different timezones including 19 May, 23 June, and 11 August 2015 in English,  2 November 2015 in German, and 27 April 2015 in Spanish.
  • In-Class Event: Travel to an education center to attend a class. Below is a selection of the events already on the schedule.
 Location  Date  Delivery Language
 Sao Paulo, Brazil
 25 May 2015  Brazilian Portuguese
 Hvidovre, Denmark
 15 June 2015  English
 Espoo, Finland
 15 June 2015  English
 Causeway Bay, Hong Kong   27 April 2015  English
 Jakarta, Indonesia
 27 April 2015  English
 Utrecht, Netherlands
 19 May 2015  English
 Pasig City, Philippines
 27 April 2015  English
 Kista, Sweden
 20 April 2015  English
 Taipei, Taiwan
 4 May 2015  Traditional Chinese
To register for an event or learn more about the authentic MySQL curriculum, go to http://education.oracle.com/mysql.

Monday Apr 06, 2015

Improve Performance of a MySQL Database with Partitioning

You can improve the performance of a MySQL Database by using partitioning, that is assigning specific table rows into subsets of rows. Partitioning can help in many different situations including improving the efficiency of large tables by:

  • Breaking data into smaller groups for more efficient queries
  • Adhering to file-system file size limits
  • Speeding up runtimes for maintenance and deleting rows

To learn much more about partitioning and other key topics, take the very popular MySQL for Database Administrators training course.

You can take this 5-day instructor-led course through the following formats:

  • Training-on-Demand: Start training within 24 hours of registration, following lecture material through streaming video and booking time on a lab environment to get hands-on experience at your own convenience
  • Live-Virtual Event: Attend a live class from your own desk, no travel required. Choose from a selection of events on the schedule to suit different time zones including the 5th October 2015 for delivery in French and the 4th, 11th, and 18th May, 8th June, 13th July, 17th August, and 21th September 2015 in English.
  • In-Class Event: Travel to an education center to attend a class. Below is a selection of the events already on the schedule.

AFRICA

 Location  Date  Delivery Language
Capetown, South Africa 11 May 2015 English
Pretoria, South Africa 17 August 2015 English

AMERICAS

 Location  Date  Delivery Language
Sao Paulo, Brazil
13 April 2015 Brazilian Portuguese
Mexico City, Mexico
22 June 2015 Spanish
San Pedro Garza Garcia, Mexico
20 April 2015 Spanish
Lima, Peru 13 April 2015 Spanish
Roseville, MN, United States 15 June 2015 English
Saint Charles, MO, United States 11 May 2015 English
Columbus, OH, United States 22 June 2015 English

ASIA

 Location  Date  Delivery Language
Shanghai, China
6 July 2015 Simplified Chinese
Causeway Bay, Hong Kong
11 May 2015 English
Bangalore, India
18 May 2015 English
Seoul, Korea
6 April 2015 Korean
Kuala Lumpur, Malaysia
17 August 2015 English
Petaling Jaya, Malaysia
11 May 2015 English
Pulau Pinang, Malaysia
17 August 2015 English
Pasig City, Philippines
8 June 2015 English
Singapore
6 April 2015 English
Bangkok, Thailand
15 June 2015 English
AUSTRALIA

 Location  Date  Delivery Language
Brisbane, Australia 27 April 2015 English
Melbourne, Australia 18 May 2015 English

EUROPE

 Location  Date Delivery Language
Brussels, Belgium
4 May 2015 English
Hvidovre, Denmark 8 June 2015 English
London, England
13 April 2015 English
Espoo, Finland
8 June 2015 English
Dublin, Ireland
25 May 2015 English
Milan, Italy
15 June 2015 Italian
Rome, Italy
15 June 2015 Italian
Utrecht, Netherlands
4 May 2015 English
Oslo, Norway
4 May 2015
English
Edinburgh, Scotland
25 October 2015
English
Glasgow, Scotland
11 May 2015 English
Madrid, Spain
18 May 2015 Spanish
Kista, Sweden 8 June 2015 English
Basel, Switzerland 4 May 2015 German
Bern, Switzerland 4 May 2015 German
Zurich, Switzerland 4 May 2015 German
Istanbul, Turkey 20 May 2015 Turkish
To register for an event or learn more about the authentic MySQL curriculum, go to http://education.oracle.com/mysql.

The MySQL for Database Administrators course is the recommended training for those preparing to take the MySQL 5.6 Database Administration OCP certification exam.

Monday Mar 30, 2015

A Single Command to Backup MySQL Cluster Data

The MySQL Cluster training course is packed full of useful information, hints, tips and hands-on practices. For example, did you know that you can back up the entire cluster's data on all data nodes by issuing a single START BACKUP command on the management node.

You can take the 4-day instructor-led MySQL Cluster course as a:

  • 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 27 April, 5 May, 26 May, and 30 June 2015 delivered in English and 22 April 2015 delivered in Traditional Chinese.
  • In-Class Event: Travel to an education center to take this course. Below is a selection of the events already on the schedule.

 Location  Date
 Delivery Language
Brussels, Belgium
26 May 2015 English
Sao Paulo, Brazil
22 April 2015 Brazilian Portuguese
London, England
13 April 2015 English
Seoul, Korea
27 April 2015 Korean
Utrecht, Netherlands 26 May 2015 English
Singapore 27 April 2015 English
Madrid, Spain 7 April 2015 Spanish
Bangkok, Thailand 12 October 2015 English

 

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

Monday Mar 23, 2015

Harness the Power of MySQL By Learning to Build Databases

Harness the power of MySQL by learning how to design a robust and efficient database. By taking the MySQL for Beginners training course you will learn SQL and use it to build databases, populate them with data and query that data through extensive hands-on practices.

You can take the MySQL for Beginners training course through the following formats:

  • Training-on-Demand: Start training within 24 hours of registration, following lecture at your own pace through streaming video and booking a time that suits your schedule to get hands-on experience.
  • 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. Events on the schedule include 14 April, 27 April, 25 May and 2 June 2015.
  • In-Class Event: Travel to an education center to take this training. Events on the schedule include:

 Location  Date  Delivery Language
 Brussels, Belgium
 27 April 2015
 English
 Sao Paulo, Brazil
 6 July 2015
 Brazilian Portuguese
 London, England
 11 May 2015
 English
 Berlin, Germany
 27 April 2015
 German
 Hamburg, Germany
 21 September 2015
 German
 Munich, Germany
 27 July 2015
 German
Milan, Italy
4 May 2015
 Italian
Rome, Italy
 27 April 2015
 Italian
 Turin, Italy
 8 June 2015
 Italian
 Kuala Lumpur, Malaysia
 8 June 2015
 English
 Petaling Jaya, Malaysia
 2 May 2015
 English
 Pulau Pinang, Malaysia
 2 June 2015
 English
 Mexico City, Mexico
 15 June 2015
 Spanish
 San Pedro Garza Garcia
 4 May 2015
 Spanish
 Lisbon, Portugal
 21 September 2015
 European Portuguese
 Utrecht, Netherlands
 27 April 2015
 English
 Cape Town, South Africa
 11 August 2015
 English
 Johannesburg, South Africa
 11 August 2015
 English
 Pretoria, South Africa
 23 November 2015
 English
 Madrid, Spain
 27 April 2015
 Spanish
To register for an event or learn more about the authentic MySQL curriculum, go to http://education.oracle.com/mysql.
About

Get the latest updates on products, technology, news, events, webcasts, customers and more.

Twitter


Facebook

Search

Archives
« July 2015
SunMonTueWedThuFriSat
   
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 
       
Today