Learn Oracle 8i (Paperback)

by Jose A. Romalho (Author) "This chapter provides an overview of the Oracle database and its physical and logical structure, so that you understand the relationship and purpose of each..." (more)
Key Phrases: user arnold, comm from emp, integrity restrictions, Oracle Web Publishing Assistant, Name Null, Oracle Corporation (more...)

Editorial Reviews

Product Description
Learn Oracle8i is a comprehensive guide covering all of the features of the newest release of the Oracle database. Author José A. Ramalho begins with an overview of the Oracle database, including its structure and components, and introduces the basics of database programming. Readers learn to create and maintain tables, use indexes and sequences, restrict access to tables using privileges and roles, and implement constraints and triggers to ensure data integrity.

In addition, the main commands of SQL—structured query language—are introduced, and PL/SQL, Oracle’s extension to SQL, is covered in detail, including its stored procedures and functions, packages, triggers, cursors, and transactions. Readers also learn about SQL*Plus, a tool for working with SQL commands and configuring PL/SQL commands. Advanced topics include distributed processing, data replication, Oracle utilities, and publishing databases to the Internet.

About the Author
José A. Ramalho is considered to be one of the world's foremost authorities and journalists on database technology. He is the best-selling computer book author in Brazil, and a columnist for the Brazilian newspaper Folha de São Paulo. He has written more than 70 computer books in Portuguese, English, and Spanish, including Learn Personal Oracle 8.0 with Power Objects 2.0 (1-55622-546-6), Learn SQL (1-55622-661-6), and Learn Microsoft SQL Server (1-55622-639-X). End

Product Details

• Paperback: 474 pages
• Publisher: Wordware Publishing, Inc.; 1 edition (May 25, 2000)
• Language: English
• ISBN-10: 1556227310
• ISBN-13: 978-1556227318
• Product Dimensions: 9.3 x 7.5 x 1.4 inches
• Shipping Weight: 2.4 pounds
• Average Customer Review: 3.5 out of 5 stars See all reviews (4 customer reviews)
• Amazon.com Sales Rank: #2,001,140 in Books (See Bestsellers in Books)

Customer Reviews

Most Helpful Customer Reviews

4 of 4 people found the following review helpful:

5.0 out of 5 stars The best introductory book about Oracle 8i, July 19, 2001

By	A. Alves "duvida" (Boston) - See all my reviews

Learn Oracle 8i is a handy, fast-moving introduction to Oracle 8i database. This is a very visual approach to the material--the various components of Oracle are presented using screen shots at nearly every turn. This title is not an extensive presentation of the subject but rather an overview of the most important topics and the major components of the product. The easy-to-read language makes it quite a quick read and perfect for a speedy look at Oracle. The topics are well-presented, set in the correct context, and illustrated with real-world examples; however, this tutorial is aimed at the user rather than the administrator.

5 of 6 people found the following review helpful:

1.0 out of 5 stars Very disappointed in this book, February 25, 2001

By	Steve Nardone "stevenardone" (Boston, Massachusetts) - See all my reviews

This book is terrible. It doesn't read like a book - it is simply a list of terse definitions of various database topics.

Based on the Table of Contents, I was really looking forward to learning about data blocks, segments, extents, tablespaces, views, indexes, triggers, constraints, cursors, etc., when I bought this book. Unfortunately, this book was too confusing and poorly written to learn anything.

I mean no disrespect to Mr. Romalho, but the fact that English is not his primary language is probably why the book reads so choppy.

If anyone can recommend a book to me that covers the topics I previously mentioned, please email me at: [e-mail].

2 of 2 people found the following review helpful:

5.0 out of 5 stars An excellent introduction, July 19, 2001

By	Will Smith (San Jose, CA) - See all my reviews

I have had a chance to study the "Learn Oracle 8i". I found it highly comprehensive and extremely easy to understand even though I am doing it on my own. It is better than any "Teach Yourself" series I have come across. This book is ideal for the beginner, not for the advanced user. With this book I had a complete overview of the product in a short period of time.