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.

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 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 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.

Monday Feb 16, 2015

MySQL DBA Training Available Across the Globe

Oracle's MySQL training is created by the MySQL experts. You can benefit from this training across the globe.

For example, the MySQL for Database Administrators course is currently scheduled to run in 13 languages and 26 countries and is available 'virtually' and online from anywhere. You can take this class through the following formats:

  • Training-on-Demand:Start training within 24 hours of registration. Follow lecture material at your own pace via streaming video and perform hands-on exercises on a remote lab environment suiting your schedule.
  • Live Virtual Event: Attend a live event from your own desk, no travel required. There are events on the schedule to suit different timezones. Events on the schedule include delivery in Traditional Chinese on March 23rd 2015, Korean on March 9th and May 11th 2015, French on April 13th and October 5th 2015, and English on March 9th and 16th, April 6th, May 4th, 11th, and 18th 2015.
  • In-Class Event: Travel to an education center to attend a class. Below is a selection of events already on the schedule.

Africa

 Location  Date  Delivery Language
Cairo, Egypt
29 March 2015 Arabic
Nairobi, Kenya
20 April 2015 English
Cape Town, South Africa
11 May 2015 English
Pretoria, South Africa
17 August 2015 English
Tunis, Tunisia
23 March 2015 French

Note, you can also attend a live virtual event from your own desk in French on April 13th and October 5th 2015 and in English on March 9th and 16th, April 6th, and May 4th, 11th, and 18th 2015.

Americas

 Location  Date  Delivery Language
Sao Paulo, Brazil
2 March 2015 Latin American Spanish
Sao Paulo, Brazil
6 April 2015 Brazilian Portuguese
Mexico City, Mexico
6 April 2015 Spanish
San Pedro Garza Garcia, Mexico  
20 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

Note, you can also attend a live virtual event from your own desk in English on March 9th and 16th, April 6th, and May 4th, 11th, and 18th 2015.

Asia

 Location  Date  Delivery Language
Causeway Bay, Hong Kong 11 May 2015 English
Bangalore, India 9 March 2015  English
Jakarta, Indonesia 16 March 2015  English
Kuala Lumpur, Malaysia 16 March 2015  English
Petaling Jaya, Malaysia 9 March 2015 English
Pulau Pinang, Malaysia 13 April 2015 English
Pasig City, Philippines 9 March 2015 English
Singapore 23 February 2015  English
Note that you can also attend a live virtual event from your own desk in Korean on March 9th and May 11th 2015, in Traditional Chinese on March 23rd 2015 and in English on March 9th and 16th, April 6th, and May 4th, 11th, and 18th 2015.

Europe

 Location  Date  Delivery Language
Brussels, Belgium
9 March 2015 English
Hvidovre, Denmark
20 April 2015 English
London, England
13 April 2015 English
Espoo, Finland
20 April 2015 English
Dublin, Ireland
25 May 2015 English
Milan, Italy
2 March 2015 Italian
Rome, Italy
18 May 2015 Italian
Turin, Italy
20 April 2015 Italian
Vilnius, Lithuanian
16 March 2015 Lithuanian
Utrecht, Netherlands
9 March 2015 English
Oslo, Norway
4 May 2015 English
Lisbon, Portugal
23 February 2015 European Portuguese
Edinburgh, Scotland
19 October 2015 English
Glasgow, Scotland
11 May 2015 English
Madrid, Spain
18 May 2015 Spanish
Kista, Sweden
20 April 2015 Sweden
Basel, Switzerland
13 April 2015 German
Bern, Switzerland
13 April 2015 German
Zurich, Switzerland
13 April 2015 German

Note, you can also attend a live virtual event from your own desk in French on April 13th and October 5th 2015 and in English on March 9th and 16th, April 6th, May 4th, 11th, and 18th 2015.

The MySQL for Database Administrators course helps you prepare for the MySQL 5.6 Database Administrator OCP certification exam.

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

Monday Dec 08, 2014

Developers Plan, Design, and Implement Applications with MySQL

Oracle's MySQL for Developers training teaches you everything you need to know about planning, designing and implementing applications on MySQL. In this 5-day instructor-led course you will get hands on experience using languages such as Java and PHP.

