Beginning PL/SQL: From Novice to Professional (Beginning from Novice to Professional)

Beginning PL/SQL: From Novice to Professional (Beginning from Novice to Professional)
by Donald Bales

Beginning PL/SQL: From Novice to Professional (Beginning from Novice to Professional)
List Price: $44.99
Our Price: $24.42
You Save: $20.57 (46%)
Availability: Usually ships in 1-2 business days
Category: Book
See more book details and other editions


(Click here)
Buy this book at online book store in your country
Canada | UK | Germany | France

Book Summary Information

Author: Donald Bales
Edition: Paperback
Audio: English (Original Language); English (Unknown); English (Published)
Published: 2007-08-24
ISBN: 1590598822
Number of pages: 476
Publisher: Apress

Book Reviews of Beginning PL/SQL: From Novice to Professional (Beginning from Novice to Professional)

Book Review: A deep, thorough and quite enjoyable book on PL/SQL...
Summary: 5 Stars

As an Oracle developer for over 10 years, I have read many Oracle books on a variety of topics, and this book is definitely one of those that stands heads above the others. As the title suggests, Beginning PL/SQL: From Novice to Professional covers a range of PL/SQL topics, both foundational and advanced. From the fundamentals such as triggers, procedures, packages, the book moves into the more advanced operations of Bulk Collection, Objects and even one of the more neglected but no less important areas in PL/SQL, unit testing. The topics in this book are delivered to the reader from a professional point of view in that all examples of the PL/SQL in the book are approached and designed as quality, production ready code. Topics such as design patterns, best practices and even some of the more insidious Oracle "gotchas" are discussed in this book, making it a wealth of information available to both the new as well as seasoned developer looking to update their PL/SQL knowledge. As a final bonus, this book packs all of this pertinent information in an refreshingly compact size with a breezy, fresh writing style. As one who has many a weighty computer tome where maybe 50% of the book has pertinent information and the rest is fluff, finding books where the fluff is removed are books to be treasured. If you are a PL/SQL developer of any level, beginner or veteran, this book is definitely one that should be turned to for information.

Summary of Beginning PL/SQL: From Novice to Professional (Beginning from Novice to Professional)

Get started with PL/SQL, the built-in language that every Oracle developer and database administrator must know, in Beginning PL/SQL, a fast-paced and example-filled tutorial. Learn from author Don Bales extensive experience to discover the most commonly used aspects of PL/SQL without wasting time with obscure and obsolete features.

Author Don Bales takes his 20+ years of experience and a wealth of statistics he's gathered on PL/SQL usage over those years and applies the 80/20 rule &emdash; cover whats most needed and used by PL/SQL professionals and avoid whats not necessary! The result is a book that covers all the key features of PL/SQL without wasting your time discussing esoteric and obsolete parts of the language. Learn what really matters, so that you can get to work feeling confident with what you know about PL/SQL.

  • Discover the 20% of PL/SQL that gives you 80% of the bangkey topics covered include variables and datatypes, executing statements, working with cursors, real-world objects, debugging, testing, and more.
  • Learn how to write production-level, object-oriented PL/SQLyoull explore relational PL/SQL, but unlike most other books on the subject, Don Bales emphasizes the use of PL/SQLs object-oriented features as well.
  • Work through real examples of using of PL/SQLyoull learn PL/SQL by applying it to real-world business problems, not by heavy theory.

What youll learn

  • How important SQL is in PL/SQL
  • How to use PL/SQL in both a relational and object-relational setting
  • How to create maintainable, modular, and reusable PL/SQL program units
  • The importance of testing as you go, and of building a permanent test plan for each module
  • The importance of building debugging capabilities into your code and building a permanent debug facility for each module
  • The importance of documenting as you go, and in the process building a permanent documentation set for your reusable modules
  • How to apply modular PL/SQL to solve real-world problems

Who is this book for?

Anyone who wants to learn how to create stored procedures against an Oracle database using PL/SQL. Programmers developing applications to be deployed against an Oracle database will need PL/SQL to take full advantage of the power Oracle has to offer. Database administrators who wish to implement functionality exposed only via PL/SQL package interfaces will also find this book useful.

About the Apress Beginning Series

The Beginning series from Apress is the right choice to get the information you need to land that crucial entry-level job. These books will teach you a standard and important technology from the ground up because they are explicitly designed to take you from "novice to professional." Youll start your journey by seeing what you need to knowbut without needless theory and filler. Youll build your skill set by learning how to put together real-world projects step by step. So whether your goal is your next career challenge or a new learning opportunity, the Beginning series from Apress will take you thereit is your trusted guide through unfamiliar territory!

General Books

