Tutorial etc.
Tutorial etc.
You are new to Oracle, so here are my tips:
1. Buy the following books (all available nice-n-cheap from Amazon):
a. Beginning Oracle Programming (Dillon, Beck & Kyte) ISBN 1-861006-90-X
b. Expert Oracle One-On-One (Tom Kyte) ISBN1-861004-82-6
c. Expert Oracle 9i Database Administration (Sam Alapati) ISBN 13-978-1590590225
2. Install Oracle onto your home PC.
3. Set aside an hour a night, and a good few at weekends, and plug away.
4. Make asktom.oracle.com your home page and start the initially daunting, but quite soon not too bad, trawl through ask tom. I suggest clicking at random, to start with (just to get a decent taste of Oracle), or search the site for stuff in the books you don't understand properly.
5. Download the Oracle docs - gigantic, but there are "newbie" DBA guides in there, and a SQL*Plus guide too. Free to download.
6. Go on a Learning Tree course, or two. Pricey, but VERY good. NOTE: Oracle course are, IMHO, a bit poo. Only because the trainer is just that, i.e. a trainer, and not a lot else. Learning Tree employ, basically, contractors who have the ability to teach. LT trainers may spend only 6 weeks training per year for LT (I was told) and must prove "out-in-the-field" experience for the rest of the year. But, LT Oracle training is no use for OCP accreditation - your choice.
7. Not sure what sort of Oracle stuff you are going to be doing, but get clued-up ASAP on backup & recovery using RMAN - the only thing you can be summarily executed for is losing the data! Do it even if you are a Developer - it's staggering how many DBAs don't have the first idea about backing-up, and even more amazing how many don't have a clue about recovery!
Hope that helps.
