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 Aug 18, 2014

Items Affecting Performance of the MySQL Database

To learn about the many factors that can affect the performance of the MySQL Database, take the MySQL Performance Tuning course.

You will learn:

  • How your hardware and operating system can affect performance
  • How to set up and logging to improve performance
  • Best practices for backup and recovery
  • And much more

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

  • Training-on-Demand: Start training within 24 hours of registering for training, following lectures 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 on the schedule to suit different time-zones.
  • In-Class Event: Travel to an education center to attend this course. Below is a selection of events already on the schedule.

 Location

 Date

 Delivery Language

 Brussels, Beligum

 10 November 2014

 English

 Sao Paolo, Brazil

 25 August 2014

 Brazilian Portuguese

 London, England

 20 October 2014

 English

 Milan, Italy

 20 October 2014

 Italian

 Rome, Italy

 1 December 2014

 Italian

 Riga, Latvia

 29 September 2014

 Latvian

 Petaling Jaya, Malaysia

 22 September 2014

 English

 Utrecht, Netherlands

 10 November 2014

 English

 Warsaw, Poland

 1 September 2014

 Polish

 Barcelona, Spain

 14 October 2014

 Spanish

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 Aug 11, 2014

Database Modelling is Key to Getting Started on the MySQL Database

Database modelling is the process of defining the logical structure of a database. This structure determines how data is stored, organized and manipulated. This enables you to:

  • Understand your data before building the database
  • Consider what questions your data must answer

The entity relationship model (ERM) is the most common model for an RDBMS.

Learn more about database modelling, design and much more in the MySQL for Beginners training course.

You can take this 4-day instructor-led training course via the following formats:

  • Training-on-Demand: Start training within 24 hours of registration. Follow lectures at your own pace through streaming video. Book time on a lab environment to suit your own 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.
  • In-Class Event: Travel to an education center to attend this course. Below is a selection of the in-class events already on the schedule.

 Location

 Date

 Delivery Language

 Brussels, Belgium

 8 September 2014

 English

 Sao Paolo, Brazil

 6 October 2014

 Brazilian Portuguese

 Cairo, Egypt

 14 September 2014

 Arabic

 London, England

 11 November 2014

 English

 Rome, Italy

 3 November 2014

 Italian

 Dehli, India

 19 August 2014

 English

 Nairobi, Kenya

 8 September 2014

 English

 Riga, Latvia

 3 November 2014

 Latvian

 Petaling Jaya, Malaysia

 20 October 2014

 English

 San Pedro Garza Garcia

 24 November 2014

 Spanish

 Utrecht, Netherlands

 8 September 2014

 English

 Lisbon, Portugal

 22 September 2014

 European Portuguese

 Porto, Portugal

 22 September 2014

 European Portuguese

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 Aug 04, 2014

Handling Error Messages and Warnings with MySQL

To ensure that your MySQL Database works as efficiently as possible, it is important to know how to handle error messages and warnings.

Error messages have three components:

  • A MySQL-specific error code, such as 1146
  • A SQLSTATE error code. These codes are defined by standard SQL and the ODBC standard.
  • A text message that describes the problem

MySQL Server generates a warning when it is not fully able to comply with a request or when an action has possibly unintended side effects. You can display these warnings with the SHOW WARNINGS statement.

To learn about handling error messages and warnings along with other developer topics, consider taking the MySQL for Developers training course.

You can take this 5-day course as a:

  • Live-virtual event: Attend a live training event from your own desk, no travel required. Choose from a selection of events on the schedule to suti different timezones.
  • In-class event: Travel to an education center to attend a class. Below is a selection of the events already on the schedule.

 Locaation

 Date

 Delivery Languaage

 Vienna, Austria

 27 November 2014

 German

 Brussels, Belgium

 8 December 2014

 English

 Sao Paolo, Brazil

 13 October 2014

 Brazilian Portuguese

 London, England

 29 September 2014

 English

 Belfast, Ireland

 6 October 2014

 English

 Dublin, Ireland

 27 October 2014

 English

 Milan, Italy

 10 November 2014

 Italian

 Rome, Italy

 13 October 2014

 Italian

 Nairobi, Kenya

 15 September 2014

 English

 Petaling Jaya, Malaysia

 25 August 2014

 English

 Utrecht, Netherlands

 8 December 2014

 English

 Makati City, Phillippines

 29 September 2014

 English

 Warsaw, Poland

 25 August 2014

 Polish

 Lisbon, Portugal

 13 October 2014

 European Portuguese

 Porto, Portugal

 13 October 2014

 European Portuguese

 Barcelona, Spain

 29 October 2014

 Spanish

 Madrid, Spain

 3 November 2014

 Spanish

 Valencia, Spain

 24 November 2014

 Spanish

 Basel, Switzerland

 13 October 2014

 German

 Bern, Switzerland

 13 October 2014

 German

 Zurick, Switzerland

 13 October 2014

 German

The MySQL for Developers course is the recommended training for the MySQL 5.6 Developers OCP certification exam.

