MySQL enables innovative Developers to create and deploy the next generation of web, embedded and Cloud/SaaS/DaaS applications on the latest generation of development frameworks and hardware platforms.

By taking the MySQL for Developers course, you will learn to write applications with the MySQL database server.

This course examines the tools used by MySQL development professionals. Expert instructors reference real-world examples when illustrating how to generate complex queries, and consume them in your application. You will perform lab work with Java and PHP, connecting to MySQL databases and executing queries and stored routines.

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

• Live-Virtual Class Event: No travel required. Follow the class from your own desk. …

Oracle, MySQL, and SQL Server bloggers are not only sharing their knowledge through their blogs, moreover, they are also learning about themselves. Their posts are cementing their concepts, while opening vistas of new notions. This Log Buffer Edition is yet another vista for their blogs.

Oracle:

Where is Oracle Block Change Tracking today? World’s leading Oracle expert Alex Gorbachev answers.

Marcin Przepiorowski is asking: Oracle on AIX – where’s my cpu time?

Kyle Hailey is monitoring Oracle I/O latency.

How EBS Concurrent Processing should run on Oracle RAC? Pythian’s own …

What better time to start learning about the world's most popular open-source database - now that MySQL 5.6 has been released. With its increased performance, scalability, reliability and manageability, MySQL 5.6 helps users meet the most demanding Web, Cloud and embedded application requirements.

Virtual Developer's Day for MySQL

The first Virtual Developer Day for MySQL will take place on March 12 at 9:00 a.m. US, Pacific Time. The event will include presentations and hands-on labs to educate MySQL users on essential skills and the latest features in MySQL 5.6. Register  here.

MySQL for Beginners Training

In the MySQL for Beginners …

If you are looking for some of the great blog posts of the week in database technologies like Oracle, SQL Server and MySQL, then Log Buffer #307 is the place to be. Enjoy.

Oracle:

When Jeremy Schneider writes, it stays written. He relishes and shares as how to troubleshoot OEM  12c Cloud Control Auto-Discovery.

Chris Kawalek informs that Oracle VM provides SAP customers with a fully supported and certified virtualization environment for the Oracle database.

Peter Lorenzen is hardening the Apache HTTP Server.

…

A few years ago, I used MySQL Sandbox to filter binary logs. While that one was a theoretical case, recently I came across a very practical case where we needed to provision an Oracle database, which is the designated slave of a MySQL master.

In this particular case, we needed to provision the Oracle slave with some auditing features in place. Therefore, mass load functions were not considered. What we needed was the contents of the MySQL database as binary rows i.e. the same format used for row-based replication.

To achieve the purpose as quickly and as painlessly as we could, I thought to employ the services of a MySQL Sandbox. The flow of information would be like this:

1. Install a sandbox, using the same version and character set of the master;
…

I had an interesting conversation about table functions in Oracle’s PL/SQL; and the fact that they’re not available in MySQL. When I explained they’re available in Microsoft T-SQL User-Defined Functions (UDFs), my students wanted a small example. One of them said they’d tried to do it but couldn’t get it to work because they found the Microsoft web pages difficult to read and use. Specifically, they didn’t like the sparseness of this one on how to create a function.

Here’s a quick definition of a UDF table function that runs in the studentdb schema (created in this post for migrating SQL Server into a MySQL database). The following getConquistador function takes a single string, which acts to filter the result set …

Get the most out of the great new release, MySQL 5.6, by taking the MySQL for Database Administrators training course.

During this 5 day instructor-led course you configure replication between multiple instances, design advanced replication topologies and recover from replication, network, or hardware failure taking advantage of MySQL 5.6 replication performance.

You also gain knowledge on the following:

Set up the Server and Databases

This course teaches you how to install, configure, maintain and tune databases for a wide variety of workloads and environments. You will install and configure MySQL and set appropriate configuration options. You will also connect to the server, using …

Teradata results. Funding for DataXu. The chemistry of data. And more.

For 451 Research clients: Oracle launches major update to MySQL open source database bit.ly/TSONAt

— Matt Aslett (@maslett) February 8, 2013

For 451 clients: Analyzing the chemistry of data bit.ly/TSOV2R By @451wendy Treating sensitive data like dangerous chemicals

— Matt Aslett (@maslett) February 8, 2013

Teradata: Q4 net income $112m on revenue up 10% to $740m, FY net income $419m on revenue up 13% to $2.7bn. bit.ly/14FNS8L (PDF)

— Matt …

One of the most complicated aspects of putting together our database landscape map was dealing with the growing number of (particularly NoSQL) databases that refuse to be pigeon-holed in any of the primary databases categories.

I have begun to refer to these as “multi-model databases” in recognition of the fact that they are able to take on the characteristics of multiple databases. In truth though there are probably two different groups of products that could be considered “multi-model”:

True multi-model databases that have been designed specifically to serve multiple data models and use-cases

Examples include:
FoundationDB, which is being designed to support ACID and NoSQL, but more to the point …

Bloggers are striving hard to up their game. They are writing, editing, formatting, trimming, enhancing their blogs to offer maximum value. This Log Buffer Edition #306 cherishes these efforts.

Oracle:

To use ASMlib or not to use ASMlib? That is the question, and James Morle has more.

This is what happens when a vacation in Hawaii fades away for Richard Foote.

Charles Hooper has a feeling ANSI About Oracle Join Syntax?

…