Enjoy fast, free delivery, exclusive deals, and award-winning movies & TV shows with Prime
Try Prime and start saving today with fast, free delivery

Paperback
$44.96 - $54.99

FREE Returns

FREE delivery Tuesday, March 26

Select delivery location

In Stock

$$54.99 () Includes selected options. Includes initial monthly payment and selected options. Details

Ships from

Amazon.com

Ships from

Amazon.com

Sold by

Amazon.com

Sold by

Amazon.com

Returns

Eligible for Return, Refund or Replacement within 30 days of receipt

Returns

Eligible for Return, Refund or Replacement within 30 days of receipt

This item can be returned in its original condition for a full refund or replacement within 30 days of receipt.

Read full return policy

Payment

Secure transaction

Payment

Secure transaction

We work hard to protect your security and privacy. Our payment security system encrypts your information during transmission. We don’t share your credit card details with third-party sellers, and we don’t sell your information to others. Learn more

Support

Product support included

Support

Product support included

In the event your product doesn't work as expected or you need help using it, Amazon offers free product support options such as live phone/chat with an Amazon associate, manufacturer contact information, step-by-step troubleshooting guides, and help videos. By solving product issues, we help the planet by extending the life of products. Availability of support options differ by product and country. Learn more

Details

Add a gift receipt for easy returns

FREE delivery March 26 - April 1. Details

Or fastest delivery March 20 - 22. Details

Select delivery location

Used: Very Good | Details

Sold by ThriftBooks-Phoenix

Access codes and supplements are not guaranteed with used items.

Follow the authors

Expert PL/SQL Practices: for Oracle Developers and DBAs 1st ed. Edition

by Michael Rosenblum (Author), Dominic Delmolino Lewis Cunningham

3.7 12 ratings

See all formats and editions

{"desktop_buybox_group_1":[{"displayPrice":"$54.99","priceAmount":54.99,"currencySymbol":"$","integerValue":"54","decimalSeparator":".","fractionalValue":"99","symbolPosition":"left","hasSpace":false,"showFractionalPartIfEmpty":true,"offerListingId":"NKaM3%2BWic19%2FGs0SEuycc4PcYE%2FnNi81TIl8IjsAm%2FglR%2F6pbrHSrI6SjOm7rsHPtSqQH6jJsIWZjrkEweHDhu7Dtj3GfVYqy7PzvbzrqU564a8AFAgSU8BvssSc5i8YVfI9AXO6gIuQ3gskRdJDkQ%3D%3D","locale":"en-US","buyingOptionType":"NEW","aapiBuyingOptionIndex":0}, {"displayPrice":"$44.96","priceAmount":44.96,"currencySymbol":"$","integerValue":"44","decimalSeparator":".","fractionalValue":"96","symbolPosition":"left","hasSpace":false,"showFractionalPartIfEmpty":true,"offerListingId":"NKaM3%2BWic19%2FGs0SEuycc4PcYE%2FnNi81u7z30F%2FO0uiMgRz9UhaTPtB7MPu3zfv5JZ7SyRv1U10SIw56hpaaASN4xQYMWQoYYWBHusYiiKffcsVmpXAEChIPvx9oVZEuq27ejnRzgioycDxLdd9R2B4ipjav6582AhQuaCc6CMDVX1J4OtsPfEpUauZcoMfg","locale":"en-US","buyingOptionType":"USED","aapiBuyingOptionIndex":1}]}

Purchase options and add-ons

Expert PL/SQL Practices is a book of collected wisdom on PL/SQL programming from some of the best and the brightest in the field. Each chapter is a deep-dive into a specific problem, technology, or feature set that you’ll face as a PL/SQL programmer. Each author has chosen their topic out of the strong belief that what they share can make a positive difference in the quality and scalability of code that you write.

The path to mastery begins with syntax and the mechanics of writing statements to make things happen. If you’ve reached that point with PL/SQL, then let the authors of Expert PL/SQL Practices show you how to combine syntax and mechanics with features and techniques to really make the language sing. You’ll learn to do more with less effort, to write code that scales and performs well, and to eliminate and avoid defects.

These authors are passionate about PL/SQL and the power it places at your disposal. They want you to succeed, to know all that PL/SQL can offer. Let Expert PL/SQL Practices open your eyes to the full power of Oracle’s world-class language for the database engine.

