• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Tim Cooke
  • Jeanne Boyarsky
  • Paul Clapham
Sheriffs:
  • Devaka Cooray
  • Ron McLeod
  • paul wheaton
Saloon Keepers:
  • Tim Moores
  • Piet Souris
  • Tim Holloway
  • Stephan van Hulst
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Frits Walraven
  • Scott Selikoff

Database certifications

 
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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


 
Ranch Hand
Posts: 85
  • Likes 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

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
Posts: 5
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

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
Posts: 85
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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!
 
Ranch Hand
Posts: 75
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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 https://coderanch.com/t/620411/po/certification/study-Oracle-Certified-Professional-MySQL
 
You don't know me, but I've been looking all over the world for. Thanks to the help from this tiny ad:
the value of filler advertising in 2021
https://coderanch.com/t/730886/filler-advertising
reply
    Bookmark Topic Watch Topic
  • New Topic