OraFAQ Forum: Training & Certification

Home » Other » Training & Certification » New to ORACLE

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

New to ORACLE [message #606619]

Mon, 27 January 2014 08:47

socajssr
Messages: 2
Registered: January 2014
Location: London

Junior Member

OK I am crossing over to the darkside and want to learn to Administer Oracle.
I have been a MSSQL DBA for just over 7 years and want to be able to administer both.

So here I am, where do I begin. This is from scratch I have no ORACLE software as such or experience.

Where do I start, Books, WEBCASTS, Youtube, VM etc. I'm bookin a course but don't want to be the class dunce.
Some swotting before I get there would be best.

Pointers please.

Thanks.

Jack.

Report message to a moderator

Re: New to ORACLE [message #606620 is a reply to message #606619]

Mon, 27 January 2014 08:52

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.oracle.com/pls/db112/homepage

Bookmark URL above & start Reading The Fine Manuals & start with URL below

http://docs.oracle.com/cd/E11882_01/server.112/e40540/toc.htm

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: New to ORACLE [message #606621 is a reply to message #606619]

Mon, 27 January 2014 08:54

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

socajssr wrote on Mon, 27 January 2014 09:47

OK I am crossing over to the darkside and want to learn to Administer Oracle.

You have that backwards. You are crossing over FROM the darkside.

For 11g, you can start here: http://www.oracle.com/pls/db112/homepage

or go to http://tahiti.oracle.com and pick your version or Oracle.

Of course, you would need to install Oracle to be able to play with it. Learning by books is not going to help at all unless you can implement what you learn.

Register for a free account at http://download.oracle.com

Report message to a moderator

Re: New to ORACLE [message #606629 is a reply to message #606621]

Mon, 27 January 2014 10:50

socajssr
Messages: 2
Registered: January 2014
Location: London

Junior Member

Thanks.

Great starting points. From what I can see there are lots of similarities with MSSQL.

Report message to a moderator

Re: New to ORACLE [message #606631 is a reply to message #606629]

Mon, 27 January 2014 11:20

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

To a large degree, SQL is SQL regardless in which RDBMS it runs.

Report message to a moderator

Re: New to ORACLE [message #606632 is a reply to message #606629]

Mon, 27 January 2014 11:22

John Watson
Messages: 8964
Registered: January 2010
Location: Global Village

Senior Member

socajssr wrote on Mon, 27 January 2014 16:50

Thanks.

Great starting points. From what I can see there are lots of similarities with MSSQL.

You need to careful about assuming that Oracle works the same as SQL Server (and even more careful about saying that they are similar - at least, when you are surrounded by Oracle DBAs Smile

). Some common confusions are:

What SQL Server calls a database, we call a tablespace (more-or-less)
A SQL Server instance is an Oracle Home (I think)
A SQL Server cluster is an IOT (sort of); an Oracle cluster is something very different.
Do NOT create temporary tables; use subqueries instead.
You no longer need to worry about read consistency - Oracle is ALWAYS read consistent.
Do not worry about locking - leave it to Oracle, and it will be minimal.
In particular, in Oracle readers and writers do not block each other.
Oracle has separate structures for redo and undo, not just one transaction log (not since release 5).

I think those are the points that I have had most confusion with when working with ex-SQL Server folks. If you ever feeling like writing an article contrasting the two, please post it here on the blog.

Report message to a moderator

Re: New to ORACLE [message #606637 is a reply to message #606632]

Mon, 27 January 2014 12:11

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>What SQL Server calls a database, we call a tablespace (more-or-less)
What SQL Server calls a database, Oracle calls a schema

Report message to a moderator

Re: New to ORACLE [message #606640 is a reply to message #606619]

Mon, 27 January 2014 13:20

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

Senior Member

There are a number of videos available on YouTube (the quality of which varies considerably, of course).
I've collected links to a number of them as they relate to Oracle admin certification exams:

http://www.oraclecertificationprep.com/apex/f?p=OCPSG:EXAM_DETAILS:0::NO::P2_EXAM:1Z0-052
http://www.oraclecertificationprep.com/apex/f?p=OCPSG:EXAM_DETAILS:0::NO::P2_EXAM:1Z0-051

Report message to a moderator

Previous Topic:	OBIEE Online Training - Register for FREE Workshop
Next Topic:	Oracle BPEL 11g Training in Mumbai

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 11 18:29:25 CST 2025