Book description
Concise and practical, this indispensable volume brings the world’s most popular Relational Database Management System (RDBMS), its query language SQL, and its programming language PL/SQL into clear focus for today’s busy database professional or business analyst. Covering the most commonly used Oracle features, Oracle SQL and PL/SQL Handbook is ideal for the developer or business user challenged with implementing, maintaining, and retrieving mission-critical data within the Oracle database environment.
Broadly designed as both a basic reference and how-to, this book offers extensive coverage of Oracle’s SQL language and database concepts, providing an excellent review for the Oracle certification exams. The 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. Oracle database objects are explored, along with uses of the Data Definition Language (DDL), the Data Control Language (DCL), and the Data Manipulation Language (DML). Later chapters offer complete coverage of the Select command used to retrieve information from the database. Also included are coverage of Oracle’s new analytic functions, a chapter on performance-tuning techniqes needed for complex SQL, and a detailed overview of Oracle’s PL/SQL language. In addition, many chapters provide practice questions designed to reinforce newly introduced concepts, as well as numerous examples of SQL techniques.
The broad-based and comprehensive coverage also includes:
Understanding the database using entity relationship diagrams and database schema diagrams
Applying the Data Definition, Data Control, and Data Manipulation languages to create and maintain the database
Using the SQL language to retrieve information from the database
Creating special business information using Oracle’s new analytic functions
Making your SQL perform better with common troubleshooting techniques
Producing business information with business objects
Using Java with PL/SQL
Authoritative and practical, Oracle SQL and PL/SQL Handbook provides today’s administrator and business analyst alike with the most comprehensive sourcebook of solutions and techniques for improving their use of Oracle.
0201752948B07152002
Table of contents
- Copyright
- Acknowledgments
- Introduction
- About the Author
- Understanding Relational Databases
- Building the Database with the Data Definition Language
- The Data Control and Data Manipulation Languages and the Data Dictionary
- Retrieving Database Records Using SQL: The Select, Where, and Order By Clauses
- Retrieving Records Using SQL: The FROM, GROUP BY, and HAVING Clauses
- Creating New Values with Character Functions
- Creating New Values with Numeric and Date Functions
- Using Set Operators, Subqueries, and Variables
- Analytical Processing with SQL
- Using Database and Materialized Views
- Using SQL*Plus as a Report-Writing Tool
- What You Can Do If Your SQL Does Not Perform
- Using Business Objects
- The Basics of PL/SQL
- Handling Exceptions and Using Named Procedures
- Advanced PL/SQL Topics
- Glossary
- Answers
- Bibliography
Product information
- Title: Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts
- Author(s):
- Release date: August 2002
- Publisher(s): Addison-Wesley Professional
- ISBN: 9780201752946
You might also like
book
Oracle Advanced PL/SQL Developer Professional Guide
Master advanced PL/SQL concepts along with plenty of example questions for 1Z0-146 examination with this book …
book
Oracle SQL Revealed: Executing Business Logic in the Database Engine
Write queries using little-known, but powerful, SQL features implemented in Oracle's database engine. You will be …
book
Expert PL/SQL Practices for Oracle Developers and DBAs
Expert PL/SQL Practices is a book of collected wisdom on PL/SQL programming from some of the …
book
Oracle Database 11g PL/SQL Programming
Design Feature-Rich PL/SQL Applications Deliver dynamic, client/server PL/SQL applications with expert guidance from an Oracle programming …