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

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.