Re: Oracle DBA Certification

<ddf_dba_at_my-deja.com> wrote in message news:8hm91e$fvg$1_at_nnrp1.deja.com...
> In article <8f75ij$tka$1_at_nnrp1.deja.com>,
> Harsh <harshavardhans_at_my-deja.com> wrote:
> > Hi Guys,
> >
> > I am a Programmer Analyst and have over 6 years experience in IT-
> > consulting and over 5 years in Sybase and SQL Server back-end
> > programming (writing SQL's, stored procedures, triggers). I have also
> > worked as a Sybase DBA for couple of years.
> >
> > I have learnt Oracle Ver 5 or 6, 6-7 years back and as the
 web-industry
> > is gearing up towards Oracle as a RDBMS, I want to switch to Oracle
> > again. I want to do Oracle DBA certification.
> >
> > I will really appreciate if anyone suggest me how should I go for it
 in
> > detail. What course material should I refer to; do I have to go for
 any
> > courses again? (I am not so interested in doing so), whether should I
> > install Oracle on my personal PC? If so on what OS (right now I have
> > Win 98) and what version?
> >
> > Thank in advance
> > Regards,
> > Harsh
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
>

Didn't see the original message, but I agree with all the recommended books below.

The only other thing perhaps to mention is that Oracle 7 exams are being discontinued this August, so don't start qualifying in that, or you'll have to take the various 'new features' exams.

I'd agree again with the suggestion below that 8i is the way forward (though being a Microsoft bunny I wouldn't necessarily recommend the Solaris platform, unless that's what you're happy with!). I run 8i on Windows 2000 at home, both server and client, and I haven't had any problems (so far!). Forget Windows 98 for home use: it's time to move into the tripple zero digits!

Other good sources of advice: try Steve Adam's website (allegedly about Performance Tuning, but it has heaps more than that): www.ixora.com.au. You could also do worse than read his "Oracle 8i Internal Services for Waits Latches and Memory" performance tuning book (O'Reilly are the publishers). Slim, but dense, if you're up to it.

Regards
HJR
> Harsh,
>
> I would strongly recommend installing Oracle 8i to provide a hands-on
> environment to learn in. The best OS to install it on is Solaris (in my
> opinion -- I have been an Oracle DBA for over 12 years, Oracle
> Certified, and I have yet to have any problems with Oracle on Solaris,
> and you can get Solaris for the Intel (PC) platform). This is where I
> would start.
>
> I would then purchase a copy of "Oracle 8: The Complete Reference" and
> "Oracle 8: DBA Handbook" from Oracle Press. I would NOT purchase the
> "Oracle 8 DBA Certification Exam Guide" from Oracle Press -- the text is
> a flawed and generally useless waste of paper. I have it, and I have
> been very disappointed in the material. It has not helped me as I
> studied for the exams. I went back to the two texts I listed at the
> start of this paragraph and finally understood the material and passed
> my exams.
>
> Use the two texts and work through the examples in your own database.
> This is the best way to learn and understand Oracle 8. Also use the
> reference materials provided with Oracle 8i to study from, as they will
> provide some additional information on Recovery Manager not covered in
> the two Oracle Press books.
>
> Once you get through all of that material purchase "Oracle 8: Advanced
> Tuning and Administration" from Oracle Press. This will provide insight
> into database fine tuning and also provide practice questions, with
> answers, for the Performance Tuning OCP exam. These questions will also
> be good study material for the rest of the exams as they will indicate
> what types of questions can be asked, and in what form the questions
> will appear.
>
> I realize that this seems like a tremendous amount of material to
> acquire and assimilate, but it is worth it in the end.
>
> Good luck.
>
> David Fitzjarrell
> Oracle Certified DBA
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Jun 09 2000 - 00:00:00 CDT