Beginning PL/SQL: From Novice to Professional [NOOK Book]

Overview

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.



Bales takes his 20+ years of experience and a wealth of statistics he's ...

See more details below
Beginning PL/SQL: From Novice to Professional

Available on NOOK devices and apps  
  • NOOK Devices
  • NOOK HD/HD+ Tablet
  • NOOK
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK Study
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$19.99
BN.com price
(Save 44%)$35.99 List Price

Overview

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.



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: cover what's most needed and used by PL/SQL professionals and avoid what's 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 bang! Key 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/SQL. You'll explore relational PL/SQL, but unlike most other books on the subject, this one emphasizes the use of PL/SQLs object-oriented features as well.


  • Work through real examples of using of PL/SQL. You'll learn PL/SQL by applying it to real-world business problems, not by heavy theory.




What you’ll 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 this book is 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.



Read More Show Less

Editorial Reviews

From Barnes & Noble
You can get rolling with Oracle PL/SQL faster than you think -- and when we say "get rolling," we mean actually start solving business problems, not just fooling around. Beginning PL/SQL: From Novice to Professional is the book can get you there. This is no fancied-up restatement of the "Help": It's a well distilled, surprisingly brief, relentlessly practical introduction to the PL/SQL features developers and DBAs really need to understand in order to write production code.

Which features are those? Well, variables and datatypes; statement execution; cursors; debugging; and testing -- as well as PL/SQL's use in both relational and object-oriented programs. But it's not just about features: As seasoned developers know, it's about writing efficient, maintainable, modular, and reusable code, too. Bales brings two full decades of experience with Oracle, and that experience shows on every page. Bill Camarda, from the October 2007 Read Only

Read More Show Less

Product Details

  • ISBN-13: 9781430204206
  • Publisher: Apress
  • Publication date: 8/26/2007
  • Sold by: Barnes & Noble
  • Format: eBook
  • Edition number: 1
  • Pages: 476
  • Sales rank: 885,772
  • File size: 4 MB

Meet the Author

Donald Bales is a computer applications consultant specializing in the analysis, design, and programming of client-server and web-based distributed systems, systems integration, and data warehousing. Don has over 20 years of experience with Oracle as both a developer and a database administrator, and 10 years of�experience with Java. He is currently working on the migration of medical and industrial hygiene systems to a web environment for a major oil company. When he is not developing applications, Donald can often be found working with horses, playing the piano, or playing the bagpipes. Donald has had several careers, and has at various times been a mechanic, a general contractor, Mr. Mom, a developer, and currently a consultant. He has a bachelor of science degree in business from Elmhurst College in�Illinois. Don resides in Downers Grove, Illinois, with his wife, Diane, and his daughter, Kristyn. He can be contacted by e-mail at don@donaldbales.com.
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing 1 Customer Reviews
  • Anonymous

    Posted June 16, 2011

    No text was provided for this review.

Sort by: Showing 1 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)