Studying Which Oracle SQL Certification Should You Pursue?

  • Thread starter Thread starter shivajikobardan
  • Start date Start date
Click For Summary
SUMMARY

The discussion centers on the Oracle SQL certification options available for individuals seeking to enhance their SQL skills. Key certifications mentioned include Oracle 1Z0-149 (Oracle Database 19c: Program with PL/SQL), Oracle Database SQL 1Z0-071 (Oracle Database SQL Certified Associate), and Oracle Database 12c: SQL Fundamentals 1Z0-061 (Oracle Database SQL Certified Associate). Participants also noted the importance of practical experience and suggested exploring Microsoft SQL Server and MySQL certifications as alternatives. The conversation emphasizes the value of hands-on projects to solidify SQL knowledge.

PREREQUISITES
  • Understanding of SQL basics and syntax
  • Familiarity with aggregate functions and GROUP BY clauses
  • Knowledge of transactions and concurrency control
  • Experience with procedures, views, and subqueries
NEXT STEPS
  • Research Oracle 1Z0-149: Oracle Database 19c: Program with PL/SQL certification details
  • Explore Oracle Database SQL 1Z0-071: Oracle Database SQL Certified Associate exam preparation materials
  • Investigate Microsoft SQL Server certification paths and their requirements
  • Learn about MySQL certification options and their relevance to database administration
USEFUL FOR

Individuals seeking to advance their SQL skills, database administrators, and anyone considering Oracle SQL certifications or exploring alternative database certifications like Microsoft SQL Server and MySQL.

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.
 
TL;DR: How can I begin to gain an understanding of astronomy? Hello there, and thank you in advance to anyone that might answer this. I'm sorry if this is the wrong place to post a question like this, as I am new to this website and also very nervous about making a post that others might see/reply to. I am a freshman in high school and I am interested in astronomy. I want to learn about space, but I am not quite sure where to begin. Is there anything that I can do to seriously expand my...