• Complain

John Beresniewicz - Expert PL SQL Practices: For Oracle Developers and Dbas

Here you can read online John Beresniewicz - Expert PL SQL Practices: For Oracle Developers and Dbas full text of the book (entire story) in english for free. Download pdf and epub, get meaning, cover and reviews about this ebook. year: 2011, publisher: Apress, genre: Computer. Description of the work, (preface) as well as reviews are available. Best literature library LitArk.com created for fans of good reading and offers a wide selection of genres:

Romance novel Science fiction Adventure Detective Science History Home and family Prose Art Politics Computer Non-fiction Religion Business Children Humor

Choose a favorite category and find really read worthwhile books. Enjoy immersion in the world of imagination, feel the emotions of the characters or learn something new for yourself, make an fascinating discovery.

John Beresniewicz Expert PL SQL Practices: For Oracle Developers and Dbas
  • Book:
    Expert PL SQL Practices: For Oracle Developers and Dbas
  • Author:
  • Publisher:
    Apress
  • Genre:
  • Year:
    2011
  • Rating:
    4 / 5
  • Favourites:
    Add to favourites
  • Your mark:
    • 80
    • 1
    • 2
    • 3
    • 4
    • 5

Expert PL SQL Practices: For Oracle Developers and Dbas: summary, description and annotation

We offer to read an annotation, description, summary or preface (depends on what the author of the book "Expert PL SQL Practices: For Oracle Developers and Dbas" wrote himself). If you haven't found the necessary information about the book — write in the comments, we will try to find it.

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 youll 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 youve 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. Youll 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 Oracles 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 What youll learn Learn when PL/SQL is best used, and when to avoid it Move data efficiently using bulk SQL operations Write code that scales through pipelining, parallelism, and profiling Choose the right PL/SQL cursor type for any given application Reduce coding errors through sound development practices such as unit-testing Create and execute SQL and PL/SQL dynamically at runtime Who this book is for Expert PL/SQL Practices is for PL/SQL developers who want to develop deep expertise in key aspects of the language and its use in database programming. Any developer writing code against Oracles class-leading database engine will find value from the collected wisdom in this book. Some knowledge of PL/SQL is assumed. Readers should at least be past the beginning stage with the language. 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

John Beresniewicz: author's other books


Who wrote Expert PL SQL Practices: For Oracle Developers and Dbas? Find out the surname, the name of the author of the book and a list of all author's works by series.

Expert PL SQL Practices: For Oracle Developers and Dbas — read online for free the complete book (whole text) full work

Below is the text of the book, divided by pages. System saving the place of the last page read, allows you to conveniently read the book "Expert PL SQL Practices: For Oracle Developers and Dbas" online for free, without having to search again every time where you left off. Put a bookmark, and you can go to the page where you finished reading at any time.

Light

Font size:

Reset

Interval:

Bookmark:

Make
Expert PLSQL Practices for Oracle Developers and DBAs Copyright 2011 by John - photo 1

Expert PL/SQL Practices: for Oracle Developers and DBAs

Copyright 2011 by John Beresniewicz, Adrian Billington, Martin Bchi, Melanie Caffrey, Ron Crisco, Lewis Cunningham, Dominic Delmolino, Sue Harper, Torben Holm, Connor McDonald, Arup Nanda, Stephan Petit, Michael Rosenblum, Robyn Sands, Riyaj Shamsudeen

All rights reserved. No part of this work may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying, recording, or by any information storage or retrieval system, without the prior written permission of the copyright owner and the publisher.

ISBN-13 (pbk): 978-1-4302-3485-2

ISBN-13 (electronic): 978-1-4302-3486-9

Trademarked names, logos, and images may appear in this book. Rather than use a trademark symbol with every occurrence of a trademarked name, logo, or image we use the names, logos, and images only in an editorial fashion and to the benefit of the trademark owner, with no intention of infringement of the trademark.

The use in this publication of trade names, trademarks, service marks, and similar terms, even if they are not identified as such, is not to be taken as an expression of opinion as to whether or not they are subject to proprietary rights.

