Should I Learn Oracle or MySQL?

Should I learn Oracle or MySQL? MySQL is a popular open source database, but Oracle seems like the default database I see in use.

Oracle is more expensive to implement and to train in. The certifications are like Microsoft's examinations, in that the classes and tests cost more.

Then I need to go with MySQL.

Not so fast.

Popular should equal more job opportunities.

MySQL has stronger database authentication based on the person's location. However, Oracle has corporate support to assist you with any problems you have.

Which database do you think is better?

Oracle does have a number of superior database management tools like rman, dataguard, internal job scheduling and queues. Oracle also has a more mature stored procedure language compared to MySQL.

Stored procedures make it a lot easier to add verification logic and corrections to your database, instead of reprogramming the application that relies on the database.

MySQL originally didn't have stored procedures or the rich programming environment Oracle did. However, MySQL is catching up.

I know that a lot of companies like Oracle's hot backups so that restorations are faster in case of database failure, and the Real Application Clusters that lets your users search several servers at once is a good value.

All of that is why Oracle is so often used, especially by big companies.

Where is MySQL used?

MySQL is free to a lot of non-profits and non-commercial groups. So it is popular at small charities and schools.

It sounds like I need to learn Oracle just to gain access to the higher paying jobs, since non-profits don't pay much.

Or you could learn Microsoft SQL.

I'm not that desperate.

Oh, come on. You could manage Microsoft databases on Microsoft Windows servers if you learn Microsoft SQL.

I'd rather work for minimum wage at a non-profit with MySQL than MSSQL.

[Thoringer]

It is literally the same language 99.5% of the time. What you are talking about is hosting, not using Oracle/SQL. If you are a database programmer, sure. If you are an analyst, you learn basically both because there are only very, very few differences between them, and you almost never use those procedures.

We use both types of servers and the only way I would know is that a rarely used part of code won't work when using one or the other. However, I run my queries in a program that only shows what kind it is by really looking it up in the connection.

[michaeljoc]

nice video. I have to point out though that mySql is used by plenty of large for-profit companies - in my experience anyway. 

[vanpride]

what is the problem with Microsoft sql? I wanted to get the joke..

[otto.x]

Yeah lol wtf is wrong with the ending? xD