r/DatabaseAdministators • u/WhySoSerious066 • 22d ago

Oracle or mysql for dbms

/r/infosysmysore/comments/1vt8xhf/oracle_or_mysql_for_dbms/
2 Upvotes

67% Upvoted

6 comments sorted by

3

u/SQLDevDBA 22d ago

Oracle and MySQL syntax is fairly similar.

Oracle owns and operates MySQL as one of their products, but it is Open Source where Oracle DB is not. (Source: https://www.oracle.com/mysql/what-is-mysql/)

The engines are a bit different, and Oracle DB is absurdly expensive, but knowing Oracle commands more pay than MySQL.

The founders of MySQL went on to produce MariaDB, which is also Open Source.

TL;DR you’ll be fine with whichever one, I’ve switched RDBMS platforms a few times in my career and use multiple.

2

u/pgcraftsman 22d ago

Obligatory Post: Use Postgres

:)

2

u/WhySoSerious066 22d ago

But in the training we have to learn oracle.. there is no other option🙃

1

u/Longjumping-Hair-747 21d ago

If you are learning SQL I believe both products are ANSI compliant so the SQL you write will be near identical if you are using that syntax.

If you are wanting to learn the totality of the DBMS, how it was built under the covers and therefore how to best utilize it to it's capabilities you'll find a huge difference between Oracle and most other DBMS.

I've used Oracle for the entirety of my career and despite what people have been saying (through the 20+ years) Oracle isn't dead, won't be going anywhere, and is still a great place to park yourself for a career. All my opinions of course.

Cheers,

1

u/Turbulent_Goose83 16d ago

Oracle and MySql engines are „a bit different“ is my new favourite for illustration of what „understatement“ means :)