Guerrilla Oracle: The Succinct Windows Perspective [Paperback]

Richard Staron (Author)

Book Description

Publication Date: February 19, 2003

As Oracle has grown and developed and added new features, books about Oracle have likewise grown oversized and bloated and intimidating for the beginner. This book is a succinct introduction to the overall features of Oracle. It does not get into great depth about any of those features. It is a tutorial in nature. The authors use an example database to teach readers how to turn a Windows server into an Oracle server, configure both the Oracle server and client PCs, enable remote access, work with "customers" on designing the database, normalize the data, turn the concepts into a real relational database, design the GUI forms, write the code, produce the reports, and then web enable the system. The reader will be the DBA, the programmer, and the business analyst. At the end, the reader will have developed a fully functional database, and will have a solid, well-rounded grasp of Oracle.

Editorial Reviews

From the Back Cover

Are you frustrated by your attempts to learn Oracle or improve your Oracle skills because of the sheer amount of technical documentation you have to wade through? This concise tutorial walks you step-by-step through the process, showing you exactly what you need to know to install, create, and support a successful Oracle 8i or 9i environment with Web capabilities.

Guerrilla Oracle®: The Succinct Windows Perspective presents clear explanations of database, SQL, and Oracle fundamentals. Using a real-world, large-scale example to demonstrate essential tasks, the book follows the Oracle DBMS life cycle from business idea to functioning database.

Guerrilla Oracle® gives you the foundation you need to build a functioning system and to begin exploring more complex technical topics. Along with a deeper understanding of the Oracle DBMS, you will learn the concrete skills, strategies, and techniques you need to make your database a reality.

You will learn how to:

• Install and configure the Oracle Database server on a Windows server
• Configure client PCs
• Install and define the Oracle Database software
• Create basic database security schemas and formalize backup plans
• Design a database and normalize the data
• Integrate a legacy system into the Oracle relational database model using SQL*Loader
• Create the tables
• Develop and modify Oracle Forms and Reports
• Program in SQL, SQL*Plus, and PL/SQL
• Perform major DBA responsibilities
• Enable remote access
• Prepare your database for Web access and e-commerce

The accompanying CD-ROM includes a complete set of the book's code samples, scripts, and examples.

0201750775B01162003

About the Author

Richard J. Staron is manager of IS applications at Eastern Connecticut State University. He has more than twenty years of experience in the data processing field, including hierarchical and relational database design. Richard has extensive experience managing Oracle database installations, supervising Oracle programmers, and teaching Oracle programming.

0201750775AB11012002

See all Editorial Reviews

Product Details

• Paperback: 496 pages
• Publisher: Addison-Wesley Professional (February 19, 2003)
• Language: English
• ISBN-10: 0201750775
• ISBN-13: 978-0201750775
• Product Dimensions: 9.1 x 7.3 x 1 inches
• Shipping Weight: 1.7 pounds
• Average Customer Review: 3.8 out of 5 stars  See all reviews (4 customer reviews)
• Amazon Best Sellers Rank: #3,423,105 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

3 of 3 people found the following review helpful:

5.0 out of 5 stars A good Oracle book to start with, September 13, 2004

By 

Christopher Johnson (Windsor, CT USA) - See all my reviews
(REAL NAME)   

This review is from: Guerrilla Oracle: The Succinct Windows Perspective (Paperback)

I have pondered thru many Oracle books but this one explains the concepts very clearly. I set up Oracle on my computer using the instructions and did all the exercises. I had no problem and learned a lot in a short time.
I would recommend this book for a beginner and then move on to the move advanced Oracle books.

4 of 5 people found the following review helpful:

2.0 out of 5 stars Probably not what you're looking for!, August 4, 2004

By 

dhawn - See all my reviews

This review is from: Guerrilla Oracle: The Succinct Windows Perspective (Paperback)

If you are new to Oracle (and this book is obviously geared toward the new user) you might want to stay away from this book. The author does take a step-by-step approach to installing Oracle and creating databases, etc. but the steps are out of order (you're asked to grant users rights to tables that you have not yet created), code fragments are incorrect (table names change throughout examples) and there is very little "meat" to anything.

In nearly every chapter the author suggest that you go to other documentation for further study. I suggest you bypass this book entirely and move on to something more substantive and accurate.

2 of 4 people found the following review helpful:

4.0 out of 5 stars Excellent, if you are a beginner in Oracle, May 4, 2004

By 

thomas leung (Hong Kong) - See all my reviews

This review is from: Guerrilla Oracle: The Succinct Windows Perspective (Paperback)

Oralce databse is a great topic. If you are the expert in it, I am sure you can find a job in everywhere.

Under re-enginnering process, most of companies will use database and IT technology to save their labour cost. Oracle becomes the key on the process. However a lot of books in the market are too difficult for beginners. Some of them only explain the idea without examples and practices.

Through this book, you can learn the basic concepts and take some hands-on exercises. Although it is not the best starting reference (more exercises will be much better), I still recommend this book for the one who interest in Oracle.