How soon can I become an Oracle Certified Associate as a beginner developer?

Question

Oracle

Hello!
Now I work as a junior programmer. You need to understand oracle
at such a level that you can solve many problems on your own. I know sql for three, but I know oracle itself very poorly.
A little familiar with PL / SQL, but this is purely theoretical knowledge, so to speak. In general , the
answers to the following questions are of interest:
1) Having the above characteristics, how soon can I get the Oracle Certified Associate status?
2) What online book resources would advise me to read?
Sincerely ,
Almik

Answer 1

See Exam Topics tabs
https://education.oracle.com/pls/web_prod-plq-dad/...
https://education.oracle.com/pls/web_prod-plq-dad/... Point by
point:
1 ) See topics that you don't know, divide by your own "learning" and decide how much time you need to learn all this
2) Opinion is subjective, but do not read, but write. Reading books from cover to cover gives dubious results if all this is not put into practice. It is to read - Kite, a classic.
And think about whether you need this certificate? I felt the need for certification only when I was a senior when I moved to another job.

Answer 2

I'll tell you from my experience of obtaining the Oracle Certified Associate
1 certificate. First, decide which version you will go for. Two versions are currently relevant 11g and 12c. With an eye to the future, of course, it is best to go for 12s, since your certificate will be valid for a couple of years longer.
2. The certificate itself is divided into two parts: a) SQL knowledge b) admin panel I think it is advisable to prepare for them separately.
3. SQL knowledge is tested by the following exams: 1z0-051 for the 11g version and 1z0-061 for the 12c version. And also the universal 1z0-047, which is suitable for both versions. I consider the latter to be more preferable, since you get a separate Certificate for it. The best textbook to prepare for these exams SQL Certified Expert Exam Guide by Steve O'hearn Linkeverything you need is there, less "water", more "pitfalls". If it’s a pity to buy, you can easily find a pdf on the Internet and also sample questions are attached to it, I highly recommend it at a rather difficult level.
4. Admin panel has two options only this: 1z0-52 for 11g version and 1z0-062 for 12c version. For the admin account, you can read 12c Oracle Essentials Oracle Database 12c Link . In general, general knowledge will be enough, the most important thing is to remember the theory. If your memory is bad, then take short notes to help you remember better. He gave materials in English because if you decide to study Oracle, it's better to start in English right away.
5. Allocate about 2 weeks for each of the exams, and even better, buy an exam so that the date is already determined and for you it is like a deadline that you cannot miss, a very good motivator. No need to study and read a lot - to no avail, there will only be more "porridge" in the head.
Remember that your goal is to get certified, and knowledge and experience with Oracle will only come with practice. And the knowledge that the certificate requires in real practice, even 50% will not be used.
6. Entrust and not be afraid, in principle, the level of OCA certification is easy even for a beginner in this business.
Good luck!