3677606 wrote:

 

Hello There Community,
One year a go I prepared my 1z0-061 exam and I succesfully approved it.

Just an FYI, Oracle has an approved exam that you can take but what you meant to say is you successfully PASSED it.

3677606 wrote:

 

Hello There Community,

Nowadays, I want to achieve the Oracle SQL Certified Associate with the exam 1z-071, who has more topics than 1z-061. So, the thing is that i bought particulars books for my exam preparation. I wanna know if u guys have read one of this and what is your opinion about them. Also, if you have any recomendation about another book who helped you to approved the exam and know more about SQL, let me know what it is to check it on internet. Thank u!

 

The books are:

 

1) Oracle 12c: SQL: Joan Casteel

2) Oracle Database 12c SQL: Jason Price

3) OCA Oracle Database SQL Exam Guide (Exam 1Z0-071) (Oracle Press) : Steve O'Hearn.

With that said, I highly recommend #3 as I took and passed Exam 1Z0-047 to achieve the no longer available, and retired certification of OCE-SQL (Oracle Certified Expert - SQL).

I too studied from Steve O'Hearn's book --> https://www.amazon.com/Oracle-Database-Expert-Exam-Guide/dp/B008F18VRA

I never heard of the other two authors but I do like the Oracle Press books.

Also I highly recommend going to an "unofficial" but legitimate, from Oracle's point of view, 3rd party author - Matthew Morris Matthew Morris.  He writes Study Guides, and practice exams and also contributes to this Certification forum.  His website is --> Oracle Certification Prep and he does have a guide for the OCA-SQL exam (Exam 1Z0-071)

https://www.amazon.com/gp/product/194140409X/ref=as_li_tf_tl?ie=UTF8&camp=1789&creative=9325&creativeASIN=194140409X&lin…

Also he has plenty of source material to study from here --> Oracle Certification Prep: Exam details and preparation resources for 1Z0-071

I highly recommend his website to study from as I did when I took and passed my OCA-PL/SQL exam.

See my review here --> Exam 1Z0-144 (11g Program with PL/SQL) - My Review

And finally...........study on the parts that will be tested on the exam within SQL by....

READING the DOCUMENTATION --> https://docs.oracle.com/database/121/SQLRF/toc.htm

And general info on Oracle SQL --> https://www.oracle.com/database/technologies/appdev/sql.html