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.
 

Thread 'Should I pursue a masters degree after 4.5 years working in IT?'

I graduated with a BSc in Physics in 2020. Since there were limited opportunities in my country (mostly teaching), I decided to improve my programming skills and began working in IT, first as a software engineer and later as a quality assurance engineer, where I’ve now spent about 3 years. While this career path has provided financial stability, I’ve realized that my excitement and passion aren’t really there, unlike what I felt when studying or doing research in physics. Working in IT...
View full post »

Thread 'Considering the change from CMP to AMO'

I have a specialization in condensed matter physics and materials physics, and off-late, I have been seeing a lot of research directions moving towards quantum computing (AMO and non-linear optics) and the huge chunk of quantum materials research (and funding) is dedicated towards QIS and QC research. I am wondering (sort of in a dilemma), if I should consider switching my field? I am currently at the stage of a postdoc.
View full post »

Hot Threads

Recent Insights

Back
Top