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.

Monday Apr 14, 2014

Developing with MySQL and NoSQL

MySQL adopts a very different approach to 'NoSQL' than other databases. With the memcached plugin, MySQL provides the speed and high availability benefits of a standard 'NoSQL' database solution, while mitigating many of the drawbacks to this approach.

A traditional memcached application bypasses the SQL layer entirely, and stores all its data in memory. This makes data access extremely fast, but there is a risk that the data will disappear in the event of a system problem. 

The MySQL memcached plugin for InnoDB also bypasses the SQL and optimization layers, resulting in excellent performance. It goes further, writing key-value data directly to  InnoDB tables. The result is fast data access while retaining the advantages provided by the existing relational database infrastructure, such as the ability to run complex queries with SQL, maintain data integrity, provide real-time analytics to the business, and work with big data platforms such as Hadoop.

MySQL Developers can learn about topics such as using NoSQL and memcached, as well as much more in the MySQL for Developers course.

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

  • Live-Virtual Event: Take this course 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 course. Below is a selection of the events already on the schedule:

 Location  Date  Delivery Language
 Vienna, Austria
 17 November 2014
 German
 Brussels, Belgium
 12 May 2014
 English
 Sao Paolo, Brazil
 12 May 2014
 Brazilian Portuguese
 London, England
 29 September 2014
 English
 Rome, Italy
 19 May 2014
 Italian
 Nairobi, Kenya
 19 May 2014
 English
 Petaling Jaya, Malaysia
 14 April 2014
 English
 Utrecht, Netherlands
 12 May 2014
 English
 Makati City, Philippines
 29 September 2014
 English
 Lisbon, Portugal
 26 May 2014
 European Portuguese
 Porto, Portugal
 26 May 2014
 European Portuguese
 Madrid, Spain
 3 November 2014
 Spanish
 Valencia, Spain
 24 November 2014
 Spanish
 Basel, Switzerland
 4 August 2014
 German
 Bern, Switzerland
 4 August 2014
 German
 Zurick, Switzerland
 4 August 2014
 German

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

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

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 31, 2014

MySQL Cluster in Environments Requiring Real-Time Analytics

MySQL Cluster is used by many different industries. MySQL Cluster thrives in the most complex data environments that demand real-time analytics such as:

  • Financial trading with fraud protection
  • Feed-streaming analysis and recommendations
  • Massive online multiplayer games
  • Communication services

To learn more about MySQL Cluster, take the MySQL Cluster training course. Below is a selection of events already on the schedule for this 3-day instructor led course:

 Location  Date  Delivery Language
 Sao Paolo, Brazil
 28 April 2014
 European Portuguese
 Berlin, Germany
 26 May 2014
 German
 Hamburg, Germany
 29 September 2014
 German
 Munich, Germany
 14 April 2014
 German
 Rome, Italy
 12 May 2014
 Italian
 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 Mar 24, 2014

Use MySQL API Extensions to Create Dynamic Web Pages

To create dynamic web pages, you can use PHP, a server-side, HTML-embedded scripting language. PHP is available for most operating systems and can access the MySQL database. PHP provides MySQL API extensions, MySQL Improved Extension and MySQL Functions.

To learn more about using MySQL and PHP, you can consult the MySQL and PHP reference manual. You can also take the MySQL and PHP: Developing Dynamic WebApplications training course.

Through a hands-on approach, this 4-day instructor-led course will help you improve your PHP skills and combine them with time-proven database management techniques to create best-of-breed web applications that are efficient, solid and secure. You can take this course as a:

  • Live-Virtual Event: Attend a live class from your own desk - no travel required. Choose from the events on the schedule such as April 28th, July 22nd, and October 21st 2014.
  • In-Class Event: Travel to an education center to take a class, for example in Warsaw, Poland on the 22nd of April 2014.

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

Monday Mar 17, 2014

Improve MySQL Performance And Maximise System Usage

Some people think that performance tuning is all about reducing CPU or memory utilization. However CPU and memory are designed to be used. You should concentrate your efforts on improving the user experience by reducing response times. You can do this by optimizing your queries and by enabling your system to serve more requests.