Book Subjects
Most talked about in General Books
Beginning PHP and MySQL: From Novice to Professional, Third Edition (Beginning from Novice to Professional) ImageBeginning PHP and MySQL: From Novice to Professional, Third Edition (Beginning from Novice to Professional)
by W. Jason Gilmore
Apress; Published: 2008-03-24; Paperback; Book
Best price: $25.83
Price in other shops: $46.99
Mastering Regular Expressions ImageMastering Regular Expressions
by Jeffrey Friedl
O'Reilly Media, Inc.; Published: 2006-08-08; Paperback; Book
Best price: $24.69
Price in other shops: $44.99
Microsoft SQL Server 2005 Reporting Services 2005 ImageMicrosoft SQL Server 2005 Reporting Services 2005
by Brian Larson
McGraw-Hill Osborne Media; Published: 2005-12-12; Paperback; Book
Best price: $24.45
Price in other shops: $49.99
PHP 6 and MySQL 5 for Dynamic Web Sites: Visual QuickPro Guide ImagePHP 6 and MySQL 5 for Dynamic Web Sites: Visual QuickPro Guide
by Larry Ullman
Peachpit Press; Published: 2007-12-29; Paperback; Book
Best price: $24.07
Price in other shops: $39.99
Microsoft SQL Server 2005 Unleashed ImageMicrosoft SQL Server 2005 Unleashed
by Ray Rankins, Paul Bertucci, Chris Gallelli, Alex T. Silverstein
Sams; Published: 2006-12-31; Paperback; Book
Best price: $35.72
Price in other shops: $59.99
High Performance MySQL: Optimization, Backups, Replication, and More ImageHigh Performance MySQL: Optimization, Backups, Replication, and More
by Baron Schwartz, Peter Zaitsev, Vadim Tkachenko, Jeremy Zawodny, Arjen Lentz, Derek Balling
O'Reilly Media, Inc.; Published: 2008-06-26; Paperback; Book
Best price: $28.46
Price in other shops: $49.99
MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005 Implementation and Maintenance (Pro-Certification) ImageMCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005 Implementation and Maintenance (Pro-Certification)
by Solid Quality Learning
Microsoft Press; Published: 2006-06-28; Hardcover; No Operating System; Book
Best price: $33.94
Price in other shops: $59.99
Sams Teach Yourself SQL in 10 Minutes (3rd Edition) (Sams Teach Yourself) ImageSams Teach Yourself SQL in 10 Minutes (3rd Edition) (Sams Teach Yourself)
by Ben Forta
Sams; Published: 2004-04-10; Paperback; Book
Best price: $11.94
Price in other shops: $19.99
PHP and MySQL Web Development (4th Edition) (Developer's Library) ImagePHP and MySQL Web Development (4th Edition) (Developer's Library)
by Luke Welling, Laura Thomson
Addison-Wesley Professional; Published: 2008-10-11; Paperback; Book
Best price: $31.28
Price in other shops: $49.99
Access 2007: The Missing Manual ImageAccess 2007: The Missing Manual
by Matthew MacDonald
Pogue Press; Published: 2006-12-29; Paperback; Book
Best price: $20.09
Price in other shops: $34.99
Similar Books and other products
Oracle Database 10g PL/SQL Programming ImageOracle Database 10g PL/ SQL Programming
by Scott Urman, Michael McLaughlin
McGraw-Hill Osborne Media; Published: 2004-04-19; Paperback; Book
Best price: $27.75
Price in other shops: $54.99
Toad Pocket Reference for Oracle (Pocket Reference (O'Reilly)) ImageToad Pocket Reference for Oracle (Pocket Reference (O'Reilly))
by Jeff Smith, Patrick McGrath, Bert Scalzo
O'Reilly Media, Inc.; Published: 2005-05-31; Paperback; Book
Best price: $5.30
Price in other shops: $9.95
Oracle PL/SQL by Example (3rd Edition) (Prentice Hall PTR Oracle Series) ImageOracle PL/ SQL by Example (3rd Edition) (Prentice Hall PTR Oracle Series)
by Benjamin Rosenzweig, Elena Silvestrova
Prentice Hall PTR; Published: 2003-09-20; Paperback; Book
Best price: $36.57
Price in other shops: $59.99
Mastering Oracle SQL and SQL*Plus ImageMastering Oracle SQL and SQL*Plus
by Lex de Haan
Apress; Published: 2004-12-30; Paperback; Book
Best price: $25.00
Price in other shops: $39.99
TOAD Handbook (Developer's Library) ImageTOAD Handbook (Developer's Library)
by Bert Scalzo, Dan Hotka
Sams; Published: 2003-03-03; Paperback; Book
Best price: $18.40
Price in other shops: $29.99
Easy Oracle PL/SQL Programming: Get Started Fast with Working PL/SQL Code Examples (Easy Oracle) ImageEasy Oracle PL/ SQL Programming: Get Started Fast with Working PL/ SQL Code Examples (Easy Oracle)
by John Garmany
Rampant Techpress; Published: 2006-03-01; Paperback; Book
Best price: $10.42
Price in other shops: $16.95
Mastering Oracle PL/SQL: Practical Solutions ImageMastering Oracle PL/ SQL: Practical Solutions
by Connor McDonald, Chaim Katz, Christopher Beck, Joel R. Kallman, David C. Knox
Apress; Published: 2004-01; Paperback; Book
Best price: $40.42
Price in other shops: $49.99
Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions ImageExpert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions
by Thomas Kyte
Apress; Published: 2005-09-15; Paperback; Book
Best price: $31.41
Price in other shops: $49.99
Oracle Pl/Sql Programming ImageOracle Pl/ Sql Programming
by Steven Feuerstein, Bill Pribyl, Debby Russell
Published: 1997-01-15; Paperback; Book
Best price: $40.48
Price in other shops: $49.95
Oracle PL/SQL For Dummies ImageOracle PL/ SQL For Dummies
by Michael Rosenblum, Paul Dorsey
For Dummies; Published: 2006-06-13; Paperback; Book
Best price: $5.86
Price in other shops: $29.99
Book store. Illustrated catalog of books on different categories