To register for the MySQL for Developers course, request an additional event, or learn more about 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 Jul 07, 2014

MySQL Cluster High Availability Through Data Replicas

MySQL Cluster enables high availability by storing data replicas on multiple hosts. MySQL Cluster maintains connections between data nodes by using high-speed interconnects over TCP/IP - standard or direct connections - or SCI (Scalable Coherent Interface) sockets.

To learn more about MySQL Cluster, take the MySQL Cluster training course.

This course is currently scheduled for the following locations:

 Location

 Date

 Delivery Language

 Sao Paulo, Brazil

 28 July 2014

 Brazilian Portuguese

 Berlin, Germany

 11 August 2014

 German

 Hamburg, Germany

 29 September 2014

 German

 Munich, Germany

 15 December 2014

 German

 Rome, Italy

 8 September 2014

 Italian

Seoul, Korea

28 July 2014 

 Korean 

Petaling Jaya, Malaysia

16 July 2014 

English 

Warsaw, Poland

28 July 2014 

Polish 

Singapore

 29 July 2014

 English 

Edison, NJ, United States

18 August 2014 

English 

San Francisco, CA, United States

13 August 2014 

English 

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 Jun 30, 2014

P for PHP, M for MySQL in LAMP, Learn Their Roles in Web Application Development

Understanding and installling the components of the LAMP stack are the first steps to learning the role of Linux, the Apache Server, MySQL and PHP in developing web applications. To learn more, take the MySQL and PHP - Developing Dynamic Web Application training course.  

You can take this 4-day, instructor-led course as a:

  • Live-Virtual Event: Take this class from your own desk, no travel required. Choose from events already on the schedule to suit different time-zones. These events are delivered in English.
  • In-Class Event: Travel to an education center to take this class, for example at

 Location

 Date

 Delivery Location

 Rome, Italy

 29 September 2014

 Italian

 Warsaw, Poland

 22 September 2014

 Polish

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 Jun 16, 2014

Normalize Your MySQL Database For Efficient Data Access, Query Flexibility and Maintenance

Before you start creating database entities, spend some time designing your database to ensure that it is fit for your purpose. The time you invest in this process saves a lot of time and trouble later. Professional database designers fine-tune their design using a process called 'normalization'. The normalization process takes your database design through a number of 'normal forms', which aim to ensure efficient data access, greater query flexibility, and easier maintenance.

For example, the First Normal Form (or '1NF') ensures that all your database columns contain only a single value. A column that contains multiple data values is difficult to access and keep up to date. It also ensures that each table row only represents a single 'real world' item. Like all the other normal forms, this encourages you to split your data across multiple tables, with less rows in each table. You can quickly see the benefits of this approach as your database grows.

To learn more about normalization and other topics that help you get started with the MySQL database, take the MySQL for Beginners training course. You can take this 4-day training course as:

  • Training-on-Demand: Start training within 24 hours of registering. Follow lectures through streaming video at your own pace and book time on a lab environment to suit your own 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 attend this class. Below is a selection of the events already on the schedule.

 Location  Date  Delivery Language
 Brussels, Belgium
 7 July 2014
 English
 Sao Paulo, Brazil
 23 June 2014
 Brazilian Portuguese
 Cairo, Egypt
 14 September 2014
Arabic
 London, England
 28 July 2014
 English
 Milan, Italy
 14 July 2014
 Italian
 Nairobi, Kenya
 7 July 2014
English
Riga, Latvia
 3 November 2014
Latvian
 Petaling Jaya, Malaysia
 14 July 2014
 English
 Utrecht, Netherlands
 7 July 2014
 English
 Lisbon Portugal
 22 September 2014
 European Portuguese
 Porto, Portugal
 22 September 2014
 European Portuguese

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 Jun 09, 2014

Optimizing MySQL, Improving Performance of Database Servers

Optimization involves improving the performance of a database server and queries that run against it. Optimization reduces query execution time and optimized queries benefit everyone that uses the server. When the server runs more smoothly and processes more queries with less, it performs better as a whole. To learn more about how a MySQL developer can make a difference with optimization, take the MySQL Developers training course.

This 5-day instructor-led course is available as:

  • 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 timezones.
  • In-Class Event: Travel to an education center to attend an event. Below is a selection of the events on the schedule.

 Location

 Date

 Delivery Language

 Vienna, Austria

 17 November 2014

 German

 Brussels, Belgium

 8 December 2014

 English

 Sao Paulo, Brazil

 14 July 2014

 Brazilian Portuguese

London, English

 29 September 2014

 English

  Belfast, Ireland

 6 October 2014

 English

 Dublin, Ireland

 27 October 2014

 English

 Milan, Italy

 10 November 2014

 Italian

 Rome, Italy

 21 July 2014

 Italian

 Nairobi, Kenya

 14 July 2014

 English

 Petaling Jaya, Malaysia

 25 August 2014

 English

 Utrecht, Netherlands

 21 July 2014

 English

 Makati City, Philippines

 29 September 2014

 English

 Warsaw, Poland

 25 August 2014

 Polish

 Lisbon, Portugal

 13 October 2014

 European Portuguese

 Porto, Portugal

 13 October 2014

 European Portuguese

 Barcelona, Spain

 7 July 2014

 Spanish

 Madrid, Spain

 3 November 2014

 Spanish

 Valencia, Spain

 24 November 2014

 Spanish

 Basel, Switzerland

 4 August 2014

 German

 Bern, Switzerland

 4 August 2014

 German

 Zurich, Switzerland

 4 August 2014

 German