To learn more about improving the performance of the MySQL database, consider taking the MySQL Performance Tuning course.

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

  • Training-on-Demand: Start training within 24-hours of registering, following lectures at your own pace via streaming video and booking time on a lab environment at a time that suits you.
  • Live-Virtual Class: 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 Events: Travel to an education center to take this class. Events already on the schedule include the following:

 Location

 Date

 Delivery Language

 Brussels, Belgium

 10 June 2014

 English

 Sao Paolo, Brazil

 14 April 2014

 Brazilian Portuguese

 London, England

 14 April 2014

 English

Rome, Italy 

 23 June 2014

Italian 

 Riga, Latvia

 29 September 2014

Latvian 

 Petaling Jaya, Malaysia

 5 May 2014

 English

 Mexico City, Mexico

 24 May 2014

 English 

 Utrecht, Netherlands

 10 June 2014

 English

 Warsaw, Poland

  20 May 2014 

Polish 

 Singapore

 11 April 2014

 English

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

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.

Monday Mar 03, 2014

Demonstrate Your Expertise with MySQL 5.6 Certifications

Demonstrate your expertise with MySQL 5.6, and improve your career prospects, by taking the new MySQL 5.6 certifications:

These certifications give you a competitive advantage, by proving you have a skill set that is in demand, worldwide, while demonstrating your commitment to continuous learning.You can sign up now for these certifications via PearsonsVue.

To pass these certifications you need to have a good knowledge of the relevant areas of MySQL and significant hands-on experience. One step in your exam preparation could be to take the training course recommended for the certification of your choice.

MySQL for Database Administrators

You can take this instructor-led course through the following delivery methods:

  • Training-on-Demand: Start training within 24 hours of registration, training at your own pace.
  • Live-Virtual Event: Attend a live event from your own desk, no travel required.
  • In-Class Event: Travel to an education center to take this course. Below is a selection of events already on the schedule.

 Location

 Date

 Delivery Language

 Brisbane, Australia

 17 March 2014

 English

 Brussels, Belgium

 31 March 2014

 English

 Sao Paolo, Brazil

 10 March 2014

 Brazilian Portuguese

 London, England

 19 May 2014

 English

 Milan, Italy

 12 May 2014

 Italian

 Rome, Italy

 14 April 2014

 Italian

 Turin, Italy

 24 March 2014

 Italian

 Nairobi, Kenya

 24 March 2014

 English

 Petaling Jaya, Malaysia

 3 March 2014

 English

 Mexico City, Mexico

 3 March 2014

 Spanish

 San Pedro Garza Garcia, Mexico

 3 March 2014

 Spanish

 Utrecht, Netherlands

 12 May 2014

 English

 Lagos, Nigeria

 7 April 2014

 English

 Makati City, Philippines

 28 April 2014

 English

 Warsaw, Poland

 7 April 2014

 Polish

 Singapore

 24 March 2014

 English

 Barcelona, Spain

 7 April 2014

 Spanish

 Madrid, Spain

 3 March 2014

 Spanish

 Tunis, Tunisia

 24 March 2014

 French

 Istanbul, Turkey

 24 March 2014

Turkish 

MySQL for Developers

You can take this instructor-led course from your own desk as a live-virtual event or travel to an education center for an in-class event. Below is selection of in-class events already on the schedule:

 Location

 Date

 Delivery Language

 Brussels, Belgium

 12 May 2014

 English

 Sao Paolo, Brazil

 12 May 2014

 Brazilian Portuguese

 Milan, Italy

 7 April 2014

 Italian

 Rome, Italy

 19 May 2014

 Italian

 Petaling Jaya, Malaysia

 21 April 2014

 English

 Utrecht, Netherlands

 12 May 2014

 English

 Lisbon, Portugal

 26 May 2014

 European Portuguese

 Porto, Portugal

 26 May 2014

 European Portuguese

 Madrid, Spain

 17 March 2014

 Spanish

 Valencia, Spain

 21 April 2014

 Spanish

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

Monday Feb 24, 2014

Beginning on the MySQL Command Line

If you are starting out on the MySQL command line client, you might be interested in the following information.

