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 37 Next 7 Older Entries

Displaying posts with tag: Developer (reset)

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.

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...]
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...]
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...]
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...]
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...]
Get MySQL 5.6 Certified at a Much Reduced Price
Employee_Team +1 Vote Up -0Vote Down

You have already heard the great news that you can now prove your knowledge of MySQL Server 5.6 with the new MySQL certification exams:

Until December 21th 2013, these exams are beta phase so you get a fully-fledged certification at a much reduced price; for example $50 in the United States or 39 euros in the euro zone.

There is a lot of excitement around these new

  [Read more...]
New MySQL Certification Exams
Employee_Team +1 Vote Up -0Vote Down

Want to prove your expertise with MySQL? Why not get certified.

Oracle has just announced the release of the new MySQL Certification Path including the:

You can register for these certification exams from today. Learn more about these certifications on the Oracle University blog.

Successful candidates will require a strong MySQL experience. Although

  [Read more...]
MySQL for Java and PHP Developers
Employee_Team +0 Vote Up -0Vote Down

The MySQL for Developers 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. This course covers Java and PHP languages.

You can take this course as:

  • A Live-Virtual event: Take this course from your own desk, no travel required. Choose from a wide selection of events on the schedule to suit different timezones.
  • An In-Class event: Travel to an education center to take this class. Below is a selection of in-class events already on the schedule.

  [Read more...]
Java and PHP Developers, Learn about the MySQL Database
Employee_Team +1 Vote Up -0Vote Down

The MySQL for Developers course teaches you the knowledge, skills, tools and issues involved in writing applications with the MySQL database server. It forms the core of the MySQL Developer learning path.

During this 5-day course, you will perform lab work with Java and PHP, connecting to MySQL databases and executing queries and stored routines. Enrolling in this course will simultaneoursly help you prepare for the Oracle Certified Professional, MySQL Developer certification.

You can take this instructor-led course as a:

  • Live-virtual event: Take this class live, from your own desk. No travel required. You can choose from a wide selection of events on the schedule
  [Read more...]
Learn to Develop Your New Applications on the MySQL Database
Employee_Team +2 Vote Up -0Vote Down

Get the most out of your MySQL environment by learning to develop your new applications cost-effectively using MySQL with different languages such as Java and PHP.

The MySQL for Developers course is a 5 day, live, instructor-led course where you learn to:

  • Use MySQL tools to connect to databases.
  • Examine database structure and contents.
  • Generate database structure diagrams.
  • Execute complex queries and stored routines.
  • Manipulate numeric, text, spatial and temporal data.
  • Execute complex subqueries and joins.

You can take this course as a:

  • Live-Virtual Event: Take this course from your own desk - no travel required. Choose from one of the many events
  [Read more...]
Learn to Develop Dynamic Web Applications with MySQL and PHP Training
Employee_Team +0 Vote Up -0Vote Down

Take the MySQL and PHP - Developing Dynamic Web Applications course to learn to develop applications in PHP and how to use MySQL for those applications. This 4-day class helps 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 live instructor-led course as a:

  • Live-virtual event: Take this class from your own desk, choosing from many events on the schedule to suit different time-zones.
  • In-class: Travel to an education center. Some events already on the schedule include:

  [Read more...]
Enhance Your MySQL Skills with Virtual Developer Day: MySQL
Employee_Team +6 Vote Up -0Vote Down

MySQL is the world’s most popular open-source database, and powers websites and applications of numerous leading and fast-growing organizations.


On March 12, we’re hosting the first Virtual Developer Day: MySQL at 9am PST to give you a one-stop shop to learn all the essential MySQL skills and the latest features in MySQL 5.6 GA. With a combination of presentations and hands-on lab experience, you’ll have the opportunity to practice in your own environment and gain more in-depth knowledge to successfully design, develop, and manage your MySQL databases.


  [Read more...]
Top 5 Developer Enabling Nuggets in MySQL 5.6
Employee_Team +8 Vote Up -1Vote Down

MySQL 5.6 is truly a better MySQL and reflects Oracle's commitment to the evolution of the most popular and widely
used open source database on the planet.  The feature-complete 5.6 release candidate was announced at MySQL Connect in late September and the production-ready, generally available ("GA") product should be available in early 2013.  

