|
|
|
|
|
|
|
|
|
|
| Re: Proper guidance to learn Oracle for a begineer [message #448180 is a reply to message #448179] |
Sat, 20 March 2010 02:44   |
knw15pwr
Messages: 134
Registered: March 2010
|
Senior Member |
|
|
Thanks Michel !
By Guides - i meant the dumps that people use to crack exams and interviews, which is not my intention to learn oracle.
I have no background about database concepts. So I guess this should be my first step.
On a side note, i got the Complete reference for Oracle 9i. Where does this fit in ? Does it have relevant info about database concepts and SQL? Or should i keep it for after the database concepts ?
Thanks,
Ritesh
|
|
|
|
|
|
| Re: Proper guidance to learn Oracle for a begineer [message #448185 is a reply to message #448182] |
Sat, 20 March 2010 06:00 |
John Watson
Messages: 8962
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
For exams, do the latest: 11g release 1. I actually disagree (slightly) with Michel on what version to study: most of what you learn with 11.1 is backward compatible with 10g, but there are some big architectural changes with 11g release 2. So if you start with 11.2 you may have problems back-porting your knowledge to 10g.
McGraw-Hill publishes the Oracle Press exam guides for OCA/OCP, browse to http://amazon.co.uk and search for "Oracle 11g exam" and you'll find them. I think they are good - but then I wrote them, so I would (I'm sure a moderator will remove this reply it is too commercial).
The first book is for the SQL exam, which I wrote with a colleague, Roopesh Ramklass; he included a lot of material on use of functions and aggregation which I find very useful, it certainly goes beyond the exam requirements. The "Admin 1" exam guide is mine, again it goes beyond the exam requirements: I really tried to make sure that the discussions of architecture are complete, not just enough to get through the exams. I can't comment on the third book, for the last exam; it is by someone I don't know. There is also the Oracle Press "All-In-One Exam Guide", which is one huge volume Roopesh and I constructed largely from the three individual books. This is more of an exam cram: everything essential is there, but we had to cut some of the additional material to fit the page budget. None-the-less, I think it is still a good resource for learning to do the job, as well to pass exams. It is cheaper than the separate books.
Sybex has an equivalent set of books, you'll read the reviews and make up your own mind. The impression I've gained is that the Sybex series is more limited: it will teach you to pass the exams, whereas Roopesh and I try to teach you to be a DBA.
I won't say "good luck" - if you study hard, you won't need it.
|
|
|
|
|
|
| Re: Proper guidance to learn Oracle for a begineer [message #448426 is a reply to message #448209] |
Tue, 23 March 2010 05:51 |
knw15pwr
Messages: 134
Registered: March 2010
|
Senior Member |
|
|
@John Watson-
Thanks for your suggestions. No offense. But an exam guide no matter how thourough, remains just that -an exam guide. To 'learn' oracle i would rather have to go into basics and details beyond an exam guide. As I am a rather newcomer to this field, i am not even aware of any basic database concepts.
Quote:If I well understood OP, I don't think he wants materials to run exams but some to well learn Oracle ..
Perfectly understood! and thanks a million for your suggestions Michel.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
I can read and understand what the code does but im no good at writing a good code by myself)
)
