Book description
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
Table of contents
- Title
- Contents at a Glance
- Contents
- About the Authors
- About the Technical Reviewers
- Introduction
- Chapter 1: Do Not Use
- Chapter 2: Dynamic SQL: Handling the Unknown
-
Chapter 3: PL/SQL and Parallel Processing
- Why Parallel Processing?
- Laws Affecting Parallel Processing
- The Rise of Big Data
- Parallel vs. Distributed Processing
- Parallel Hardware Architectures
- Identify Your Goals
- Candidate Workloads for Parallel Processing
- The MapReduce Programming Model
- Before Looking to PL/SQL
- Processes Available for Parallel Activities
- Using Parallel Execution Servers for MapReduce
- Summary
- Chapter 4: Warnings and Conditional Compilation
- Chapter 5: PL/SQL Unit Testing
- Chapter 6: Bulk SQL Operations
- Chapter 7: Know Your Code
- Chapter 8: Contract-Oriented Programming
- Chapter 9: PL/SQL from SQL
- Chapter 10: Choosing the Right Cursor
- Chapter 11: PL/SQL Programming in the Large
- Chapter 12: Evolutionary Data Modeling
- Chapter 13: Profiling for Performance
- Chapter 14: Coding Conventions and Error Handling
- Chapter 15: Dependencies and Invalidations
- Index
Product information
- Title: Expert PL/SQL Practices for Oracle Developers and DBAs
- Author(s):
- Release date: July 2011
- Publisher(s): Apress
- ISBN: 9781430234852
You might also like
book
Oracle Advanced PL/SQL Developer Professional Guide
Master advanced PL/SQL concepts along with plenty of example questions for 1Z0-146 examination with this book …
book
Oracle PL/SQL for DBAs
PL/SQL, Oracle's powerful procedural language, has been the cornerstone of Oracle application development for nearly 15 …
book
Oracle Database 12c PL/SQL Programming
Master Oracle Database 12 c PL/SQL Application Development Develop, debug, and administer robust database programs. Filled …
book
Oracle PL/SQL Programming: A Developer's Workbook
However excellent they are, most computer books are inherently passive--readers simply take in text without having …