After taking the MySQL for Developers training you will be able to write programs that take advantage of the power and flexibility of MySQL. This course prepares you to pass the MySQL 5.6 Developer Certification Exam which is a proof to employers of your expertise.

You can take this course as a:

  • Live-Virtual Event: Attend a live event from your own desk, no travel required, Dates on the schedule to suit different timezones include 4 January, 23 February, 22 March, 10 May, and 25 May 2015
  • In-Class Events: Travel to an education center to take this class. Events on the schedule include:

 Location

 Date

 Delivery Language

 Vienna, Austria

 20 April 2015

 German

 Brussels, Belgium

 23 February 2015

 English

 London, England

 9 February 2015

 English

 Munich, Germany

 18 May 2015

 German

 Causeway Bay, Hong Kong

 23 March 2015

 English

 Dublin, Ireland

 2 March 2015

 English

 Rome, Italy

 15 December 2014

 Italian

 Nairobi, Kenya

 9 February 2015

 English

 Kuala Lumpur, Malaysia

 23 February 2015

 English

 Petaling Jaya, Malaysia

 15 December 2014

 English

 Pulau Pinang, Malaysia

 2 March 2015

 English

 Utrecht, Netherlands

 23 February 2015

 English

 Lisbon, Portugal

 23 March 2015

 European Portuguese

 Porto, Portugal

 6 April 2015

 European Portuguese

 Madrid, Spain

 23 February 2015

 Spanish

 Valencia, Spain

 22 June 2015

 Spanish

 Capetown, South Africa

 25 May 2015

 English

 Johannesburg, South Africa

 13 Juy 2015

 English

 Pretoria, South Africa

 13 April 2015

 English

 Bern, Switzerland

 2 March 2015

 German

 Zurick, Switzerland

 18 February 2015

 German

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

Monday Dec 01, 2014

MySQL Backup for Recovery, Auditing, Data Transfer

Backing up your MySQL databases is important for:

  • Complete system recovery: If a system fails, you need a backup of the system so you can restore it. Your backup and recovery strategy depends on how current and how complete the recovered data needs to be.
  • Auditing capabilities: For some systems and associated processes, you need to audit or analyze the data on a system other than your primary production environment.
  • Typical DBA tasks: Use backups when you need to perform typical DBA tasks such as transferring data from one system to another, creating a development server based on a specific state of a production server or recovering certain portions of the system to state prior to a user error.

Take the MySQL for Database Administrators course to learn more about types of backup, backup tools, and MySQL Enterprise Backup. You can take this 5-day, instructor-led course in the following formats:

  • Training-on-Demand: Start training within 24 hours of registering, following lecture material at your own pace through streaming video and booking time on a lab environment to suit your schedule.
  • Live-Virtual Event: Attend a live event from your own desk, no travel required. Choose from a selection of events already on the schedule to suit different timezones. Events include 7th and 8th of December 2014, 25 January 2015, 2 and 22 February 2015, 9 and 16 March 2015, 13 April 2015, 4th, 10th and 17th May 2015 for delivery in English and 8 December 2014 for delivery in Korean.
  • 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
 Brisbane, Australia
19 January 2015
English
 Brussels, Belgium
9 March 2015  English

Sao Paulo, Brazil

15 December 2014  Brazilian Portuguese
 Beijing, China
 8 December 2014
 Simplified Chinese
 Copenhagen, Denmark
 23 February 2015
 English
Cairo Egypt  1 March 2015
 Arabic
 London, England
 8 December 2014
 English
Espoo, Finland  23 February 2015
 English
 Causeway Bay, Hong Kong
 23 February 2015
 English
 Dehradun, India
 1 December 2014
 English
 Dublin, Ireland
 5 January 2015
 English
Milan, Italy
 2 March 2015
Italian
 Rome, Italy
 16 February 2015
 Italian
 Turin, Italy
 26 January 2015
 Italian
 Nairobi, Kenya
 16 February 2015
 English
 Mexico City, Mexico
 26 January 2015
 Spanish
Utrecht, Netherlands
 9 March 2015
 English
Oslo, Norway
 8 December 2014
 English
 Edinburgh, Scotland
 19 October 2015
 English
 Glasgow, Scotland
 19 October 2015
 English
 Singapore  26 January 2015
 English
