Ask the Expert

Is Oracle easy to learn?

Is Oracle easy to learn? I am creating an information system using Visual Studio and Microsoft Access. I chose MS Access as it is not based on a command language whereas Oracle is. Also Access has a GUI whereas Oracle does not, correct? I'm a bit unclear.

    Requires Free Membership to View

I would not say that Oracle is easy to learn. I've been involved with Oracle for about 10 years now and I'm constantly learning new things, every day. The basics of Oracle are pretty easy. And the Oracle documentation and the many Oracle books on the market make it easier. The more advanced concepts can take a while to master.

I would never compare MS Access to Oracle either. Oracle is a full-fledged relational database management system (RDBMS). While Access is a relational database, it lacks criteria to make it a RDBMS. For one thing, there is no transaction control in Access. MS Access was designed as a single-user database. I cannot begin to count the number of times I've had to tell someone to restore their MS Access database from a backup because they let two users simultaneously update data and it corrupted the .mdb file. If you want multiple users to access your data, then stay away from MS Access.

Oracle does have a GUI tool, if you are so inclined. It is called SQL Developer and it is available for free from Technet.

This was first published in April 2006

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: