Overview
This in-depth guide explains how to use SQL to work with data in a database, and how to automate complicated tasks using PL/SQL.Christopher Allen (Santa Monica, CA) has been a database professional for almost 20 ears. He is an OCP DBA and an OCP Application Developer and has worked on numerous Oracle Financials implementations. In addition, he has taught several hundred computer classes to adults, resulting in extensive experience communicating technical information in ways that are easy to absorb and easy to remember. His published works include the Oracle Certified Professional Application Developer Exam Guide (co-author, Oracle Press), Hard Disk Smarts (John Wiley Publishing), and four books on Lotus (Que). He also served as technical editor for Microsoft's DOS 5 and DOS 6 manuals. He is currently employed at Metier, an Oracle partner company that provides consulting services in the Los Angeles area.
Editorials
From Barnes & Noble
The Barnes & Noble ReviewLearning PL/SQL is the key to leveraging the full power of the Oracle database. Oracle 101 PL/SQL, the first SQL and PL/SQL beginner's tutorial that comes straight from Oracle, is (as you'd expect) authoritative. But it's also unusually approachable.
No experience is necessary. Christopher Allen makes sure you know all the background you need to start using PL/SQL, including the basics of relational databases, and of storing and retrieving data. Allen covers advanced data manipulation techniques, SQL*Plus, using SQL functions, indexes, constraints, and more.
Most of the book's early coverage applies to standard SQL and PL/SQL. In Section III, Allen zeroes in on the PL/SQL-specific techniques you need to write powerful, flexible, efficient Oracle database applications.
Oracle 101 PL/SQL reflects Allen's 20 years of experience as a database developer -- and his experience teaching hundreds of computer classes. You'll find step-by-step examples, clear definitions, Q&As -- all the hallmarks of a tutorial that respects your intelligence but doesn't make unwarranted assumptions about what you already know.(Bill Camarda)
Bill Camarda is a consultant and writer with nearly 20 years' experience in helping technology companies deploy and market advanced software, computing, and networking products and services. His 15 books include Special Edition Using Word 2000 and Upgrading & Fixing Networks For Dummies®, Second Edition