Capetown, South Africa
 11 May 2015
 English
Pretoria, South Africa
 17 August 2015
 English
 Madrid, Spain
 2 February 2015
 Spanish
 Kista, Sweden  8 December 2014
 English
 Basel, Switzerland  13 April 2015
 German
 Bern, Switzerland  13 April 2015
 German
 Zurick, Switzerland 13 April 2015
 German
 Istanbul, Turkey
 2 February 2015
 Turkish
 Saint Charles, MO, United States
 11 May 2015
 English

The MySQL for Database Administrators class helps prepare you to take the MySQL 5.6 Database Administrator OCP certification exam, which is an important testimony of your expertise.

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

Monday Oct 20, 2014

Impress Employers by Upgrading Your MySQL DBA Certification

MySQL 5.6 has seen a high level of adtoption. Now it the time to prove to your current or future employer your proficency in using MySQL Server by taking the MySQL 5.6 Database Administrator Oracle Certified Professional (OCP) certification exam.

If you previous passed the now retired MySQL 5 Database Administrator certifcation exam you can upgrade your certification by taking the MySQL 5.6 Database Administrator OCP. Reasons to upgrade your certification include that you:

  • Are certified on the latest technology employers are using
  • Show you are keeping your skill set sharp and up-to-date
  • Differentiate yourself in a competitive market place

Those preparing to become certified MySQL Database Administrators will need extensive hands on experience with the product. Part of the preparation can include taking the MySQL for Database Administrators course which is aligned with this challenging OCP exam.

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

  • Training-on-Demand: Start training within 24 hours of registering. You follow the lecture material at your own pace and schedule time to do lab exercises to suit 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 suiting different time-zones. Class start dates already on the schedule include deliveries in Korean (November 2nd and December 14th 2014), in French (13 April 2015), in English (16 and 17 November, 8 and 14 December 2014, 2 February, 9 and 16 March and 4 May 2015),
  • 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

Brisbane, Australia

 19 January 2015

 English

Brussels, Belgium

 3 November 2014

 English

 Sao Paolo, Brazil

 20 October 2014

 Brazilian Portuguese

 Beijing, China

 20 October 2014

 Simplified Chinese

 London, England

 8 December 2014

 English

 Dublin, Ireland

 5 January 2015

 English

 Tel Aviv, Israel

 16 November 2014

 Hebrew

 Rome, Italy

 27 October 2014

 Italian

 Nairobi, Kenya

24 November 2014 

 English

Petaling Jaya, Malaysia 

24 November 2014

English

San Pedro Garza Garcia, Mexico

 8 December 2014

 Spanish

  Utrecht, Netherlands

 3 November 2014

 English

 Pasig City, Philippines

 3 November 2014

 English

 Singapore

 27 October 2014

 English

 Cape Town, South Africa

 11 May 2015

 English

 Pretoria, South Africa

 17 August 2015

 English

 Basel, Switzerland

 13 April 2015

 German

 Bern, Switzerland

 13 April 2015

 German

 Zurich, Switzerland

 13 April 2015

 German

 Istanbul, Turkey

 2 February 2015

 Turkish

 Saint Charles, MO, United States

 11 May 2015

 English

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

Monday Sep 01, 2014

MySQL for Database Administrators Training Available in Eight Languages

The MySQL for Database Administrators training course is one of the most popular courses at Oracle. This is not surprising since it provides a comprehensive range of administration skills to those using the world's most popular open source database.

You can travel to an education center to take this 5-day instructor-led course, and as shown in the table below, events are currently scheduled for delivery in 8 languages (Arabic, Brazilian Portuguese, English, French, Hebrew, Italian, Spanish, Turkish).

If you want to take this training from your own desk, you have two options:

  • Training-on-Demand: Start training within 24 hours of registration, following training at your own pace.
  • Live-Virtual Event: Follow a live event from your own desk, choosing from a selection of events on the schedule to suit different timezones.