President and Publisher: Paul Manning
Lead Editor: Jonathan Gennick
Technical Reviewers: Chris Beck, Mike Gangler, Toon Koppelaars
Editorial Board: Steve Anglin, Mark Beckner, Ewan Buckingham, Gary Cornell,
Jonathan Gennick, Jonathan Hassell, Michelle Lowman, James Markham,
Matthew Moodie, Jeff Olson, Jeffrey Pepper, Frank Pohlmann, Douglas
Pundick, Ben Renow-Clarke, Dominic Shakeshaft, Matt Wade, Tom Welsh
Coordinating Editor: Corbin Collins
Copy Editor: Mary Behr
Production Support: Patrick Cunningham
Indexer: name?
Artist: name?
Cover Designer: Anna Ishchenko

Distributed to the book trade worldwide by Springer Science+Business Media, LLC., 233 Spring Street, 6th Floor, New York, NY 10013. Phone 1-800-SPRINGER, fax (201) 348-4505, e-mail
orders-ny@springer-sbm.com, or visit www.springeronline.com.

For information on translations, please e-mail rights@apress.com, or visit www.apress.com.

Apress and friends of ED books may be purchased in bulk for academic, corporate, or promotional use. eBook versions and licenses are also available for most titles. For more information, reference our Special Bulk SaleseBook Licensing web page at www.apress.com/bulk-sales.

The information in this book is distributed on an as is basis, without warranty. Although every precaution has been taken in the preparation of this work, neither the author(s) nor Apress shall have any liability to any person or entity with respect to any loss or damage caused or alleged to be caused directly or indirectly by the information contained in this work.

The source code for this book is available to readers at www.apress.com. You will need to answer questions pertaining to this book in order to successfully download the code.

Contents at a Glance

Picture 2

Picture 3

Picture 4

Picture 5

Picture 6

Picture 7

Picture 8

Picture 9

Picture 10

Picture 11

Picture 12

Picture 13

Picture 14

Picture 15

Picture 16

Picture 17

Contents

Picture 18

Picture 19

Picture 20

Picture 21

Picture 22

Picture 23

Picture 24

Picture 25

Picture 26

Picture 27

Picture 28

Picture 29

Picture 30

Picture 31

Picture 32

Picture 33

About the Authors

Picture 34John Beresniewicz is a consulting member of the technical staff at Oracle headquarters in Redwood Shores, CA. He joined Oracle in 2002 to work on Enterprise Manager in the database performance area and has played significant role in the design of Diagnostic and Tuning packs, Real Application Testing, Support Workbench, and Exadata. He has been a frequent speaker on database performance and PL/SQL programming over many years at Oracle Openworld and other conferences. He is co-author of Oracle Built-in Packages (O'Reilly & Associates, 1998) with Steven Feuerstein and is a founding member of the OakTable network.

Picture 35Adrian Billington is a consultant in application design, development, and performance tuning who has been working with Oracle databases since 1999. He is the man behind www.oracle-developer.net, a web site full of SQL and PL/SQL features, utilities, and techniques for Oracle developers. Adrian is also an Oracle ACE and a member of the OakTable Network. He lives in the UK with his wife Anji and three children Georgia, Oliver, and Isabella.

Picture 36Martin Bchi has worked since 2004 as Lead Software Architect for Avaloq, a provider of a standardized banking software built on the Oracle RDBMS with 11 million lines of PL/SQL code. Together with two colleagues he defines the system architecture and reviews the designs and code of 170 full-time PL/SQL developers, looking for simplicity, efficiency, and robustness. Martin regularly speaks at Oracle conferences. In 2009 he was named PL/SQL Developer of the Year by

Next page
Light

Font size:

Reset

Interval:

Bookmark:

Make

Similar books «Expert PL SQL Practices: For Oracle Developers and Dbas»

Look at similar books to Expert PL SQL Practices: For Oracle Developers and Dbas. We have selected literature similar in name and meaning in the hope of providing readers with more options to find new, interesting, not yet read works.


Reviews about «Expert PL SQL Practices: For Oracle Developers and Dbas»

Discussion, reviews of the book Expert PL SQL Practices: For Oracle Developers and Dbas and just readers' own opinions. Leave your comments, write what you think about the work, its meaning or the main characters. Specify what exactly you liked and what you didn't like, and why you think so.