Goes beyond the manual to cover good techniques and best practices
Delivers knowledge usually gained only by hard experience
Covers the functionality that distinguishes PL/SQL as a powerful and scalable programming language for deploying logic inside the database engine

ISBN-10

9781430234852
ISBN-13

978-1430234852
Edition

1st ed.
Publisher

Apress
Publication date

July 26, 2011
Language

English
Dimensions

7.01 x 1.16 x 10 inches
Print length

534 pages
See all details

Editorial Reviews

About the Author

Michael Rosenblum is a Software Architect/Development DBA at Dulcian, Inc. where he is responsible for system tuning and application architecture. Michael supports Dulcian developers by writing complex PL/SQL routines and researching new features. He is the co-author of PL/SQL for Dummies (Wiley Press, 2006) and author of a number of database-related articles (IOUG Select Journal, ODTUG Tech Journal). Michael is an Oracle ACE, a frequent presenter at various regional and national Oracle user group conferences (Oracle OpenWorld, ODTUG, IOUG Collaborate, RMOUG, NYOUG, etc), and winner of the ODTUG Kaleidoscope 2009 Best Speaker Award. In his native Ukraine, he received the scholarship of the President of Ukraine, a Master of Science degree in Information Systems, and a diploma with honors from the Kiev National University of Economics.

Product details

ASIN ‏ : ‎ 1430234857
Publisher ‏ : ‎ Apress; 1st ed. edition (July 26, 2011)
Language ‏ : ‎ English
Paperback ‏ : ‎ 534 pages
ISBN-10 ‏ : ‎ 9781430234852
ISBN-13 ‏ : ‎ 978-1430234852
Item Weight ‏ : ‎ 1.93 pounds
Dimensions ‏ : ‎ 7.01 x 1.16 x 10 inches

Best Sellers Rank: #4,289,121 in Books (See Top 100 in Books)
- #730 in Software Programming Compilers
- #874 in SQL
- #1,600 in Database Storage & Design

Customer Reviews:
3.7 12 ratings

Brief content visible, double tap to read full content.

Full content visible, double tap to read brief content.

Videos

Help others learn more about this product by uploading a video!

Upload your video

Important information

To report an issue with this product or seller, click here.

About the authors

Follow authors to get new release updates, plus improved recommendations.

Arup Nanda
Brief content visible, double tap to read full content.
Full content visible, double tap to read brief content.
Arup Nanda has been working exclusively as an Oracle technologist for last 20 years covering everything from performance tuning to disaster recovery. He is the principal database architect for a major New York area multinational company. He has co-authored 5 books on Oracle database, written 500+ articles in many publications including Oracle Magazine and OTN, presented 300+ sessions at conferences like Oracle Open World and IOUG Collaborate, publishes a blog (arup.blogpsot.com), conducts training sessions and builds tools for effective database management. He is an Oracle ACE Director, a member of the Oak Table Network, an editor for SELECT Journal - the publication of IOUG, a member of the Board of Directors of Exadata SIG. He was the recipient of two prestigious awards from Oracle: DBA of the Year award and Enterprise Architect of the Year in 2012. He lives in Danbury, Connecticut, USA.
See more on the author's page
Lewis Cunningham
Brief content visible, double tap to read full content.
Full content visible, double tap to read brief content.
Lewis Cunningham is a native New Orleanian who now lives in Tampa, FL. Lewis started writing as a teen, but didn't choose to publish until fairly recently (which is nowhere near the teen years).
Lewis is a Database Architect/Engineer, Oracle ACE Director Alumnus, Oracle Certified Professional, Oracle 11g Certified Data Warehouse Implementation Specialist, Certified Data Modeler, Certified Cloud Practitioner, and Certified with Airflow. Lewis has over 25 years of database experience, mostly with Oracle, but also with Redshift, Google BigQuery, PostgreSQL, MySQL and others. Lewis has worked in the federal government, higher education, finance, and other industries.
Lewis has authored or co-authored several books, including the very popular, "Expert PL/SQL Practices: For Oracle Developers and DBAs" by Apress. His other books include SQL DML and EnterpriseDB: The Definitive Reference. He's also written a cookbook and a cloud technologies book (which he removed from publication because it was so outdated - written in 2009) Lewis is particularly fond of his middle-grade novella, "Beyond The Fence", which was written with the assistance of his 9-year-old son.
Lewis has also written numerous articles, essays, and white papers on various database topics. He writes the popular Oracle blog, An Expert's Guide to Oracle Technology (http://it.toolbox.com/blogs/oracle-guide/).
When not databasing, Lewis is probably writing fiction, blogging on one of his other blogs or enjoying spending time with his family. To keep up with what Lewis is doing, find him at his author page on facebook, goodreads, or amazon.
See more on the author's page
Michael Rosenblum
Brief content visible, double tap to read full content.
Full content visible, double tap to read brief content.
Michael Rosenblum is a Software Architect/Development DBA at Dulcian, Inc. where he is responsible for system tuning and application architecture. Michael supports Dulcian developers by writing complex PL/SQL routines and researching new features. He is the co-author of PL/SQL for Dummies (Wiley Press, 2006), contributing author of Expert PL/SQL Practices (APress, 2011), and author of a number of database-related articles (IOUG Select Journal, ODTUG Tech Journal) and conference papers. Michael is an Oracle ACE, a frequent presenter at various Oracle user group conferences (Oracle OpenWorld, ODTUG, IOUG Collaborate, RMOUG, NYOUG, etc), and winner of the ODTUG Kaleidoscope 2009 Best Speaker Award. In his native Ukraine, he received the scholarship of the president of Ukraine, a master of science degree in information systems, and a diploma with honors from the Kiev National University of Economics.
See more on the author's page

