Monday, September 28, 2009

Oracle Versus MySQL Classes

I'm always being asked what is the difference between Oracle classes and MySQL classes. What are the similarities and what are some of the differences? So I thought I'd jot down a few notes.

Course similarities:
Oracle Classes
MySQL Classes
Oracle Database 11g: Introduction to SQL
MySQL for Beginners
Oracle Database 11g: Introduction for Exp. SQL Users
MySQL for Developers
Oracle Database 11g: SQL Fundamentals II
MySQL Developer Techniques
Oracle Database 11g: PL/SQL Developer
MySQL Stored Procedures Techniques
Oracle Database 11g: Administrator Workshop I
MySQL for DBAs
Oracle Database 11g: Performance Tuning
MySQL Performance Tuning
Oracle Database 11g: RAC Administration
MySQL Cluster

Notes on some differences:
Oracle RAC (MySQL Cluster), PL/SQL (MySQL Stored Procedures), Streams (MySQL HA) have a lot more depth and complexity than MySQL equivalents.
MySQL does not have a class for MySQL Enterprise Monitor (Oracle Grid).
MySQL has PHP class, while Oracle has Java, Fusion Middleware, APEX and Forms developer classes

4 comments:

DBMark said...

Interesting stuff - I used to work a lot with Oracle databases (back in the days of version 8i). There are certain issues that re-occur when migrating data between systems. I think the different ways that different databases cope with dates and sequence fields will be of interest for those migrating data, and of course the "Null" value always needs care.

George Trujillo said...

Very good point. It was a fun exercise for me to get all the Oracle sample scripts and convert them to MySQL scripts.

Anonymous said...

George,

Are your popular mssql presentations for oracle DBA's available for download

Thank you,Sam

George Trujillo said...

Sam,
I haven't made my MySQL presentations available but I need to. I'm debating about delivering a MySQL presentation at Oracle Open World, so I'm going to put something together that I can make available.