Studying Which Oracle SQL Certification Should You Pursue?

  • Thread starter Thread starter shivajikobardan
  • Start date Start date
Click For 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 'Uncertainty in pursuing Engineering'

This is my second year in college, and I changed my major to electrical engineering at the start of my second year. I'm taking Calc 1, and I know that I'm going to fail the course. I think there are several reasons for this. I hadn't touched math in an entire year (finished pre-calc 2 in HS), and I heard Calc 1 was the easiest math course, so I decided that taking the class without outside help (tutors or office hours) was enough. I tried really hard and spent hours learning, studying, and...
View full post »