For those who want to travel to an education center, below is a selection of the events already on the schedule:

 Location

 Date

 Delivery Language

 Brisbane, Australia

 13 October 2014

 English

 Brussels, Belgium

 3 November 2014

 English

 Sao Paulo, Brazil

 20 October 2014

 Brazilian Portuguese

 Cairo, Egypt

 28 September 2014

 Arabic

 London, England

 22 September 2014

 English

 Belfast, Ireland

 12 January 2015

 English

 Dublin, Ireland

 5 January 2015

 English

 Tel Aviv, Israel

 16 November 2014

 Hebrew

 Milan, Italy

 22 September 2014

 Italian

 Rome, Italy

 15 September 2014

 Italian

 Nairobi, Kenya

 22 September 2014

 English

 Petaling Jaya, Malaysia

 29 September 2014

 English

 San Pedro Garza Garcia, Mexico

 29 September 2014

 Spanish

 Pasig City, Philippines

 1 September 2014

 English

 Utrecht, Netherlands

 3 November 2014

 English

 Singapore

 27 October 2014

 English

 Edinburgh, Scotland

 29 September 2014

 English

 Madrid, Spain

 6 October 2014

 Spanish

Tunis, Tunisia 

 5 November 2014

 French

Istanbul, Turkey 

 27 October 2014

 Turkish 

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

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

Monday Jul 21, 2014

Setting up and Using MySQL Replication

MySQL Replication allows servers to copy changes from one instance to another. Take the MySQL for Database Administrators course to learn about replication, including:

  • How to set up a replication environment
  • Complex topologies
  • Replication types
  • Global transaction IDs (GTIDs)
  • MySQL Utilities
  • Logs and threads

Replication is one of the many topics covered in the MySQL for Database Administrators course. You can take this 5-day instructor-led course as  

  • Training-on-Demand: Start training within 24 hours of registration. Follow lectures at your own pace and book time to take the lab exercises to suit 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.
  • 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

 Brisbane, Australia

 4 August 2014

 English

 Brussels, Belgium

 25 August 2014

 English

 Sao Paolo, Brazil

 18 August 2014

 Brazilian Portuguese

 Egypt, Cairo

 28 September 2014

 Arabic

 London, England

 22 September 2014

 English

 Belfast, Ireland

 15 September 2014

 English

 Nairobi, Kenya

22 September 2014 

 English 

 Dublin, Ireland

29 September 2014 

 English 

 Tel Aviv, Israel

 16 November 2014

 Hebrew

 Milan, Italy

 22 September 2014

 Italian

 Rome, Italy

 15 September 2014

 Italian

 Petaling Jaya, Malaysia

 29 September 2014

 English

 Utrecht, Netherlands

 25 August 2014

 English

 Edinburgh, Scotland

 29 September 2014

 English

 Madrid, Spain

 6 October 2014

 Spanish

 Tunis, Tunisia

 5 November 2014

 French

 Istanbul, Turkey

 15 September 2014

 Turkish

The MySQL for Database Administrators course helps prepare for the MySQL 5.6 Database Administrator OCP certification exam.

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

Monday Jul 14, 2014

Save 20% With MySQL Training and Certification Packages

Get the best from both worlds with bundled packages: a training course and a certification exam voucher. You save 20% when you buy training and certification in discount packages.

Training helps you acquire product expertise. Certification proves this expertise to your future employers.

There are two MySQL Discount Packages: MySQL Database Administration and MySQL Developer.

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

Monday Jun 02, 2014

Securing User Account Details with MySQL

Keeping user account details secure is always at the forefront of a Database Administrator's mind. However, users want to get up and running as soon as possible without complex login procedures.

You can learn more about this and many other topics in the MySQL for Database Administrator course.

For example, MySQL 5.6.6 introduced a new utility: mysql_config_editor, which makes secure access via MySQL client applications much easier to establish, while still providing a good measure of security.

The mysql_config_editor stores a user's authentication details in an encrypted login file called mylogin.cnf. This login file is readable and writable for the user who invokes the utility, and invisible to everyone else. You can use it to collect all your hard-to-remember server locations and paswords safe in the knowledge that your passwords are never invoked using clear text.

The MySQL for Database Administrators course is a 5-day instructor-led course which is available as a:

  • Training-on-Demand: Start training within 24 hours of registration, following lecture material at your own pace through streaming video and booking time on a lab environment to suit your schedule.
  • Live-Virtual Event: Attend a live event from your own desk, choosing from a selection of events on the schedule to suit different timezones.
  • In-Class Event: Travel to an education center to attend this course. Below is a selection of the events already on the schedule.