The MySQL for Developers course helps prepare you for the MySQL 5.6 Developers 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 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 May 19, 2014

Automatic Database Sharding with MySQL Cluster

MySQL Cluster automatically shards at the database layer, spreading the database out across nodes so that developers do not have to write complex and intrusive application-sharding logic (which is required by other platforms).

To understand the types of nodes in a MySQL Cluster and to learn how to design, install, configure, and maintain this product, take the MySQL Cluster training course. Below is a selection of the events already on the schedule for this 3-day training course:

 Location  Date  Delivery Language
Sao Paolo, Brazil
28 July 2014 Brazilian Portuguese
Berlin, Germany
11 August 2014 German
Hamburg, Germany
29 September 2014 German
Munich, Germany
16 July 2014 German
Seoul, Korea
23 June 2014 Korean
Petaling Jaya, Malaysia
16 July 2014 English
Warsaw, Poland
4 June 2014 Polish
San Francisco, CA, United States
28 May 2014 English

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 May 12, 2014

MySQL and PHP, a Great Combination for Web Development

When you use MySQL and PHP, a PHP script can retrieve data from a MySQL database to display on the web page before the page is returned to the client. Such pages are known as dynamic web pages and can perform multiple actions including sending e-mails, embedding other web page content and interacting with databases. 

To learn more about developing on the web with MySQL and PHP, take the MySQL and PHP: Developing Dynamic Web Applications course. You can take this 4-day live instructor-led course as a:

  • Live-Virtual Event: Attend a live event from your own desk - no travel required. Choose from a selection of your events already on the schedule including 22nd July, 9th September and 27th October 2014.
  • In-Class Event: Travel to an education center to attend this class.

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 Apr 28, 2014

Benchmarking MySQL Performance

Benchmarking lets you test how a system responds when it is given work to do, and removes the guesswork from your performance tuning efforts. The workloads you use when benchmarking are very different from real life deployments, which can be extremely variable. If you remember this, benchmarking is extremely useful, enabling you to measure current performance and determine the performance impact of any changes. Such changes could be the addition of new hardware or opening up your application to more users.

Benchmarking is one of the topics that you can learn more about by taking the MySQL Performance Tuning course. You can take this course in the following formats:

  • Training-on-Demand: Start training within 24 hours of registration, following lecture delivery at your own pace and scheduling time on a lab environment at your convenience.
  • Live-Virtual Events: 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.
  • In-Class Events: 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

 10 June 2014

 English

Sao Paolo, Brazil

 26 May 2014

 Brazilian Portuguese

London, England

 20 October 2014

 English

Milan, Italy

 28 July 2014

 Italian

Rome, Italy

 23 June 2014

 Italian

Riga, Latvia

 29 September 2014

 Latvian

Petaling Jaya, Malaysia

 5 May 2014

 English

Utrecht, Netherlands

 10 June 2014

 English

Warsaw, Poland

 20 May 2014

 Polish

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

To read an expert writing about MySQL benchmarks and other topics related to MySQL performance, have a look at http://dimitrik.free.fr/blog.

Monday Apr 21, 2014

Start Learning MySQL Database at Your Own Pace

The MySQL for Beginners training course is your first step to mastering relational databases concepts, using MySQL products.

You can take this training course at your own pace through the Training-on-Demand delivery option. Watch recorded training sessions by Oracle expert instructors and have access to a dedicated lab environment to get hands-on experience. With a Training-on-Demand course, you can start training within 24 hours of registration, booking time to do lab exercises at your own convenience.

In the MySQL for Beginners course, you will use the world's most popular open source database 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
  • Employ appropriate MySQL tools

You can also take this course in live events as a live-virtual class, training from your own desk, or by traveling to an education center to attend an in-class event. Below is a selection of the in-class events already on the schedule:

 Location  Date  Delivery Language
Sao Paolo, Brazil
5 May 2014 Brazilian Portuguese
London, England
28 July 2014 English
Milan, Italy
14 July 2014 Italian
Rome, Italy
12 May 2014 Italian
Turin, Italy
12 May 2014 Italian
Riga, Latvia
26 May 2014 Latvian
Petaling Jaya, Malaysia
12 May 2014 English
Lisbon, Portugal
22 September 2014 European Portuguese
Porto, Portugal
22 September 2014 European Portuguese

To register for a class 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
« May 2015
SunMonTueWedThuFriSat
     
2
3
4
5
6
8
9
10
13
14
15
16
17
19
20
21
22
24
25
26
27
29
30
31
      
Today