Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 30 of 187 Next 30 Older Entries

Displaying posts with tag: Training (reset)

MySQL for Database Administrators Training Available in Eight Languages
Employee_Team +0 Vote Up -0Vote Down

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
  [Read more...]
Items Affecting Performance of the MySQL Database
Employee_Team +1 Vote Up -0Vote Down

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
  [Read more...]
Database Modelling is Key to Getting Started on the MySQL Database
Employee_Team +0 Vote Up -0Vote Down

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
  [Read more...]
Handling Error Messages and Warnings with MySQL
Employee_Team +1 Vote Up -0Vote Down

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

  [Read more...]
Setting up and Using MySQL Replication
Employee_Team +1 Vote Up -0Vote Down

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  

  [Read more...]
Save 20% With MySQL Training and Certification Packages
Employee_Team +2 Vote Up -0Vote Down

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.

MySQL Cluster High Availability Through Data Replicas
Employee_Team +0 Vote Up -0Vote Down

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

  [Read more...]
P for PHP, M for MySQL in LAMP, Learn Their Roles in Web Application Development
Employee_Team +1 Vote Up -0Vote Down

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

  [Read more...]
Normalize Your MySQL Database For Efficient Data Access, Query Flexibility and Maintenance
Employee_Team +0 Vote Up -0Vote Down

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

  [Read more...]
Optimizing MySQL, Improving Performance of Database Servers
Employee_Team +0 Vote Up -0Vote Down

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:
  [Read more...]
Securing User Account Details with MySQL
Employee_Team +0 Vote Up -0Vote Down

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

  [Read more...]
MySQL High Availability With Percona XtraDB Cluster (Percona MySQL Training)
+1 Vote Up -0Vote Down

I’ve had the opportunity to train lots of people on Percona XtraDB Cluster (PXC) over the last few years the product has existed.  This has taken the form of phone calls, emails, blog posts, webinars, and consulting engagements. This doesn’t count all the time I’ve spent grilling Codership on how things actually work.  But it has culminated in the PXC tutorial I have given annually at Percona Live MySQL Conference and Expo in Santa Clara, California for the last two years.  

  [Read more...]
Automatic Database Sharding with MySQL Cluster
Employee_Team +1 Vote Up -0Vote Down

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
  [Read more...]
MySQL and PHP, a Great Combination for Web Development
Employee_Team +1 Vote Up -0Vote Down

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
  [Read more...]
Benchmarking MySQL Performance
Employee_Team +1 Vote Up -0Vote Down

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
  [Read more...]
Start Learning MySQL Database at Your Own Pace
Employee_Team +1 Vote Up -0Vote Down

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:

      [Read more...]
    Developing with MySQL and NoSQL
    Employee_Team +1 Vote Up -0Vote Down

    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

      [Read more...]
    MySQL Utilities Make a DBA More Efficient and Productive
    Employee_Team +0 Vote Up -0Vote Down

    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

      [Read more...]
    MySQL Cluster in Environments Requiring Real-Time Analytics
    Employee_Team +0 Vote Up -0Vote Down

    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
      [Read more...]
    Use MySQL API Extensions to Create Dynamic Web Pages
    Employee_Team +0 Vote Up -0Vote Down

    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

      [Read more...]
    Improve MySQL Performance And Maximise System Usage
    Employee_Team +1 Vote Up -0Vote Down

    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
      [Read more...]
    DBAs, Learn about MySQL Where You Want, When You Want
    Employee_Team +0 Vote Up -0Vote Down

    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

      [Read more...]
    Demonstrate Your Expertise with MySQL 5.6 Certifications
    Employee_Team +2 Vote Up -0Vote Down

    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

      [Read more...]
    Beginning on the MySQL Command Line
    Employee_Team +0 Vote Up -0Vote Down

    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

      [Read more...]
    MySQL Connectors, a Real Plus for Developers
    Employee_Team +2 Vote Up -0Vote Down

    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

      [Read more...]
    MySQL Cluster is a Resilient and Scalable Database Platform
    Employee_Team +0 Vote Up -0Vote Down

    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

      [Read more...]
    How Important is the Performance of Your Database
    Employee_Team +0 Vote Up -0Vote Down

    Whether you are a database administrator, database application developer, web developer, system administrator or system architect, if you are working with a database system such as the MySQL Server, you will want to ensure the best possible performance. 

    To learn about the great performance you can get from a MySQL Database, visit Dimitri's blog.

    If you have experience maintaining a database server, can use MySQL tools and have knowledge of general SQL statements and SQL tuning principles, consider taking the MySQL Performance Tuning course. In this 4-day instructor-led course, you will learn about:

    • What to tune and why
      [Read more...]
    Configuring MySQL Server for Optimal Performance
    Employee_Team +0 Vote Up -0Vote Down

    Configuring MySQL Server, with the dozens of options available, has always been perceived as a bit of a black art. In MySQL Database 5.6, configuring your MySQL server for optimal performance is easier than ever before.

    In the MySQL for Database Administrators course you can learn more.

    MySQL 5.6 is configured to work faster out of the box in a wide range of installation scenarios and it is easier than ever to set up the server by adjusting only a small number of settings which cause others to be set. In addition, you get a new default my.cnf file with instructions guiding your through adjusting key settings. The

      [Read more...]
    MySQL is a Great Fit for Cloud-Based Deployments
    Employee_Team +1 Vote Up -0Vote Down

    MySQL's architecture and features make the database a great fit for cloud based deployments. If you are interested in using MySQL to deliver web-based applications and scale out, read the white paper MySQL, An Ideal Choice in the Cloud (http://www.mysql.com/why-mysql/white-papers/mysql-an-ideal-choice-for-the-cloud/).

    As a first step to using the MySQL database, take the MySQL for Beginners course. In this 4-day course, you learn to use the MySQL Server and tools while developing a knowledge of relational databases. You can take this course through the following delivery methods:

    • Training-on-Demand: Start training within 24 hours of registering and train at your own pace.
    • Live-Virtual Event:
      [Read more...]
    MySQL - An Excellent Choice for a Low Cost Embedded Database
    Employee_Team +1 Vote Up -0Vote Down

    MySQL is an excellent choice for a low cost embedded database. Over 3,000 ISVs, OEMs and VARs choose MySQL for this purpose and benefit from significant cost savings when compared to using a competing database product.

    The MySQL for Developers training course teaches you how to plan, design and implement applications using MySQL. Expert Oracle University instructors teach you through realistic examples, interactive instruction and hands-on exercises.

    This course brings you lots of interesting facts. For example, the 'libmysqld' library is effectively a MySQL server in its own right. it is shipped as part of the standard MySQL installation. Developers with C/C++ ability can embed this library

      [Read more...]
    Showing entries 1 to 30 of 187 Next 30 Older Entries

    Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

    Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.