Oracle 11g & Career related FAQs

Please click on the questions to read the respective answers.

1. I am a Beginner, I am new to Databases. Is it true that I should I start with 10g only? Or can I learn Oracle 11g directly?

There is a common misconception that Oracle 11g is not suitable for beginners or freshers. The truth is anyone can start directly with Oracle 11g. "11g" just indicates an updated version of the software.

Say: A new model of Maruti Swift with is launched to the market with newly added features like: 1. Automatic climate control, 2. Better mileage, 3. More power , 4. New looks, 5. Beige interiors with Leather seats

Case study. Does people say "I will go for the old model and learn how to drive it, then only I could drive the new model?" The  basic mechanism of all models are the same. Anyone can learn to drive the new model. It's the same old car with better looks and added features.

Similarly Oracle 11g is "Oracle 10g with added features". When you learn Oracle 11g you start with the basics only. That means it covers 10g and new features in 11g.

2.People say "Industry still uses Oracle 10g, so learn 10g!". So why should I go for Oracle 11g?


Reason 1: You could stand out of the crowd

Case study: Does anyone say, “I would go for the old version of the car when a new model is released, since everyone is using old model?” I don’t think so. People would think, "let me go for the latest version so that I show could show some difference and stand out of the crowd".

Similarly when you go for 11g you could learn Oracle 10g plus the new features in Oracle 11g and you could stand out of the crowd.

Reason 2: You will get upgraded according to changing trends in the job market.

Software Support: Whenever a new version of Database Software is released Oracle stops support for the old versions. Sooner or later all clients will have to migrate to the newer version. Already 70% companies have migrated. Others will follow suit. Are you keeping yourself updated with the changing trends? If not, you should be worried about your Career.

3. Which career path is better for me? Database developer or Database Administrator?

Well, let no one decide it for you. You could analyze it yourself.

Skill based: Developer field is for those who find coding or programming  interesting. If you haven't done any programming, what about solving aptitude/logical reasoning questions? Do you like to crack them? Well then you can go for developer track.

Market based: Are you a fresher or a beginner with less than 2 years of industry experience? If yes, we recommend Oracle Developer course only. Above 2-3 years you could try out the Admin field. 

4.  Why should I get Oracle Certified? Why dont I just do only the course and enhance my skills?

A person went to Olympics and got a bronze medal on 100mtr race. Another person claims that he is capable of getting Gold in Olympics, he practices daily, but has never appeared for or won any race. If someone wish to recruit one person for a National level competition, whom would you hire? Of course the guy who has proven his ability, right?

Getting certified by Oracle proves your ability to learn Oracle technologies, your effort to acheive the same and the knowledge you have acquired. Your certificate will talk for you during Interviews!

5. Which track is difficuilt to learn or which track is easy? - DBA or Developer

Every one in this world has some kind of talent. If you figure our your right talent nothing will be difficuilt for you. If you like programming, be a developer. If you like installation, configuration and managment of softwares, go for administration field, nothing could stop you!

6. I want to shift my Career path. Which is the right time to do so? And which is the right track.

The earlier the better. The best time is between 2-4 years of experience. Once you reach 5 years experience in one particular technology, it would be difficuilt to shift your career path. But if you just want to shift to a related field, it could work out well too.

For eg: A person who has 5 years experience as PL/SQL developer can easily look out for Options in DataWarehousing or DBA tracks whereas a person with 5+ experience on Java/J2EE may not be able to shift to DB field so easily.

You could book appointments with our Senior Career consultants who could help you out further.

7. I know basics of SQL I can learn more from the internet or the books myself. Why should I go for an SQL course?

 

That’s partially right. SQL is simple and anyone can learn it from books or the Internet.

 

But just one question: If everyone can learn things from books or internet, why do people get paid more based on experience? What does experience mean and how does they differ from others who has learned everything from books or the internet.

 

Case study:

 

Books and internet tutorials can teach you the Concepts and the Syntax. But when it comes to a real-time job, those materials will not help you. Practical experience is something you could never get from books. It could be shared from one person to another.

 

Not convinced? Here is an example. This is for those who know SQL already. Please try the below question.

 

SQL> Insert into Emp values (1100, ‘Smith’,8373,’10-Aug-2012’,10);
---- Insert ran successfully
SQL> Create table dept (deptno number, dname varchar2(50));
---- Table created successfully
SQL> exit

 

Question: You forgot to commit the above insert operation. When you login back will the inserted record be present in the table or not?

 

Answer : Yes, the record will be there even if you didn’t commit.

Reason : Every DDL does an Autocommit. Your insert operation is saved by the Create statement which ran after that.

 

Now do you think any book can provide you such information? Our trainers are real time experts who can share knowledge from their real time experience.