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.
Beginning PL/SQL: From Novice to Professional
by Donald Bales
eBook
-
ISBN-13:
9781430204206
- Publisher: Apress
- Publication date: 08/26/2007
- Sold by: Barnes & Noble
- Format: eBook
- Pages: 476
- File size: 4 MB
Available on NOOK devices and apps
Want a NOOK? Explore Now
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.
- 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
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.
Customers Who Bought This Item Also Bought
-
- Beginning SQL Server 2008…
- by Robert WaltersGrant FritcheyCarmen Taglienti
-
- The Art of SQL
- by Stephane FaroultPeter Robson
-
- Sams Teach Yourself SQL in One…
- by Ryan StephensRon PlewArie D. Jones
-
- Pro Oracle SQL
- by Karen MortonKerry OsborneRobyn SandsRiyaj ShamsudeenJared Still
-
- WordPress: Pushing the Limits
- by Rachel McCollin
-
- Querying with SQL T-SQL for…
- by IFS Harrison
-
- Oracle Database 11g A Beginner…
- by Ian AbramsonMichael AbbeyMichael J Corey
-
- Oracle PL/SQL Best Practices:…
- by Steven Feuerstein
-
- Beginning COBOL for…
- by Michael Coughlan
-
- Learn to Write DAX: A…
- by Matt Allington
-
- Swift For Dummies
- by Jesse Feiler
-
- SQL in a Nutshell: A Desktop…
- by Kevin KlineDaniel KlineBrand Hunt
-
- LINQ for Dummies
- by John Paul Mueller
-
- Java and SQL
- by Malcolm Taylor
-
- Joe Celko's SQL for…
- by Joe Celko
-
- Pro Oracle Database 11g…
- by Darl Kuhn
-
- Data Mining Techniques: For…
- by Gordon S. LinoffMichael J. A. Berry
-
- Expert Oracle Database…
- by Thomas Kyte
Recently Viewed
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