 |
Mastering Oracle PL/SQL: Practical Solutions
Customer Reviews: 1 Average Customer Rating:  Write a Review and tell the world about this title! People who purchase this book frequently purchase: - Oracle PL/SQL Best Practices, 2nd Edition; Steven Feuerstein, $18.95, 37% Off!
- Oracle Database 10g PL/SQL Programming; Scott Urman, et al, $33.50, 39% Off!
- Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions; Thomas Kyte, $30.50, 39% Off!
- Oracle PL/SQL Programming, 4th Edition; Steven Feuerstein, et al, $40.50, 38% Off!
Books on similar topics, in best-seller order:Books from the same publisher, in best-seller order:
NEW from the OakTable Press Series from Apress!
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. Have you 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 from Apress.
Mastering Oracle PL/SQL: Practical Solutions 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, security, triggers, dynamic web content presentation from within the database, creation of a DBA toolkit, and 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.
Mastering Oracle PL/SQL: Practical Solutions 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.
In short: if you have mastered the fundamentals of the PL/SQL language, and
are now looking for an in-depth, practical guide to solving real problems with
PL/SQL stored procedures, then this is the book for you. It will demonstrate
how to:
- Design efficient, high performance PL/SQL code
- Implement effective data handling mechanisms
- Streamline your database administration
- Work with Triggers
- Secure your data
- Build effective web applications that run from the database
- Exploit the versatile functionality of Java right in the database
- Debug and optimize PL/SQL
Author Information
Connor McDonald has worked with Oracle since the early nineties, cutting his teeth on Oracle versions 6.0.36 and 7.0.12. Over the past 11 years Connor has worked with systems in Australia, the UK, Southeast Asia, Western Europe, and the U.S.. He has come to realize that although the systems and methodologies around the world are very diverse, there tends to be two common themes in the development of systems running on Oracle -- either to steer away from the Oracle-specific functions, or to use them in a haphazard or less then optimal fashion. It was this observation that led to the creation of a personal hints and tips website, and to do more presenting on the Oracle speaker circuit in an endeavor to improve the perception and usage of PL/SQL in the industry. Like so many other development professionals, getting involved with Oracle was a transition - from developing mainframe/Cobol systems to the "client server revolution". As we now know, this was the "wrong" revolution and of course the Internet is the "right" revolution. And this is no more evident than in the use of PL/SQL, which in Connor’s opinion, has been not so much "used" as "abused" in many of the systems he’s been asked to assist with. Being a developer of client-based code with tools such as Oracle Forms and server-based code has led to his passion for PL/SQL, a passion Connor wants to share in writing this book.
Customer Reviews
Customer Reviews: 1 Average Customer Rating: Feb 8, 2004 Donald K. Burleson from Kittrell, NC, USA
Practical examples
I've had the pleasure of meeting Connor McDonald and I have read many of his published works on Oracle technology.
Connor is very precise and detail-oriented and this comes through in this book. This is not an ideal book for beginners and newbies. Unlike other PL/SQL books that feel compelled to cover the language features soup-to-nuts, Connor focuses on those areas of PL/SQL that are important to the successful programming professional.
Filled with solutions, not theory, this is a pragmatic book that offers real-world tips and techniques for the working PL/SQL professional. Especially delightful are the examples of PL/SQL performance tuning.
Overall, I highly recommend this book for any practicing PL/SQL developer who wants to get the most from their code.
|
|
