Preparing for Java and Spring Boot Interview?

Join my Newsletter, its FREE

Saturday, April 4, 2020

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 the 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 the 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 Best 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 to. 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 like Oracle 12c.

If you want, you can also combine this book with the Learning PL/SQL - Beginner to Advanced The Example way course on Udemy, it's one of the highest-rated course to learn PL/SQL and provides comprehensive coverage of all important PL/SQL concepts.

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 a 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.

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

Best books to learn Oracle PL/SQL Programming

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, PostgreSQL, and IBM databases in the backend.

In fact, every new project comes with a new database and a 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 don't forget to leave a note, I just love good books.

Further Reading
Oracle PL/SQL Fundamentals vol. I & II
Oracle Database 12c Fundamentals By Tim Warner
Learning PL/SQL - Beginner to Advanced The Example way

Other Database and SQL Articles you may like:
  • How to join three tables in a single SQL query? (example)
  • Top 5 Courses to learn Database and SQL for Beginners (courses)
  • 5 Free SQL books for Beginner Programmers (free books)
  • Top 5 Courses to learn MySQL Database for Beginners (Courses)
  • 4 Free Books to learn Microsoft SQL Server database (books)
  • Top 5 Courses to learn Microsoft SQL Server in-depth (courses)
  • Top 5 Websites to learn SQL online for FREE? (websites)
  • Top 5 Courses to learn PostgreSQL in-depth (courses)
  • 5 Free Courses to learn T-SQL and SQL Server for Beginners (Courses)
  • 5 Free Courses to learn Database and SQL (free courses)
  • 5 Advanced SQL books to level up your SQL skills (books)
  • 5 Free Courses to learn Oracle and SQL Server? (courses)
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.

P.S. - If you are interested in learning Database and SQL and looking for some free resources to start your journey, then you can also take a look at this list of Free SQL Courses for Beginners to kick-start your learning.

No comments :

Post a Comment