While the message around 5.6 has been focused mainly on mass appeal, advanced topics like performance/scale, high availability, and self-healing replication clusters, (http://www.mysql.com/news-and-events/web-seminars/display-733.html) MySQL 5.6 also provides many developer-friendly nuggets that
are designed to enable those who are building the next generation



  [Read more...]
Using CURDATE() the wrong way
+1 Vote Up -0Vote Down

It has been a while since I wrote on this blog. Basically I had too much on my mind (expanding my department, holidays, etc) to actually write here and I’ll promise to post more regularly from now onwards. ;)

Anyway, as the title already suggests: I found out how you can use CURDATE() in a wrong way. One of the developers in my company asked me to help him out as his code all of a sudden did not work properly anymore. Or even better: it used to process several thousands of rows and all of a sudden it processed none.

I looked at his code snippet and it was quite a long query with a lot of brackets:

SELECT SUM(some_count_col), logdate, loghour FROM logs
WHERE


  [Read more...]
IOUG Podcast 24-AUG-2012 Rumors of MySQL’s Doom by Oracle / Design Piracy
+2 Vote Up -4Vote Down
For the week of August 24th, 2012: Everybody’s Preparing for OpenWorld Dispelling the Rumors of MySQL’s Impending Doom On Piracy of Design IOUG Podcast 24-AUG-2012 Rumors of MySQL’s Doom by Oracle / Design Piracy Subscribe to this Podcast (RSS) or … Continue reading →
The Art of Resistance
+1 Vote Up -1Vote Down

Read the original article at The Art of Resistance

Sometimes, you have to be the bad guy. Be resistant to change. Here’s a story about how stubbornness pays off. As we’ve written about before A 4 letter word divides Dev & Ops.

I had one experience working as the primary MySQL DBA for an internet startup. Turns out they had Oracle for some applications too. And another DBA just to handle the Oracle stuff.

So it came time for Oracle guy to go on vacation. Suddenly these Oracle systems landed on my shoulders. We reviewed

  [Read more...]
Can’t Travel to Collaborate 12? Plug-in Virtually Instead! (revised schedule)
+0 Vote Up -0Vote Down
  Plug-in to Vegas The program focuses on key topics such as high availability, virtualization, security, business intelligence, Exadata, Cloud Computing and internals.  Recently added, we switched around the schedule to include the Thursday Deep Dive, Avoiding Downtime through the Maximum … Continue reading →
Collaborate 2012 Registration is Now Open!
+3 Vote Up -0Vote Down
http://collaborate12.ioug.org   Double Down at COLLABORATE 12- The IOUG Forum with Two Ways to Save- and a Chance to Win! The user-driven Oracle event of the year is fast-approaching, and IOUG wants you to make youreducational experience a sure bet. Between … Continue reading →
OTN Developer Day: MySQL is Coming to Washington, DC
Employee_Team +3 Vote Up -0Vote Down

We organized our first OTN Developer Day: MySQL earlier this year in Santa Clara, CA, and the result far exceeded our expectation. Before we kicked off the seminar at 9am, the attendees had already taken every single seat in the beautiful auditorium in Oracle's Santa Clara campus, and there was still a line in front of the registration desk. We recruited MySQL experts from several teams to present, and had great questions and discussions along the way and at the end. I personally received many positive comments

  [Read more...]
Oracle Selects Pearson VUE to Deliver MySQL Certification Exams
Employee_Team +0 Vote Up -0Vote Down
Effective June 1, 2011, MySQL certification exams will be offered exclusively through a new test delivery partner — Pearson VUE — and will no longer be available through Prometric. This will consolidate all Oracle Certification exams within the operations of a single testing vendor so we can provide better service and global testing coverage for these Oracle certification exams. Pearson VUE currently has over 5,000 test centers worldwide in 165 countries.

To help prepare you for this transition, here are some important dates for you to be aware of:
  • If you are currently following a certification path and are planning to take an exam on/after June 1: Registration has began at Pearson VUE on May 16, 2011 for all scheduled exams on or after June 1. Visit pearsonvue.com/oracle to create a new web account



  [Read more...]
Adopting RAD in the Enterprise: The 14 Biggest Misconceptions
+0 Vote Up -0Vote Down

Rapid Application Development (RAD) is a way of developing computer software applications with less effort than the traditional means.

RAD tools focus on providing code generation and automated testing capabilities with the use of convention over configuration to provide a streamlined workflow to create applications.

