OraFAQ Forum: Training & Certification

Home » Other » Training & Certification » Need your guidance (Orace)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Need your guidance [message #581025]

Sun, 31 March 2013 21:39

shumail
Messages: 149
Registered: September 2012
Location: Canada

Senior Member

Hi all

I'm wondering that if someone suggest me about my future career path. I live in Canada, Saskatchewan and have 5 years of background as an Oracle Developer that includes my new job as PL/SQL Developer or you can say this ETL Developer. My job responsibilities over there are:
--Data already loaded in one schema in a raw format and I have to use mapping document created by Business Analyst to load data into target table by using certain condition. I use SQL Developer to create Package, Procedure, function, collection and other stuff.
After loading data, I have to perform some validation check on data and if some data is invalid then invalid data inserted into error table.

My question is that I want to do something more to groom myself and I did some research and because my field is somehow related with ETL or PLSQL so I have a plan to do some certification or training in data ware housing .

In addition, some people are suggesting me that I can do some stuff related to report tools like Cognos or some people suggesting me that go for Data ware housing field . At this moment I'm too confused that What to do and if you people guide me that what is good for me then I really appreciate it. Thanks

Regards

Shumail

Report message to a moderator

Re: Need your guidance [message #581088 is a reply to message #581025]

Mon, 01 April 2013 21:17

matthewmorris68
Messages: 258
Registered: May 2012
Location: Orlando, FL

Senior Member

I gather from your post that you don't currently have *any* Oracle certifications. My suggestion for starting out with them would be to go with what you know. Pursue the PL/SQL certification track. The OCA level certification is one SQL exam and one PL/SQL -- generally 1Z0-051 and 1Z0-144. If you are very skilled with SQL, you might take 1Z0-047 instead. It is a considerably harder exam, but grants a certification for passing it whereas 1Z0-051 does not by itself. Once you have the OCA, you might advance to an OCP certification by taking 1Z0-146.

Preparing for these exams should improve your knowledge of the topics and gaining the certifications will add to your credentials.

Report message to a moderator

Re: Need your guidance [message #581413 is a reply to message #581088]

Fri, 05 April 2013 17:39

shumail
Messages: 149
Registered: September 2012
Location: Canada

Senior Member

Thanks for the reply and will follow your guidelines.

Report message to a moderator

Re: Need your guidance [message #582226 is a reply to message #581413]

Tue, 16 April 2013 02:36

shumail
Messages: 149
Registered: September 2012
Location: Canada

Senior Member

Could you please guide me how to prepare myself for IZO-144. Really appreciate your guidance

Report message to a moderator

Re: Need your guidance [message #582265 is a reply to message #582226]

Tue, 16 April 2013 08:30

matthewmorris68
Messages: 258
Registered: May 2012
Location: Orlando, FL

Senior Member

Go to the Oracle Education certification website. Look up the 1Z0-144 exam and view all of the topics. Use those as the basis for studying for the exam. Read the documentation. Links to the exam topics, documentation, and some articles that may be of use are available here:
http://www.oraclecertificationprep.com/apex/f?p=OCPSG:EXAM_DETAILS:0::NO::P2_EXAM:1Z0-144

I also wrote a generic Tips article about prepping for and taking Oracle certification exams here:
http://www.gocertify.com/articles/oracle-certification-study-tips.html

Report message to a moderator

Re: Need your guidance [message #582289 is a reply to message #582265]

Tue, 16 April 2013 12:24

shumail
Messages: 149
Registered: September 2012
Location: Canada

Senior Member

Great Thanks for your help. I forgot to tell you that I did my OCP DBA track in Oracle 9i 3 or 4 years ago but now I don't know anything about it. I think this OCP track also include SQL exam as well. Thanks

[Updated on: Tue, 16 April 2013 12:28]

Report message to a moderator