wood burning stoves 2.0*
The moose likes Programmer Certification (SCJP/OCPJP) and the fly likes Database certifications Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Certification » Programmer Certification (SCJP/OCPJP)
Bookmark "Database certifications" Watch "Database certifications" New topic
Author

Database certifications

Amol Kshirsagar
Greenhorn

Joined: May 07, 2009
Posts: 5
Hi,

I am a Java Developer certified in SCWCD 1.5 and SCJP 1.5.....I want to increase my knowledge on the database side. Is there any RDBMS certification which is independent of the Database type eg Oracle,DB2,MS SQL Server.......as in which covers the core concepts of RDBMS?

Please let me know.

Thanks


Steven Squeers
Ranch Hand

Joined: Aug 19, 2013
Posts: 62
Amol Kshirsagar wrote:Hi,

I am a Java Developer certified in SCWCD 1.5 and SCJP 1.5.....I want to increase my knowledge on the database side. Is there any RDBMS certification which is independent of the Database type eg Oracle,DB2,MS SQL Server.......as in which covers the core concepts of RDBMS?

Please let me know.

Thanks




Ha, we're coming in separate directions

There are loads of Oracle certifications, and presumably loads of MS and DB2 ones also. What's most important is that you bone up on your SQL, a large part of which has been standardised, but there are of course still large differences.
Really you need that core SQL knowledge and ability first, and then you unfortunately need to choose a vendor: MS, Oracle, DB2, MySQL, whatever.
The different vendors sit differently of course in the market place and it depends on what kind of work, what kind of organization, you expect to work with. Oracle is $$$$ so tends to be very large companies. Perhaps less work but more $$. MS is much cheaper. But presumably you'd need to get into C# etc to enable you to marry dev and data.

Myself I'm an Oracle guy and have passed their SQL Expert, PL/SQL and advanced PL/SQL exams this year, and am taking JCP to marry the two together. Those Oracle exams are 1z0-051, 1z0-144 and 1z0-147. Eg see http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=458&get_params=p_track_id:PLSQL

Remember, SQL is the most important; after that you're into using eg T-SQL (MS) or PL/SQL (Oracle) etc.
Amol Kshirsagar
Greenhorn

Joined: May 07, 2009
Posts: 5
Steven Squeers wrote:
Amol Kshirsagar wrote:Hi,

I am a Java Developer certified in SCWCD 1.5 and SCJP 1.5.....I want to increase my knowledge on the database side. Is there any RDBMS certification which is independent of the Database type eg Oracle,DB2,MS SQL Server.......as in which covers the core concepts of RDBMS?

Please let me know.

Thanks




Ha, we're coming in separate directions

There are loads of Oracle certifications, and presumably loads of MS and DB2 ones also. What's most important is that you bone up on your SQL, a large part of which has been standardised, but there are of course still large differences.
Really you need that core SQL knowledge and ability first, and then you unfortunately need to choose a vendor: MS, Oracle, DB2, MySQL, whatever.
The different vendors sit differently of course in the market place and it depends on what kind of work, what kind of organization, you expect to work with. Oracle is $$$$ so tends to be very large companies. Perhaps less work but more $$. MS is much cheaper. But presumably you'd need to get into C# etc to enable you to marry dev and data.

Myself I'm an Oracle guy and have passed their SQL Expert, PL/SQL and advanced PL/SQL exams this year, and am taking JCP to marry the two together. Those Oracle exams are 1z0-051, 1z0-144 and 1z0-147. Eg see http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=458&get_params=p_track_id:PLSQL

Remember, SQL is the most important; after that you're into using eg T-SQL (MS) or PL/SQL (Oracle) etc.



Hi Steven ,

Thanks for your reply. This will really help me to move ahead in the right direction

Thanks,
Amol Kshirsagar
Steven Squeers
Ranch Hand

Joined: Aug 19, 2013
Posts: 62
No problem. I think what you're doing is good: I was once told by a project manager that many Java developers haven't got a clue when it comes to the database side of things. Good luck!
Stefan Feldmann
Ranch Hand

Joined: Nov 07, 2013
Posts: 38
did you already pass SQL exam? There is no vendor neutral exam.

I recommend you:


Exam Number: 1Z0-047
Associated Certifications: Oracle Database SQL Certified Expert


If you prefer smaller database (most popular world wide):


Exam Number: 1Z0-882
Associated Certifications: Oracle Certified Professional, MySQL 5.6 Developer


warning: for MySQL 5.6 exam there is no study guide available. See this thread http://www.coderanch.com/t/620411/po/certification/study-Oracle-Certified-Professional-MySQL
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Database certifications
 
Similar Threads
HF-SQL - Database types
Hi friends Suggest me good certification for RDBMS
what are the other databases
which one ???????????
need to use while(true)