• FridayNightGiant (10/3/2016)


    ZZartin (10/3/2016)


    Hmm... the interface for oracle is pretty primitive and very similar to mysql, I hope you like command line 🙂 But on the back end in terms of what the database engine is actually doing and the capabilities you have as a dba you'll very quickly realize you're dealing with an actual enterprise application vs. a freeware application. Just look at the differences in how backups/restores are handled between them to get an idea.

    Actually if you use Cloud Control - the latest version of the oracle enterprise manager - then the interface is excellent. You can do pretty much anything without going to the command line.

    Not only that but the newest Version of SQL Developer is quite nifty. I use it alot and even prefer it to some products such as Toad and DBArtisan....and it is free.

    On the other side however, I would recommend learning SQL Server over Oracle. The reasoning here is that more and more companies are making exactly that Switch mainly due to TCO and complexity within the Oracle environment.

    After working with both RDBMSs over the last 15 years I have found the learning curve with SQL Server on Windows to be much easier to master than Oracle on *nix. There are companies and organisations that run Oracle on Windows but that is like playing Tennis with a Badminton racket.....a terrible mix.....