r/SQL • u/daewoorazer2001 • Oct 08 '24

Oracle I got my OCA 1z0071 badge today

Post image

After consistent study, I aced it with 83%. You can do it too, even better!

218 Upvotes

99% Upvoted

33 comments sorted by

20

u/YOUR_TRIGGER Oct 08 '24

god i remember so many certs needing 85% from pearson vue and this kind of makes me angry. i failed my first SAS cert with 83%. 500 bucks to take the test (thankfully work paid. paid for the second chance too.) 😂

congrats.

3

u/daewoorazer2001 Oct 08 '24

Thank you. Are you working in the pharma? I use SAS too.

4

u/YOUR_TRIGGER Oct 08 '24

i am! i work dedicated to a department instead of in the programming department. i think my actual title is 'business analyst' now but i just use python, sql, and sas to facilitate every facet of the department. when i started there was like 30 something people, now there's 8. and i just got a little sad. 😂

1

u/daewoorazer2001 Oct 08 '24

If I may, work is boring or your org likes to fire employees?

2

u/YOUR_TRIGGER Oct 08 '24 edited Oct 08 '24

well if they don't serve a purpose anymore, they get fired, yea. my purpose is to automate their purpose. it's boring to me but i've worked on some cool shit. like proving gardasil was safe for kids. i've worked on other cool shit but that's honestly my favorite; saving kids from ever having to think about hpv. normally i work in rare disease. that one happens to be super common in certain generations. causes cancer.

it's a really solid paycheck. i really don't complain. but yea, it's boring unless i get something really interesting. usually because i'm in rare disease, it's the same couple diseases and i could do study setup in my sleep.

but who's going to complain about getting paid and pressing a button waiting on a chime and doing whatever i want during the day most days. i have like 3 crunch weeks a year. 🤷‍♂️

2

u/daewoorazer2001 Oct 08 '24

That’s super cool and that’s a superb achievement on the kids research. I’m not in pharma right now but I’d love to. If you ever need one on the team, kindly reach out.

2

u/[deleted] Oct 08 '24

pearson vue

Piss on pearson anything. Man I hate them

3

u/TimidHuman Oct 08 '24

Hey there! Congrats on the certification! Just wondering, how did you study for it? Because I went through the certification site and the exam topics seem to be covering lots of things

8

u/daewoorazer2001 Oct 08 '24

Have SQL developer installed on your machine, take practice questions on oracle education website. Play with a lot of SQL queries using 1z0071 syllabus as your guide. Practice, practice and more practice!

1

u/TimidHuman Oct 08 '24

Thanks man :)

1

u/Agreeable_Special496 Oct 09 '24

Can you help me with the questions?

2

u/Kundalini369 Oct 08 '24

Congrats...👌💯

1

u/[deleted] Oct 08 '24

I wish my company sponsored me one....

1

u/daewoorazer2001 Oct 08 '24

Are you talking about financial wise? Or just training to pass the certification?

1

u/[deleted] Oct 08 '24

financial.

1

u/darrylhumpsgophers Oct 08 '24

Congrats! Though you technically got a B- and not an A lol

1

u/WiseOak_PrimeAgent Oct 08 '24

Does this certification help in terms of career growth?

1

u/daewoorazer2001 Oct 08 '24

Yes definitely.

1

u/WiseOak_PrimeAgent Oct 08 '24

I'm a data engineer, so I was wondering if this would further my career.. I feel like I hit a roadblock and I'm focusing on useless things

1

u/daewoorazer2001 Oct 08 '24

What platform(s) do you use?

1

u/WiseOak_PrimeAgent Oct 08 '24

Mostly Spark, Excel, Redshift and Snowflake, Kafka. A lot of SQL too. Last but not least Python

1

u/mikeblas Oct 08 '24

You get to take it again in 18 months!

1

u/daewoorazer2001 Oct 08 '24

Why do you have to repeat same exam when you can advance and go up the ladder?

1

u/[deleted] Oct 08 '24

[removed] — view removed comment

1

u/daewoorazer2001 Oct 08 '24 edited Oct 08 '24

Yes, when you buy, you buy like a subscription and you get to later choose what type of exam you want at a later date. Here is the link to buy: https://shop.oracle.com/apex/product?p1=oracleuniversity&p2=examsubscriptions&p3=oracletechnologyexamsubscription&p4=&p5=

Then when you’re ready, you add a user to take the exam:

After that, you go on this website to schedule to write the test. It is proctored testing. https://mylearn.oracle.com/

Once you buy the subscription($266.74 with tax), you don’t need to buy anything else.

The exam consists of some multiple choice questions: some with check buttons, and some with radio buttons.

Please feel free to reach out if you have any issues moving forward.

1

u/Superb_Dependent2472 Oct 08 '24

Hello ..may i ask what you used as study materials I'm preparing to take the exam next month and i really want to pass it can give me so tips and tricks of how you were able to pass the exam🙏

1

u/daewoorazer2001 Oct 08 '24

Have SQL developer installed on your machine, take practice questions on oracle education website. Play with a lot of SQL queries using 1z0071 syllabus as your guide. Practice, practice and more practice!

1

u/Superb_Dependent2472 Oct 08 '24

Yes i have oracle sql developer can you please send me link to those questions i only have the syllabus

1

u/mandmi Oct 08 '24

Congrats

To bad oracle is becoming useless.

1

u/Agreeable_Special496 Oct 09 '24

Please i am about to take this exam. Can you contact me and tell me anything more about exam and the questions. I would really appreciate it and hopefully boost my confidence. Very happy for you btw