When you use the MySQL command line client, it is often useful to log the commands you enter and the response you receive back from the MySQL server. The MySQL 'tee' command allows you to do this very simply and conveniently. Just enter 'tee' followed by the path to the file you want to log the session to (normally referred to as the 'tee' file). From that point on, all your session activity is logged to that file. To cancel tee file logging, just execute 'notee'.

To learn more about getting started on the MySQL Database, take the MySQL for Beginners training course. You can take this 4-day course through the following delivery methods:

  • Training-on-Demand: Start training within 24 hours of registration, following the course at your own pace.
  • 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

 Brussels, Belgium

 17 March 2014

 English

 Sao Paolo, Brazil

 5 May 2014

 Brazilian Portuguese

 Cairo, Egypt

 23 March 2014

 Arabic

 London, England

 24 March 2014

 English

 Turin, Italy

 12 May 2014

 Italian

 Nairobi, Kenya

 10 March 2014

 English

 Riga, Latvia

 26 May 2014

  Latvian 

Petaling Jaya, Malaysia 

12 May 2014 

 English

Mexico City, Mexico 

 21 April 2014

Spanish 

 San Pedro Garza Garcia, Mexico

 3 March 2014

 Spanish

  Utrecht, Netherlands

17 March 2014 

English 

 Lagos, Nigeria

14 April 2014 

 English

 Warsaw, Poland

31 March 2014 

 Polish

 Lisbon, Portugal

 14 April 2014

 European Portuguese

 Porto, Portugal

14 April 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 Feb 17, 2014

MySQL Connectors, a Real Plus for Developers

MySQL Connectors provide connectivity to the MySQL server for client programs. APIs provide low-level access to the MySQL protocol and MySQL resources. Both Connectors and the APIs enable you to connect and execute MySQL statements from another language or environment. Oracle provides a number of these, enabling developers to build database applications in the language of their choice. Among those developed by Oracle are drivers for JDBC and ODBC. Any system that works with JDBC or ODBC can use MySQL. And you can find many more, including drivers for PHP, Perl, Python, Ruby, Tcl and even Eiffel!

To get a head start on developing with MySQL, take the MySQL for Developers training course. This 5-day training course, created with the MySQL experts, is available as a:

  • Live-Virtual Event: Take this course from your own desk - no travel required. You can choose from a selection of events on the schedule to suit different timezones.
  • 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

 12 May 2014

 English

 Sao Paolo, Brazil

 12 May 2014

 Brazilian Portuguese

 Milan, Italy

 7 April 2014

 Italian

 Rome, Italy

 10 March 2014

 Italian

 Petaling Jaya, Malaysia

 21 April 2014

 English

 Utrecht, Netherlands

 12 May 2014

 English

 Makati City, Philippines

 17 March 2014

 English

 Lisbon, Portugal

 26 May 2014

 European Portuguese

 Porto, Portugal

 26 May 2014

 European Portuguese

 Singapore

 17 February 2014

 English

 Madrid, Spain

 17 March 2014

 Spanish

 Valencia, Spain

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

Prove your MySQL Developer skills by taking the MySQL 5.6 Developers certification exam which is well aligned with the MySQL for Developers training course.

Monday Feb 10, 2014

MySQL Cluster is a Resilient and Scalable Database Platform

MySQL Cluster is a highly resilient and scalable database platform designed to deliver 99.999% availability with features such as self-healing and online operations, and capable of performing over 1,00,000,000 updates per minute. The full feature set includes development and management platforms alongside monitoring and administration tools, all backed by Oracle Premier Lifetime Support.

To learn more about MySQL Cluster, consider taking the MySQL Cluster training. Events already on the schedule for this 3-day instructor-led course include:

 Location

 Date

 Delivery Language

 Berlin, Germany

 26 May 2014

 German

 Munich, Germany

 14 April 2014

 German

  Rome, Italy

 17 February 2014

 Italian

 Petaling Jaya, Malaysia

 16 July 2014

 English

 Warsaw, Poland

 12 March 2014

 Polish

 San Francisco, CA, United States

 28 May 2014

 English

To register for this course, to request an additional event, or 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
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