Customer reviews

3.7 out of 5

12 global ratings

2 star

0%

1 star

21%

How customer reviews and ratings work

Sort reviews by

Top reviews from the United States

There was a problem filtering reviews right now. Please try again later.

David

Five Stars

Reviewed in the United States on March 9, 2015

Verified Purchase

Gift was well received and put to good use.

Helpful

Lauren

Missing chapter12 and onward on my kindle edition!?

Reviewed in the United States on February 14, 2012

Verified Purchase

Hi I do not know why my kindle edition is missing chapter 12,13,14,15.
It is in the table of content but when I go to that seciotn it gives me the cover page of the book only!

One person found this helpful

Helpful

Yan Li

Learning PL/SQL from Experts

Reviewed in the United States on September 16, 2011

I was a little bit puzzled when I got this book: who is the author? There are 15 of them! After reading it, I now believe it is a very good idea to combine knowledge from multiple experts into a single book, especially for a technical book. I would like to see more of these kinds of books coming.

The writers of this book are all very active in the Oracle community, most are authors, Oracle ACE, members of the OakTable network, etc. I actually met a few of them at seminars and user group activities. One of them, Arup Nanda, was once my RAC class instructor, and I've always been impressed by his ability to explain complicated issues in a simple and interesting way. In this book, he discussed dependencies and invalidations with the same clear logic.

The book has 15 chapters, with each author contributing one. Every chapter has a brief summary. Almost all of them go deeply into the topic using very good sample codes, traces, and tkprof output to prove their points.

You may read it as a book focusing on the newest and most powerful PL/SQL features, or you can treat it as 15 top level technical articles - each concentrates on a specific PL/SQL field and digs deeply into it. You'll learn the best practices from their expertise; real experiences and lessons. You can also gain lots of TTTs: Tips, Tricks and Traps to avoid. Many new data dictionary views mentioned by the authors are also very useful.

Based on the needs of my current work, I went through some chapters in close detail, and browsed others for future reference. The book touches the most recent Oracle version, including many new features of 11gR2.

This book is not for beginners. You will need some PL/SQL background to start with. I've been working with PL/SQL since version 6, but in the past few years, I've used more SQL than PL/SQL. By reading this book, I've realized how much more powerful PL/SQL is now than in the past. As new features come, we will have to keep learning. Often difficult tasks can become much easier if you learn the new ways rather than stick with what's familiar.

The order of the chapters does not matter. You can pick up any topic and start reading. Some similar issues are addressed by multiple authors, with each expert offering a different perspective on the problem.

I'd group the chapters into 3 main topics:

