Studying Which Oracle SQL Certification Should You Pursue?

  • Thread starter Thread starter shivajikobardan
  • Start date Start date
AI Thread Summary
The discussion centers around Oracle certification exams, specifically the Oracle 1Z0-149, 1Z0-071, and 1Z0-061, as well as other Oracle certifications available for database administration and development. The individual has completed a 20-hour SQL course, taking about 100 hours due to a slow pace, and feels confident with the basics but seeks more practice in areas like aggregate functions, transactions, procedures, and subqueries. They express interest in studying for Oracle certifications without the intention of taking the exams due to financial constraints. Additionally, they inquire about other DBA certifications, noting their work with Microsoft SQL Server and MySQL. The conversation highlights the importance of practical experience and skill expansion over certification alone, suggesting that hands-on projects may be more beneficial than pursuing additional certifications if exam-taking is not a goal.
shivajikobardan
Messages
637
Reaction score
54
1) Oracle 1Z0-149

2) Oracle Database SQL 1Z0-071

3) Oracle Database 12c: SQL Fundamentals 1Z0-061

4) or any other oracle exams? I've no idea about it.

I've finished learning a 20hrs sql course. It took me probably 100hrs to finish the course as I went slow. I'm confident with the basics. But few things I need more practice on(not that I don't know them but still confused). They're:

1) Aggregate functions and GROUP BY.

2) Transactions & concurrency control

3) Procedures, Views

4) Subqueries

I thought the obvious next step would be take some oracle certification (I won't give exams as I don't earn that much, just study for the exam).
If there are other DBA certification except Oracle, do tell me? We use microsoft sql server and mysql at work but I've already learnt enough sql for work. (we just need basic select query at work).
 
Physics news on Phys.org


The Oracle SQL certification path includes the following exams:

1) Oracle 1Z0-149: Oracle Database 19c: Program with PL/SQL
2) Oracle Database SQL 1Z0-071: Oracle Database SQL Certified Associate
3) Oracle Database 12c: SQL Fundamentals 1Z0-061: Oracle Database SQL Certified Associate
4) Any other Oracle exams, such as the Oracle Database 12c Administrator Certified Professional or the Oracle Database 12c Performance Management and Tuning Certified Expert exams.

In addition to these exams, there are also Oracle certification paths for Database Administration, Database Development, and Business Intelligence.

If you are looking for other DBA certifications, there are also Microsoft SQL Server certifications and MySQL certifications available. However, if you are already confident with the basics of SQL and do not plan on taking the exams, it may be more beneficial for you to focus on gaining practical experience and expanding your skills through hands-on projects and real-world scenarios.
 
guys i am currently studying in computer science engineering [1st yr]. i was intrested in physics when i was in high school. due to some circumstances i chose computer science engineering degree. so i want to incoporate computer science engineering with physics and i came across computational physics. i am intrested studying it but i dont know where to start. can you guys reccomend me some yt channels or some free courses or some other way to learn the computational physics.
I'm going to make this one quick since I have little time. Background: Throughout my life I have always done good in Math. I almost always received 90%+, and received easily upwards of 95% when I took normal-level HS Math courses. When I took Grade 9 "De-Streamed" Math (All students must take "De-Streamed" in Canada), I initially had 98% until I got very sick and my mark had dropped to 95%. The Physics teachers and Math teachers talked about me as if I were some sort of genius. Then, an...
Bit Britain-specific but I was wondering, what's the best path to take for A-Levels out of the following (I know Y10 seems a bit early to be thinking about A-levels, but my choice will impact what I do this year/ in y11) I (almost) definitely want to do physics at University - so keep that in mind... The subjects that I'm almost definitely going to take are Maths, Further Maths and Physics, and I'm taking a fast track programme which means that I'll be taking AS computer science at the end...
Back
Top