THE OAKTABLE IS VERY PROUD TO ANNOUNCE THAT THE FIRST BOOK IN A SERIES OF OAKTABLE PRESS PUBLICATIONS IS NOW ON SALE. MASTERING ORACLE PL/SQL: PRACTICAL SOLUTIONS.

The lead author, Connor McDonald, is a member of the OakTable network and is a well-known personality both on the Oracle speaker circuit and in online Oracle forums. He hosts a hints and tips website (http://www.oracledba.co.uk) to share his passion for Oracle and as part of an endeavor to improve the way in which Oracle software is used within the industry.

If you need more from a PL/SQL book than just the correct keywords and some pretty syntax diagrams, then this is the book for you. If you’ve been searching in vain for real-world examples and genuine strategies for maximizing the benefits of PL/SQL within your organization, you’ll find them in Mastering Oracle PL/SQL: Practical Solutions, the inaugural title of the pioneering OakTable Press series.

Mastering Oracle PL/SQL isn’t a tutorial on how to code PL/SQL. It’s designed to show you how to code PL/SQL well. It will show you how to write code that will run quickly and won’t break in high load, multi-user environments. It covers the vast array of the functionality that PL/SQL provides, including:

Effective handling of relational and abstract data

Use of PL/SQL packages and triggers to implement effective security mechanisms

Dynamic web content presentation from within the database

Creation of a DBA toolkit to automate recurring administrative activities

Effective debugging techniques

This book sets out to redress the unjust criticism leveled at PL/SQL in years gone by. It gives you the tools and techniques to ensure that, whatever your needs are, the PL/SQL you build will run as efficiently as possible. I am confident the practical solutions provided in this book will help you to realize the true power and functionality PL/SQL can offer your projects.

This book is targeted primarily toward the DBA or developer charged with the implementation of effective data handling, security, and database administration mechanisms in the Oracle database. However, it will also have great appeal to any developer whose applications rely on an Oracle database and who needs a sound understanding of how to use PL/SQL effectively.

If you’re brand new to PL/SQL, then you’ll want to take some time to get familiar with the language before tackling this book. It’s not for the total beginner. But once you’re up and running, we believe you’ll find our book an invaluable guide for ensuring that the PL/SQL solutions you build are robust, perform well, and are easy to maintain.

Chapter 1: Efficient PL/SQL

Chapter 2: Package It All Up

Chapter 3: The Vexed Subject of Cursors

Chapter 4: Effective Data Handling

Chapter 5: PL/SQL Optimization Techniques

Chapter 6: Triggers

Chapter 7: DBA Packages

Chapter 8: Security Packages

Chapter 9: Web Packages

Chapter 10: PL/SQL Debugging

Appendix A: Building DEBUG

BUY NOW