Even with the most advanced and easiest to use RAD tools, there are times which the traditional enterprise and the business software development vendors which are having their own implementations and in-house built frameworks are continuously refusing to adopt them.

Most of the misconceptions on the RAD are based on FUD (Fear, Uncertainty

  [Read more...]
Developer Tips using MySQL
+0 Vote Up -0Vote Down

I get ask, by application developers,  “how do you optimize MySQL”.  I do lots of things that don’t really relate to a developer. I analyze the percent of queries are being pulled from cache for instance.  What a developer can do to optimize the SQL they develop is a different questions.   So here is a quick list of things applications developers should know about MySQL.

Explain will analyze your query.

This example shows the possible indexes (keys) that could be used and the index that was selected.  2,262 rows where selected and then sorted (Using file sorts) and one record was returned (limit 1).

mysql> explain SELECT 5/9*(temp_F-32) as t, 5/9*(dewpt_F-32) as td, speed_mps as spd, dir
 > where stn='KLDM' and
  [Read more...]
New Open Query training days in Australia
+0 Vote Up -0Vote Down

The favourite Open Query course modules as well as reworked and brand new ones, with November/December 2009 dates for Brisbane, Sydney, Canberra and Melbourne listed below. You can register for days/modules individually, to suit your time, budget and current needs. Your trainers are Sean, Ray and Arjen (see OQ people).

For the Canberra and Melbourne days which are DBA/HA, registrations for all of the modules in a series before 15 October will receive a copy of the “High Performance MySQL” book (normal bookstore price is AUD 105).

Canberra

  • Thu 5 Nov: MySQL High Availability – Strategy and Tools
  • Fri 6 Nov: MySQL Cluster
  [Read more...]
And the best open source license is …
+0 Vote Up -0Vote Down

UPDATE: The final vote is in and a winner has been declared, with Matt Asay and his arguments for the GPL taking the prize. You can see the debate or follow links to the other judges’ votes and thoughts here.

This is my assessment as a judge of the recent open source license debate held by the FOSS Learning Centre. We’ll have to begin with some qualifications and definitions, starting with the fact that there is no ‘best’ open source software license. Still, a star-studded open source software panel provided a lively, informative debate on the merits of some top open source licenses. For that, I congratulate and thank the panelists, Mike Milinkovich from the Eclipse Foundation arguing for the Eclipse Public License, Matt Asay of Alfresco arguing in favor of the

  [Read more...]
Another Pluggable Storage Engine for MySQL
Employee +0 Vote Up -0Vote Down

Kazuho Oku of Cybozu Labs, Inc., a community contributor to MySQL and SCA signatory, gives a talk on Q4M, a message queue stroage engine for MySQL.

Another Pluggable Storage Engine for MySQL
Employee +0 Vote Up -0Vote Down

Kazuho Oku of Cybozu Labs, Inc., a community contributor to MySQL and SCA signatory, gives a talk on Q4M, a message queue stroage engine for MySQL.

Another Pluggable Storage Engine for MySQL
Employee +0 Vote Up -0Vote Down

Kazuho Oku of Cybozu Labs, Inc., a community contributor to MySQL and SCA signatory, gives a talk on Q4M, a message queue stroage engine for MySQL.

Double Free
Employee +0 Vote Up -0Vote Down

MySQL Workbench has already received some great accolades this year and there is more to come!

Now, those attending the MySQL Users Conference will have a chance to become a MySQL schema design expert.

The Conference (http://www.mysql.com/news-and-events/users-conference/" target="_blank) will include a free MySQL Workbench workshop called “Introduction to Data Modeling with MySQL Workbench” on Thursday (April 23, 2009) 3 - 4:30 PM in the Santa Clara Ballroom.


  [Read more...]
Double Free
Employee +0 Vote Up -0Vote Down

MySQL Workbench has already received some great accolades this year and there is more to come!

Now, those attending the MySQL Users Conference will have a chance to become a MySQL schema design expert.

The Conference (http://www.mysql.com/news-and-events/users-conference/" target="_blank) will include a free MySQL Workbench workshop called “Introduction to Data Modeling with MySQL Workbench” on Thursday (April 23, 2009) 3 - 4:30 PM in the Santa Clara


  [Read more...]
Showing entries 1 to 30 of 37 Next 7 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.