Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers and Business Analysts

Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers and Business Analysts

by JohnAdolphPalinski (Author)

Synopsis

Oracle SQL and PL/SQL Handbook is designed as both a basic reference as well as a how-to guide. It offers thorough coverage of Oracle's SQL query language and PL/SQL programming language. It focuses on the practical aspects of using SQL and PL/SQL to most effectively extract usable information from Oracle systems. Thus it is of use not only to database administrators, but also to business managers, developers, and power users. The book's initial chapters offer a complete introduction to the relational database environment, including a discussion of how to use the logical data model to understand the database. From there, Oracle database objects are covered, along with uses of the Data Definition Language (DDL), the Data Control Language (DCL), and the Data Manipulation Language (DML). Throughout the book frequently used commands and content are stressed, and numerous examples of SQL techniques are provided. In addition, most of the book's chapters provide practice questions designed to reinforce concepts covered.

$24.82

Save:$14.45 (37%)

Quantity

1 in stock

More Information

Format: Paperback
Pages: 528
Edition: 1
Publisher: Addison Wesley
Published: 08 Aug 2002

ISBN 10: 0201752948
ISBN 13: 9780201752946
Book Overview:

Oracle SQL and PL/SQL Handbook is designed as both a basic reference as well as a how-to guide. It offers thorough coverage of Oracle's SQL query language and PL/SQL programming language. It focuses on the practical aspects of using SQL and PL/SQL to most effectively extract usable information from Oracle systems. Thus it is of use not only to database administrators, but also to business managers, developers, and power users. The book's initial chapters offer a complete introduction to the relational database environment, including a discussion of how to use the logical data model to understand the database. From there, Oracle database objects are covered, along with uses of the Data Definition Language (DDL), the Data Control Language (DCL), and the Data Manipulation Language (DML). Throughout the book frequently used commands and content are stressed, and numerous examples of SQL techniques are provided. In addition, most of the book's chapters provide practice questions designed to reinforce concepts covered.


Author Bio

John Adolph Palinski is a Supervisor of Computer Applications for the Omaha Public Power District where he has developed and implemented numerous Oracle systems. He is also an instructor at the University of Nebraska at Omaha. A Certified Oracle Professional Developer, he has taught SQL, PL/SQL, and Developer 2000 courses and is the author of Oracle Database Construction Kit (Que, 1997). He is a frequent contributor to Oracle periodicals such as Oracle Internals and Oracle Professional. He also provides on-site training through his consulting company, Realistic Software Training.

0201752948AB07152002