Reddit mentions of Oracle PL/SQL Programming: Covers Versions Through Oracle Database 12c

False. Oracle is a RDBMS. To query an Oracle DB, you use SQL, just like you do with almost all other RDBMS. Granted, each DB can have its slightly different syntax, but it's generally all the same.

PL/SQL is a object-oriented procedural language for SQL and the Oracle database. This is similar (but much more powerful and feature rich) to SQL Server's T-SQL. It's modeled after the language Ada, which in turn is modeled after Pascal.

Get familiar with the anonymous block and DBMS_OUTPUT.PUT_LINE. Toad is by far your best (although super pricey) IDE for PL/SQL and it's debugger is great.

Make sure to pick up a copy of this book. It's seriously the only book that I've ever seen multiple copies of at every single job I've had. My current job actually calls it "Steve's Book" and it's often referred to as the PL/SQL Bible:

Oracle PL/SQL Programming

I've been a PL/SQL developer for the past 10 years and I would say the best topics you could study up on to prepare are:

1. Exception handling and propagation (also know some of the common Oracle defined exceptions you might encounter such as NO_DATA_FOUND, TOO_MANY_ROWS, etc)
   
2. Cursor Processing (Implicit, Explicit, etc)
   
3. Collections and Records
   
4. Basic structure of PL/SQL code when used in packages vs. stored procedures/functions/triggers
   
5. Know SQL VERY WELL
   
6. Know Oracle's built-in SQL and PL/SQL functions VERY WELL
   
   I would recommend reading the Oracle PL/SQL documentation - lots of good documentation here
   
   Another excellent resource is this book
   
   Best of luck to you!

On Oracle? Best book SQL / PL/SQL book I've ever bought : Excuse the lack of hyperlink, on my phone. http://www.amazon.co.uk/gp/aw/d/1449324452/ref=mp_s_a_1_1?qid=1394853719&sr=1-1&pi=AC_SX110_SY165

Yes you need to find the materials and book the exams yourself.

The materials generally consist of books which you read and practice examples from. If you are curious I can give you some recommendations however none of them are free.

This is a pretty good book for the first exam (half this book) and you can't get away with programming in PL/SQL without reading [this] (http://www.amazon.co.uk/gp/aw/d/1449324452/ref=mp_s_a_1_1?qid=1417646086&sr=8-1&pi=AC_SY200_QL40)