Oracle SQL, PL/SQL

Question

Oracle

In order to successfully pass an interview in a company where I really want to get a job, I need to improve my knowledge of SQL. Specifically, Oracle SQL and PL/SQL.
Recommend literature on this topic. Current knowledge - I can write a simple query. No depth.
Thanks for answers.

Answer 1

I can send you a set of slides from which I myself studied and a starting HR database.
Well, 6 laboratories for them.

Answer 2

According to Oracle, in the first place, it is customary to read Tom Kite. Many of his books have been translated into Russian. There is also such a resource - asktom.oracle.com

Answer 3

In addition to T. Kite, you can also read "Oracle PL / SQL for Professionals" by S. Feuerstein and B. Pribyl.
And if there is a desire then to make a powerful pumping of narrowly thematic Oracle skills, google books from the Oracle Press publishing house. The truth in Russian is not the first freshness, but still.

Answer 4

grabber, sql
you know how to write in pure sql - you will find a job

Answer 5

On SQL, if the level is not quite zero, I can advise Anthony Molinaro "SQL. Collection of recipes" .
Only you need to work with this book seriously, not read on the bus, but take and rewrite the task code, even if it is not clear, and then "play" with the request until you understand the principle of its operation.
Do not wake up to write requests - no reading will help.