PART 1: What To Do And What Not To Do (Chapters 1, 2, 9,10, 12)

These chapters discuss when and when not to use PL/SQL from functional and performance points of view. They also discuss the differences between SQL and PL/SQL engines, the dynamic PL/SQL programming and its pros and cons, the different types of cursors and their usage, etc. Data modeling is not only important at the design stage but is also an evolutionary process.

PART 2: How To Do It Right (Chapters 5,7,8.11,14)

These chapters discuss coding standards and conventions, unit testing, best practices, etc. These are critical factors for successful application development, especially when you have a large group of developers working on a very complex application. Like Chapter 7 says, good developers need to `know your code' and to make your code simple, well organized, well documented, effective and efficient.

PART 3: How to Do More and Better (chapters 3, 4, 6, 13,15)

These chapters discuss more specific topics, including parallel processing, conditional compilations, bulk operations, methods to identify and measure performance issues as well as methods to shorten dependency chains and reducing cascading invalidations.

Chapter 6 is one of my favorate topics. Bulk operation is a very useful but underused feature. This chapter demonstrates the huge performance benefit you can get using bulk processing. The author also provides methods and solutions to find and handle the pitfalls of using bulk processing. The examples are interesting and the results are persuasive.

My coworker saw this book and agreed it is very good. I strongly recommend it to Oracle developers and DBAs.

I received a hard copy of this book. To me the line spacing is rather small for text, but the sample codes look fine.

8 people found this helpful

Helpful

B. Reich

How Everyone Should Be Practicing PL/SQL

Reviewed in the United States on September 3, 2011

The title of this book is Expert PL/SQL Practices. It should be titled "How Everyone Should Be Practicing PL/SQL". This book contains a huge amount of material. All of it describes the ways that everyone should be using PL/SQL.

Chapters of the book are written by different authors. Unfortunately, this is apparent in the style and content of one of my favorite Chapters, Chapter 1. Chapter 1 addresses what all PL/SQL programmers and developers spend most of their time on and where experts agree most performance improvements can be made. The material focuses on accessing database tables, through SQL and PL/SQL, and performing some processing against those tables i.e. row by row processing, loop processing, nested cursors, etc. The author bases his writing on one premise. The premise is that since relational databases are based on set theory, the code to access them should also be based on set theory. For each kind of processing, the author demonstrates how to take advantage of set theory, in PL/SQL programs, to have programs process more quickly. The results are everything the author claims. I did my own test. After making the changes the author recommends, my program ran 16 times faster. This would reduce a five hour run-time down to less than a half hour.

Although Chapter 1 is one of my favorite chapters, I was a little disappointed. The author did not include full scripts of his demonstrations. He only included shell outlines of the scripts. He left the rest up to the reader, which wasn't trivial for me. Since he had the full scripts to do the analysis in the book, I cannot think of one good reason why he wouldn't include them. The scripts have not been made available on the publisher's web site either, as are scripts from other chapters in the book.

Beyond Chapter 1, every chapter in the remainder of the book also contains material that can provide tremendous processing, performance and personal productivity benefits. Some of these require little or no code. For example:

Chapter 6: Bulk SQL Operations discuses manipulating and processing many rows at once, rather than one row at a time. Significant performance benefits are obtained with only minor changes to the code (adding a couple of lines to initiate a bulk fetch).

Chapter 7: Know Your Code is going to permanently change your thinking. Every programmer thinks they know their code but this chapter will show you what you don't know. It will even let you take code you are not familiar with and know the data, variables, runtime efficiency, etc.

And finally, my second favorite chapter, Chapter 5: PL/SQL Unit Testing. This chapter is written by Sue Harper (the same Sue Harper of Sue Harper's Blog). She shows you how to consistently determine whether a program unit performs as expected and continues to perform as expected. She also discusses how to rerun these tests at any time to verify the results or quickly determine any problems and address them.

As you read through this book, chapters will reference other chapters to build relationships, thoughts or principles. I don't know of any other book that takes such a holistic approach, to PL/SQL, as this one does.

This book has helped me tremendously. I think it is a must for every PL/SQL library. I highly recommend Expert PL/SQL Practices.

4 people found this helpful

Helpful

Return this item for free

Image Unavailable

Follow the authors