Location

 Date

 Delivery Language

 Brisbane, Australia

 18 August 2014

 English

 Brussels, Belgium

 25 August 2014

 English

 Sao Paulo, Brazil

 2 June 2014

 Brazilian Portuguese

 Cairo, Egypt

 28 September 2014

 Arabic

 London, England

 14 July 2014

 English

 Belfast, Ireland

 15 September 2014

 English

 Dublin, Ireland

 29 September 2014

 English

 Rome, Italy

 16 June 2014

 Italian

 Seoul, Korea

 9 June 2014

 Korean

 Petaling Jaya, Malaysia

 16 June 2014

 English

 Utrecht, Netherlands

 25 August 2014

 English

 Edinburgh, Scotland

 26 June 2014

 English

 Madrid, Spain

 6 October 2014

 Spanish

 Tunis, Tunisia

 27 October 2014

 French

 Istanbul, Turkey

 14 July 2014

 Turkish

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

To read more about MySQL security, consult the MySQL Reference Manual - http://dev.mysql.com/doc/refman/5.6/en/security.html.

Monday Apr 07, 2014

MySQL Utilities Make a DBA More Efficient and Productive

MySQL Utilities provide a collection of command line utilities that make it easy for database administrators to maintain and administer MySQL servers. The utilities perform a range of otherwise complex operations via a simple command, making DBAs more efficient and productive.

There are utilities for copying databases, comparing databases running on different servers, checking disk usage and for redundant or duplicate indexes, automatic failover, verifying replication configuration, cloning a running server, and working with audit logs. You can use all these utilities either standalone or with MySQL Workbench.

You can learn about MySQL Utilities and much more by taking the MySQL for Database Administrators course. This highly popular 5-day instructor-led course is available in the following training formats:

  • Training-on-Demand: Start training within 24 hours of registration, following lecture material at your own pace and scheduling time on a lab environment to suit your schedule.
  • Live-Virtual Events: Attend a live class from your own desk - no travel required, choosing from a selection of events on the schedule to suit different timezones.
  • In-Class Events: Travel to an education center to attend an event. Below is a selection of events already on the schedule.

 Location  Date  Delivery Language
Brisbane, Australia
7 April 2014 English
Sao Paolo, Brazil
19 May 2014 Brazilian Portuguese
Brussels, Belgium
12 May 2014 English
Cairo, Egypt
13 April 2014 Arabic
London, England
19 May 2014 English
Milan, Italy
12 May 2014 Italian
Rome, Italy
14 April 2014 Italian
Nairobi, Kenya
28 May 2014 English
Petaling Jaya, Malaysia
19 May 2014 English
Mexico City, Mexico
5 May 2014 Spanish
Utrecht, Netherlands
12 May 2014 English
Makati City, Philipinnes
28 May 2014 English
Madrid, Spain
9 June 2014 Spanish
Bangkok, Thailand
21 April 2014 English
Istanbul, Turkey
9 June 2014 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 Administrator course is the recommeneded training to prepare you to take the MySQL 5.6 Database Administrator OCP certification exam.

Monday Mar 10, 2014

DBAs, Learn about MySQL Where You Want, When You Want

If you have a busy schedule or too much going on to attend a live training session, Training-on-Demand is for you. With Training-on-Demand, you can watch recorded classroom sessions taught by top Oracle instructors and gain hands-on experience with a dedicated lab environment.

In viewing the classroom sessions, you access streaming lectures on your desktop or tablet, with the ability to fast-forward, pause, rewind and search.

MySQL for Database Administrators is available as training-on-demand. This course is designed for DBAs and other database professionals. Learn to configure the MySQL Server, set up replication and security, perform database backups and performance tuning and protect MySQL Databases. This class also helps prepare you for the MySQL 5.6 Database Administrator certification exam.

To see other MySQL courses available in the training-on-demand format, go to Training-on-Demand, click the Courses tab and choose the Database product area and the MySQL curriculum category.

You can also take MySQL courses as live-virtual events and in-class events. To 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
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