Expert PL/SQL Practices: for Oracle Developers and DBAs

Expert PL/SQL Practices: for Oracle Developers and DBAs

Expert PL/SQL Practices: for Oracle Developers and DBAs

Expert PL/SQL Practices: for Oracle Developers and DBAs

Paperback(1st ed.)

$54.99 
  • SHIP THIS ITEM
    Qualifies for Free Shipping
  • PICK UP IN STORE
    Check Availability at Nearby Stores

Related collections and offers


Overview

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

Product Details

ISBN-13: 9781430234852
Publisher: Apress
Publication date: 07/26/2011
Edition description: 1st ed.
Pages: 512
Product dimensions: 7.40(w) x 9.20(h) x 1.30(d)

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.

Table of Contents

• Do Not Use
• Dynamic SQL: Handling the Unknown
• PL/SQL and Parallel Processing
• Warnings and Conditional Compilation
• PL/SQL Unit Testing
• Bulk SQL Operations
• Know Your Code
• Contract-Oriented Programming
• PL/SQL from SQL
• Choosing the Right Cursor
• PL/SQL Programming in the Large
• Evolutionary Data Modeling
• Profiling for Performance
• Coding Conventions and Error Handling
• Dependencies and Invalidations
From the B&N Reads Blog

Customer Reviews