OraFAQ Forum: Training & Certification » Avise for getting Oracle Database11g SQL Admin Cert Association

Home » Other » Training & Certification » Avise for getting Oracle Database11g SQL Admin Cert Association

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

Avise for getting Oracle Database11g SQL Admin Cert Association [message #594364]

Tue, 27 August 2013 22:40

crytal
Messages: 4
Registered: August 2013
Location: singapore

Junior Member

Anyone can advise me. I know nothing about SQL Database and I would like to sit for Oracle Database11g SQL Administration Cert Association. Where should I start from?

Report message to a moderator

Re: Avise for getting Oracle Database11g SQL Admin Cert Association [message #594365 is a reply to message #594364]

Tue, 27 August 2013 23:06

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

> Where should I start from?
Forget about Oracle & start with MS ACCESS or MYSQL; both of them are much less complex & complicated than Oracle.

Report message to a moderator

Re: Avise for getting Oracle Database11g SQL Admin Cert Association [message #594375 is a reply to message #594365]

Wed, 28 August 2013 01:18

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

If possible, find educational center and attend Oracle classes - doing so, you'd get the idea quickly and won't have to spend a lot of time in researching basic stuff.

If you have to do everything by yourself, here's what you might do.

This is Oracle 11g R2 documentation page. Start with the "Concepts" book so that you'd know what Oracle is. Then download and install (following the installation guide) 11g R2 database; along with that, read "2 day DBA" book. Move on to "SQL language reference" so that you'd get familiar with SQL commands. Finally, go on to the "Administrator's Guide".

Once you're done with the above, come back and ask for more. I'm sure someone will point you to the right direction.

Report message to a moderator

Re: Avise for getting Oracle Database11g SQL Admin Cert Association [message #594380 is a reply to message #594375]

Wed, 28 August 2013 01:48

crytal
Messages: 4
Registered: August 2013
Location: singapore

Junior Member

Which one is more relevant to workforce, MS ACCESS or MYSQL or Oracle Database ??

Report message to a moderator

Re: Avise for getting Oracle Database11g SQL Admin Cert Association [message #594428 is a reply to message #594380]

Wed, 28 August 2013 05:52

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

1. Depends on which workforce
2. Depends on your ability. e.g. If Oracle is beyond your ability, then no matter how good the job prospects are, if you're a duffer, then your prospects are poor.

Report message to a moderator

Re: Avise for getting Oracle Database11g SQL Admin Cert Association [message #594447 is a reply to message #594380]

Wed, 28 August 2013 09:42

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

crytal wrote on Tue, 27 August 2013 23:48

Which one is more relevant to workforce, MS ACCESS or MYSQL or Oracle Database ??

I am certain that there is at least tens times more MS ACCESS databases than Oracle databases worldwide,
since anyone with a Windows PC can install & use Access without any outside assistance.

I know that where I work every (60+) salesman , Product Line Manager, "data analyst" has their own Access DB but only 1 Production Oracle DB exists.

Report message to a moderator

Re: Avise for getting Oracle Database11g SQL Admin Cert Association [message #594467 is a reply to message #594380]

Wed, 28 August 2013 19:40

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

Senior Member

Quote:

Which one is more relevant to workforce, MS ACCESS or MYSQL or Oracle Database ??

MS Access is for small, non-mission-critical databases. It does not require a DBA, so you would never find a company advertising for a MS Access database administrator. There are people who work as contractors to develop databases in Access. In fact I did just that... about twenty years ago.

MySQL is a reasonably capable RDBMS -- certainly far more capable than Access. Since it is free and open-source, it has been shipped with Linux distributions for years and is often used as the database of choice for people that cannot or are not willing to pay for Oracle or SQL Server. There are companies that hire MySQL DBAs. However, from my (admittedly unscientific) sampling, there are considerably fewer MySQL DBA positions in my area and they tend to have starting salaries about 70% that of an Oracle DBA and top out well below a Senior Oracle DBA.

Oracle is the market leader for enterprise-class databases. When a company has information and applications on their database that must be functional for their business to function correctly, Oracle is a top choice. The DBAs who administer these database need to be highly skilled and are compensated for their knowledge and experience.

If you are willing to learn how to administer an Oracle database then it is possible for you to make a lucrative career with that knowledge. Many newbies are interested in learning just enough to be able to fake their way through an interview. In that case, you'd be better off learning MySQL.

I wrote an article for Oracle newcomers about starting out from scratch here:
http://ocprep.blogspot.com/2013/07/i-know-nothing-about-oracle-but-i-want.html

Report message to a moderator

Re: Avise for getting Oracle Database11g SQL Admin Cert Association [message #594471 is a reply to message #594467]

Wed, 28 August 2013 20:37

crytal
Messages: 4
Registered: August 2013
Location: singapore

Junior Member

Thanks people for your feedback.

I decided to enroll myself to SQL Expert Certification Discount Package ( including of Fundamental and Admin Association course) at Oracle Uni Spore. However, I found this Oracle Path and to those people who are like me may want take a looks at this website: http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=458&get_params=p_track_id:Datab11g

Report message to a moderator

Re: Avise for getting Oracle Database11g SQL Admin Cert Association [message #594839 is a reply to message #594471]

Tue, 03 September 2013 07:53

oranooob
Messages: 88
Registered: May 2009

Member

do you mean exam 1Z0-047 - Oracle Database SQL Certified Expert? That's too complicated for beginner without real world know-how.

Report message to a moderator

Re: Avise for getting Oracle Database11g SQL Admin Cert Association [message #594843 is a reply to message #594839]

Tue, 03 September 2013 08:08

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

Senior Member

Quote:

do you mean exam 1Z0-047 - Oracle Database SQL Certified Expert?

No -- that's just OU's name for one of their packages: "Oracle Database SQL Expert Certification Discount Package".
It includes a course from OU, a practice exam from Kaplan, and a test voucher with free retake. I'll grant that they picked a misleading name for it...

- Oracle Database: Introduction to SQL
- Certification ePractice Exam: Downloadable Version with 12 month license
- Exam Voucher: Oracle Certification Proctored Exam + Free Retake Exam

Report message to a moderator

Re: Avise for getting Oracle Database11g SQL Admin Cert Association [message #594914 is a reply to message #594843]

Tue, 03 September 2013 22:31

crytal
Messages: 4
Registered: August 2013
Location: singapore

Junior Member

I taking Oracle Database11g Fundamental oz1-051 exam

Report message to a moderator

Previous Topic:	OCP query
Next Topic:	Oracle Financials Online Training at AADS Education

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jan 14 00:37:18 CST 2025