Monday, February 2, 2009

Few Things To Remember For Oracle Students

Hi all,

In this article i am going to discuss my own experience and what i was taught when i was an oracle student.

Many of us always confuse on 'How to study oracle?', 'How to prepare for oracle online exams?' and lot more question about oracle. Many people on oracle forum ask how oracle can be studied?

Look oracle is a very interesting technology and practical too. If you have joined oracle training program then they will teach you all the theory part, how oracle works, what are the components of oracle and let you practice on their system. But is it sufficient? practicing a topic of oracle one in a day may make you perfect in that topic, but is it sufficient to be a good DBA? answers might vary.

But according to me, along with practicing oracle topic with theory, you should practice previous or old topic as well. This will keep you connected with your total progress. Following are some tips which are discussed by experts like Aman sharma, Pavan kumar, Satish kandi, and many more on oracle forum for oracle beginners. Lets have a look:-

1. As an oracle student you should have enough knowledge about RDBMS and oracle corporation and its product. Its not in your OCP curriculum, but its a good gesture to have knowledge about the company, whose product you are going to use.

2. First of all if you have a system at your home, install oracle database on it and start practicing. If you don't have one, then you have to spend some extra hours at your institute.

3. Try to learn how oracle services start and stop on windows. You should have a bit knowledge about operating system process for this. But best suggestion is try to learn oracle on Linux platform. I heard that all institute are providing training on Linux platform now a days, which is a good thing.

4. Don't hesitate to ask, if you stuck on something. Please remember there is always a senior/expert to ask in IT sector.

5. Oracle has some components which are virtual, so be sure to identify them clearly. You should have very good understanding of oracle instance in order to understand oracle internals.

6. Read a lot of documents as you can. I am very bad at this. But still it is recommended by experts to keep reading. Everything is documented in oracle, you jut have to Google it.

7. Last but not the least, DBA is a very responsible job to do. Do not expect to get job as you complete you certification. Keep practicing on you machine, do what worst can happen to your database and try to recover it. Treat your home PC as a production database and you will find you are getting real world experience.

hope this helps you to be a good oracle student.

5 comments:

  1. Vikrant,
    When I teach Oracle database related modules, biggest thing which I see in the participants, both fresher and experienced is , lack of what is correct and what's not. I remember a discussion with someone who read a note from a website(don't ask me which one) and burnt his hands completely. So one must learn , everything which is over internet, books, articles , does NOT bound to be true!

    2nd point which I agree upon is, habit of asking questions. I always say in my classes, no question is stupid, only the answers are! So always ask. Surely enough, try to learn on your own first, but if you didn't understand something, do ask it.

    Rest, oracle database is a very very complex technology, taking it as easy is actually living in a misconception. But that doesn't mean that one /all should know internals. I am asked this question alot , teach us internals whereas there are lots of external questions whose answers are not clear to many. So I always say, forget internals, learn externals!

    And in the last, remember all the time, always be a student and you will be good. The day you will call your self a master, its the starting of your end!

    Aman....

    ReplyDelete
  2. got it aman sir, but didn't get if the content posted by me is ok or not....

    can you please let me know where i am wrong, so that i can correct all mistakes

    VD

    ReplyDelete
  3. i like your last sentence that 'The day you will call your self a master, its the starting of your end!'' wow that's really nice

    VD

    ReplyDelete
  4. I find this post very useful and informative. This post includes few things to remember for Oracle students. This post surely helps learners of Oracle. I really appreciate your effort. I want you to share some shortcuts and tips also.

    ReplyDelete