What should a Java developer know about Oracle?

V

Vladimir Kovalenko2015-06-30 12:44:32

Oracle

Vladimir Kovalenko, 2015-06-30 12:44:32

In many descriptions of Senior Java Developer vacancies, knowledge of this DBMS is a necessary item, however, as far as I understand, you can devote your whole life to studying it. Dear community, tell me, please, what, from your point of view, does a Java developer need to know about the Oracle database, working in the enterprise sector?
PS Can anyone recommend courses / lectures / literature?

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

E

Eugene, 2015-06-30
@valdemar593

A certified Java developer had to pass the SQL Fundamentals exam (1Z0 051), which covers 90% of Oracle's SQL implementation features. It has quite specific constructions that are not found in other databases.
It's also nice to know about PL/SQL, why it's needed, what are the pros/cons compared to Java.
Of course, it doesn't hurt to read Oracle Database Concepts. And Tom Kite for extracurricular reading :) We
have already said about the plan and statistics.

E

Eugene, 2015-06-30
@zolt85

Well, at least you need to know how to organize a connection from your application. How to get data. Etc. Specifically about Oracle, it is useful to know what a query plan is, and why statistics are needed.