Oracle SQL certification path?

[shivajikobardan]

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)

 

[Eigenvektor]

You might want to add what your ultimate goal with these certifications is? Unless you want to move into an Oracle DBA career, you're unlikely to need them. Just learn more about SQL.

[shivajikobardan]

The problem is there is very less materials to practice with. That's why I want to go oracle DBA route.

[Akolyte]

38 minutes ago, shivajikobardan said:

The problem is there is very less materials to practice with. That's why I want to go oracle DBA route.

I think they're saying, what's the goal with Oracle certs?  Study a cert because it's something you want to get into, not because there's not much material out there. 

 

Unless you work for a company using MS SQL or Oracle and want you to step into a more database-oriented role, you'll probably never need the certifications, and most employers won't care unless they're looking for someone to maintain existing enterprise systems. 

[shivajikobardan]

what's so tough to understand?

 

I want to practice more sql.

there are no resources to practice sql.

there are lots of resources to practice oracle sql. lots of books and courses.

concepts of one sql are transferrable to another sql generally.

what do you infer from this?

(PS, I'm not preparing for exam, just studying for the exam. I don't think it's worth paying 100s of $s for a certificate)

[Eigenvektor]

6 hours ago, shivajikobardan said:

there are no resources to practice sql.

How about

https://www.w3schools.com/sql/default.asp

https://www.khanacademy.org/computing/computer-programming/sql

 

Alternatively, simple set up a local MariaDB database, create a few tables, fill them with data and start experimenting with SQL statements.

[shivajikobardan]

w3schools is so basic. I finished it at first.

[The Hope]

On 7/1/2023 at 4:32 PM, shivajikobardan said:

If there  are other DBA certification except Oracle, do tell me? 

PostgreSQL 13 Associate Certification

https://www.enterprisedb.com/course/postgresql-13-associate-certification

 

Benchmark databases in Docker: MySQL, PostgreSQL, SQL Server

https://itnext.io/benchmark-databases-in-docker-mysql-postgresql-sql-server-7b129368eed7?gi=0709768709fe

 

The database market is hugely driven by the Big Data adoption and NoSQL is better for this use case.

 

After the Oracle and PostgreSQL certifications, you can go for the following certifications:

 

Redis: https://university.redis.com/certification/

 

mongoDB: https://learn.mongodb.com/pages/certification-program