Friday, September 28, 2018

Top 4 Books to learn Oracle PL/SQL Programming - Best, Must Read

In last summer, I had to work on a Java project which was using Oracle database at their backend. The project was a mix of Java code with Oracle PL/SQL stored procedures, where Stored procedures were quite big and complex to read. I had not worked on Oracle for a couple of years and almost forget whatever I knew before. So, to revise, update and re-learn and I looked over some of the books and online courses like The Complete Oracle SQL Certification Course which helped me a lot. In my quest to revise and re-learn Oracle SQL, I also find lots of their used books on Oracle PL/SQL which are both interesting to read as well as provides a great wealth of information to any programmer.

Today, I am going to share those books with you.  As a Java developer, I had worked on a project with no active DBA for the team and you as a programmer have a responsibility to create, update and understand existing PL/SQL stored procedure.

What this means is, you need to know the PL/SQL, if not at expert level but up to an intermediate level to deal with your day to day task while working on a Java project involving Oracle database at backend.

Btw, let me tell you that these books are from an application developer's perspective and not for DBAs. So, if you are a DBA or want to become an Oracle DBA, you better check out courses like Oracle DBA 11g/12c - Database Administration for Junior DBA, which is more DBA focused.

4 Oracle Books to Learn PL/SQL Programming

Without wasting any more time, here is my list of some of the great books to learn Oracle database and PL/SQL programming. I have read most of them, not completely but have referred them every now and then. These are a great resource to learn Oracle 10g, Oracle 11g and even Oracle 12c version of Oracle database.

1. Oracle PL/SQL Programming 6th Edition
This book is written by Steven Feuerstein, one of the most famous names in the world of Oracle PL/SQL programmer and highly regarded as an expert. This book is your complete guide or reference book about Oracle PL/SQL programming.

If you are not understanding a particular code, syntax, or a keyword, this is the book you should refer. The full title of the book is "Oracle PL/SQL Programming: Covers Versions Through Oracle Database 12c 6th Edition", which also means that it covers the latest version of Oracle database i.e. Oracle 12c.

Must read books to learn Oracle PL/SQL Programming

2. Murach's Oracle SQL and PL/SQL for Developers, 2nd Edition 
I love the Murach series, having been previously read their Servlet and JSP book, I know what to expect from a Murach's Oracle book and it didn't disappoint me either.

The Murach's Oracle SQL and PL/SQL for Developers by Joel Murach. If you use Toad to interact Oracle database then you would find this book the little bit different because it uses SQL developer, a free Java-based tool, but since I have used both of them in a different project, it wasn't a problem for me.

Best books to learn Oracle PL/SQL Programming

I highly recommend this book to any new programmer who is starting with SQL but with Oracle database e.g. Oracle 10g or Oracle 11g. It is filled with non-trivial example and quite readable in every sense.

3. Oracle Database 12c PL/SQL Programming 1st Edition
Another good book to learn Oracle database and PL/SQL programming by Michael McLaughlin. It's also one of the most up-to-date books on Oracle PL/SQL programming covering the Oracle 12c database.

Like others, it is also filled with concepts and examples but what I like more about this book is additional information given in the appendix section, which is truly awesome. You can use this book as a textbook to learn Oracle PL/SQL programming.

4 Books to learn Oracle PL/SQL Programming

4. Oracle PL/SQL Best Practices 2nd Edition
This is another gem by Steven Feuerstein, one of the best, must-read book for any experienced or intermediate programmer, who knows how to use Oracle PL/SQL programming language.

This book is filled with lots of advice on how to make most of PL/SQL, how to use things in the right way and best practices acquired by Steven from his years of experience with Oracle PL/SQL programming.

I have a copy of this book and I often look back into it whenever I get some time or whenever I need to know the right way to use any feature of Oracle database.

Advanced books to learn Oracle database

That's all about some of the best books to learn Oracle PL/SQL Programming. As a Java developer, you need to learn a lot of different technologies to become a full stack developer or to perform your day to day task. I had worked in Java project which uses Oracle, SQL Server, MySQL, Sybase and IBM databases in the backend.

In fact, every new project comes with a new database and set of new technologies, so don't think that just learning Java would be enough. If you come across any other Oracle's PL/SQL programming book then doesn't forget to leave a note, I just love good books.

Further Reading
Oracle Database 12c Fundamentals By Tim Warner
Oracle PL/SQL Fundamentals vol. I & II

Thanks for reading this article, If you like these Oracle books and courses then please share with your friends and colleagues, it makes a lot of difference. If you have any good Oracle book to suggest, please leave a comment. 

No comments :

Post a Comment