Home » Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts [With CDROM] by John Adolph Palinski
Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts [With CDROM] John Adolph Palinski

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

John Adolph Palinski

Published August 18th 2002
ISBN : 9780201752946
Paperback
528 pages
Enter the sum

 About the Book 

-- Authoritative and practical coverage of Oracle, its query language SQL, and its programming language SQL-- Covers SQL performance tuning and troubleshooting, using Java with PL/SQL, and using Oracles new analytic functions to create specialMore-- Authoritative and practical coverage of Oracle, its query language SQL, and its programming language SQL-- Covers SQL performance tuning and troubleshooting, using Java with PL/SQL, and using Oracles new analytic functions to create special business information-- The practice questions at the end of each chapter provide an excellent review for the Oracle Certification examsOracle SQL and PL/SQL Handbook is designed as both a basic reference as well as a how-to guide. It offers thorough coverage of Oracles 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 books 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 books chapters provide practice questions designed to reinforce concepts covered.