FAQ: Books
Date: 28 Nov 1994 23:58:04 GMT
Message-ID: <3bdqqc$i62_at_aggedor.rmit.EDU.AU>
What follows below the form-feed is the output of the Web Page of the Oracle
FAQ on books. This "chapter" is just about finished. I'll be mailing
the various sections, formatted, when they near stability or where they
are pretty important.
See ya later folks.
BOOKS ABOUT ORACLE
$Date: 1994/11/28 23:48:03 $
$Revision: 1.3 $
$State: Exp $
Revision Log
This section covers commercial publications directly relating to Oracle. It does *not* cover publications of relevance to databases generally (such as works by C.J. Date) or operating systems, although there have been such bibliographies published in ORACLE-L or comp.databases.oracle from time to time.
Non-commercial information available electronically is also not covered in this section.
- Publications from Oracle
- Oracle Performance Tuning
- Mastering Oracle V6
- Oracle 7: The Complete Reference
- Dan's Oracle 7 Guide
- Oracle Data Processing
- Oracle SQL Develeper's Guide
- Oracle: A Database Develeper's Guide
- Relational Database Management with Oracle
- Using the Oracle Toolset
- SQL Guide for Oracle
- Rapid Development with Oracle CASE
- Oracle Case*Method: Function and Process Modelling
- Oracle: Forms Developer's Companion
- Oracle 7.0 Administration and Management
Publications from Oracle
Oracle produces a wide range of documentation, apart from the "base" manuals that you get with the products. There's even a book published that is a guide to the available documentation.d
First off, there are the manuals for so-called "advanced" techniques, that IMHO should form part of the standard documentation. Some I consider essential are the "Database Performance Tuning Guide" for the DBA and "Advanced Techniques For ..." for Forms or CASE programmers. If there is not a copy of these books available for each team, then you are *seriously* missing out on *good stuff*.
There are also periodicals, both "glossies" and technical alert bulletins.
Some books by Oracle staff (or ex-staff) are now being published independently.
Back to top of file
Oracle Performance Tuning
Auth: Peter Corrigan and Mark Gurry
Publ: O'Reilly and Associates
O'Reilly sent me a copy for review, and I think it is great, *honest*.
In my opinion, one of the major good things about the book is that it
points out that performance tuning is not the responsibility of the
DBA only, or even analysts and code-cutters but also project managers.
The book is broken up into sections according to target audience so
its fairly easy to find the sections you need.
The performance of the total project is considered, including exhortations to develop function libraries and interface standards. This is something I personally constantly try to point out, but try and get most managers to invest the time and effort up front....*sigh*.
You could do much worse than using their guidelines as a starting point for standards in your work area.
Both Oracle 6 and 7 are used throughout the book and the appendix for V7 is not merely "here is a list of differences" but "planning for the upgrade and upgrade gotchas". There are sections on UNIX, VMS and network issues.
Rumor has it that O'Reilly may offer "upgrade" prices for some books when the next edition is published. An interesting move by publishers worth encouraging.
Back to top of file
Mastering Oracle V6
Auth: Daniel Cronin and Joe Lee
My copy (long "borrowed") came out fairly soon after the V6 release
and would show its age if not updated. It only discusses SQL*Forms 2.3
and has a V5 to V6 migration guide.
While it is a good overview of the various parts of the Oracle way of doing things, with an almost complete application as an example, it serves best as a quick-starter rather than a book you will need constantly if you are spending most of your time on Oracle work. Nevertheless, good for departmental libraries and for those who need the big picture quick, especially for those who may not have much RDBMS experience.
Back to top of file
Oracle 7: The Complete Reference
Auth: George Koch
Publ: Osborne/McGraw Hill, 1993
This book has received pretty favorable reviews. On my quick look
through it, about half of it was glossary and the rest was a guide,
mainly to the RDBMS and SQL*Plus.
Back to top of file
Dan's Oracle 7 Guide
Auth: Daniel B. Bickle
Although Dan (an ex-Oracle employee) has made early drafts of his
useful tips and code snippets available, I know he has been planning
on marketing it. See the contributors section for contact details.
Back to top of file
Oracle Data Processing
Auth: Siebert
Publ: McGraw-Hill, 1993
Back to top of file
Oracle SQL Develeper's Guide
Auth: Hursch
Publ: McGraw-Hill, 1991
Back to top of file
Oracle: A Database Develeper's Guide
Auth: Rogers
Publ: Prentice-Hall, 1991
Back to top of file
Relational Database Management with Oracle
Auth: Rolland
Publ: Addison-Wesley, 1992 (2ed)
Back to top of file
Using the Oracle Toolset
Auth: Krohn
Publ: Addison-Wesley, 1993
Back to top of file
SQL Guide for Oracle
Auth: Van der Lans
Publ: Addison-Wesley, 1992
Back to top of file
Rapid Development with Oracle CASE
Auth: Billings
Publ: Addison-Wesley, 1993
Back to top of file
Oracle Case*Method: Function and Process Modelling
Auth: Baker
Publ: Addison-Wesley, 1992
This has got very good reviews. Apparently Baker is ex Oracle UK.
Back to top of file
Oracle: Forms Developer's Companion
Auth: Steve Muench, Andrew Yang and Brian Adams
Publ: Maverick Publications
Apparently this covers topics suitable for both novices and old hands
and includes a full discussion of PL/SQL and performance tuning tips.
I had a quick look at it the other day. It was quite impressive,
mainly because I saw them discussing how to create stacks of
variables, co-ordinated by GLOBAL stack counters. This is the only
place I've seen this published, apart from the courses I give.
Back to top of file
Oracle 7.0 Administration and Management
Auth: Michael R. Ault
Publ: John Wiley and Sons
Includes disk and scripts
Back to top of file
Revision Log
Back to top of file
$Log: books.html,v $
# Revision 1.3 1994/11/28 23:48:03 dtb # Forms Developers Companion notes # # Revision 1.2 1994/11/23 16:55:38 dtb # More info on Koch # # Revision 1.1 1994/11/16 15:31:03 dtb # Initial revision # Back to top of file
_________________________________________________________________
-- --- David T. Bath | dtb_at_ftp.bf.rmit.edu.au 3/153 Wattletree Rd | Snr Tech Consultant, Global Consulting Services MALVERN 3144 VIC | 179 Grattan St, Carlton, Vic 3053, Australia +61 3 500 9337 | Ph: +61 3 347 7411 Fx: +61 3 347 0182 WWW pages incl. ORA FAQ: lynx http://www.bf.rmit.edu.au/~dtbReceived on Tue Nov 29 1994 - 00:58:04 CET