- Propaganda & Spin
- Brownley, Margaret
- Spiegelman, Art
- Gordon, John
- Landlord & Tenant
- Bestsellers
- Gallagher, Tess
- This Sceptred Isle
- Witchcraft & Wicca
- Ecology
- Brazil
- Personal Finance
- French, Vivian
- K
- Theoretical Methods
- Hillerman, Tony
- Accounting
- Gordon, Noah
- Netscape Communicator
- Billings, Andrew
- Introduction
- General AAS
- Information Management
- Devon
- O'Brien, Richard
- Lee, Chang-Rae
- Costa Rica
- Administrative
- Leigh, Ana
- 1891-1900
- Some of our other sites:
- Books
- Clothing, Shoes and Accessories
- Baby Clothes and Accessories
- Cosmetics, Beauty Products and Fragrances
- Cellphones, Call Plans and Accessories
- Video Games
- DVDs
- Electronics, Gadgets and Computers
- Health and Personal Care
- Home and Garden
- Home DIY
- Jewelry
- Magazines and Newspapers
- Music Downloads
- Musical Instruments
- Office Equipment and Supplies
- Software and Games
- Sporting Goods
- Toys and Games
- Watches
- UK Books
- UK Video Games
- UK Home and Garden
- UK Electronics, Gadgets and Computers
- UK Baby Clothes and Accessories
- UK Software and Games
- UK Sporting Goods
- UK Toys and Games
Books : Computing & Internet : Software & Graphics : Business & Home Office : Home Office Databases : Databases : Oracle : Oracle8i
-
One of a series of Oracle Certified Professional study guides this one, as the name rather heavily suggests, covers the ground you need to know in order to pass the Introduction to Oracle: SQL and PL/SQL examination. The exam forms part of the certification required to become an Oracle8i Certified Database Administrator or Application Developer.
OCP: Oracle8i DBA SQL and PL/SQL Study Guide focuses first on the SQL querying language and then on Oracle's own implementation, PL/SQL, bringing in SQL*Plus, an Oracle tool for interaction with a database. Each chapter starts with a list of objectives and ends with a brief summary, a list of the terms that should have been absorbed followed by 20 multiple choice questions and answers. There is also a practice exam at the end of the book. The CD-ROM contains a bank of questions that includes those from the book and a further series of questions on electronic flashcards that run on a PC or a Palm device. The text of the book is also present in Adobe Acrobat format.
An instance early in the book of a reference to the wrong figure doesn't build confidence and later on a table is split between two pages so that you have to flick back and forth to make sense of it; but in the main the layout is reasonable.
The questions and sample exam paper are useful for getting the feel of what you will face in your attempt to reach the 72 per cent pass mark. Unfortunately there is nothing inspirational about this study guide, just of a lot of hard slog--but whoever said that passing exams was easy? --Mark Whitehorn
-
-
-
-
Massive in size, comprehensive in scope, and unfortunately quite dry in tone, Mastering Oracle 8i has the answers you need if you're working with the Oracle 8i database management system. The authors, one of whom holds an Oracle certification, go into considerable detail on the procedures to be followed for administrative tasks like backing up data, rolling back transactions, and configuring monitoring schemes. They usually share their thoughts on when and why you'd want to put the procedures to use, as well. Better yet, they go beyond everyday administrative work to cover subjects like materialised views, advanced user management, and performance tuning techniques. There's some discussion of hooks for software developers, as well.
The author's approach is to take a feature of the Oracle 8i environment--locks, say--and explain what purpose it serves, then break it down into component types with more detailed explanations. From there, the authors provide the commands and codes for viewing and manipulation of the feature, often with extensive tables. The really useful information comes next, in the form of sections on how to deal with related problems. The section on locks, for example, shows how to zero in on blocking locks. Other excellent coverage deals with how to dimension hardware, while a commendable section explains the object-oriented features of Oracle 8i. --David Wall
Topics covered: how to design and run a tight Oracle 8i ship, with special attention to object orientation, network connectivity, tablespaces, Recover Manager, parallel processing, security and the special demands of distributed databases.
-
O'Reilly Books are an essential part of the library of any developer or system administrator. One of their many series, all with bright orange spines, is devoted to the tools and technologies used to develop Oracle applications. The latest release of Oracle's database, 8i, has a truckload of new features, and this book is here to help you learn how to use them.
You'll need to be a proficient PL/SQL programmer to get the best out of this book. It's intended as a companion for the much larger Oracle PL/SQL Programming, and so don't buy this if you're after an introduction to developing for Oracle. With it you'll learn about the new programming features introduced with Oracle 8i, including native dynamic SQL, new security features and how to use Java with PL/SQL. There are plenty of code samples, and the explanations are clear and concise. You'll find a disk at the back of the book full of sample code and examples. It's unusual to find a floppy in this day and age, but the code is all useful and well worth experimenting with. The Guide to Oracle 8i Features is for keeping on your desk, especially if you're starting to upgrade your databases from an earlier release.--Simon Bisson
-
The sole aim of the OCP: Oracle8i DBA Architecture & Administration and Backup & Recovery Study Guide is to enable you to pass two of the Oracle Certified Professional (OCP) examinations that form part of the Oracle Database Administrator qualification. These are normally the last two exams you'd sit in the series of five (the first is covered by a companion publication, TOCP: Oracle8i DBA SQL and PL/SQL Study Guide).
The Architecture & Administration part starts with an introduction and then covers authentication, Oracle Enterprise Manager tools, creating a database, table spaces, storage structures and security. The slightly larger Backup & Recovery section delves the depths of all flavours of redo log files (online, offline, current online and non-current online), control files and data files. There are chapters on how to proceed without the aid of Oracle Recovery Manager (RMAN) and with it: go for "with" if you have to choose. Coverage is thorough and businesslike: after all, you aren't here to enjoy yourself.
For checking your progress there's a "test engine" on the CD-ROM that contains all the multiple choice questions that appear at the end of each chapter and practice exams. You can take chapter tests and practice exams or generate a new exam composed of a random sample of questions. There are also electronic flashcards of harder questions for downloading to a PC or a Palm for further revision. Pass marks are less onerous than those for other exams in the qualification: 58 per cent for Architecture & Administration and 57 per cent for Backup & Recovery, but hard work is still the order of the day. --Mark Whitehorn
-
The growing interest in the Linux open source operating system, especially for database servers, is reflected in Oracle8i for Linux Starter Kit. Based on Red Hat Linux 6.1 and Oracle8i Enterprise Edition for Linux, it comes, very usefully, with a trial version of the Oracle product on CD-ROM.
The book is classified as an intermediate-level book for DBAs (DataBase Administrators) and application developers. In practice, because there is a great deal of overlap between Oracle8i on Linux and the same product on other platforms, it should also prove useful to people interested in learning more about Oracle generally. Readers are expected to be new to Oracle8i but to have experience with relational database systems. The author's approach is to introduce terminology and concepts and then to intersperse the theory with exercises for hands-on learning.
The book is divided into three parts: getting started (installation and configuration of Oracle8i), the fundamentals of application development and basic database administration. The second part has sections on PL/SQL, Java and the use of database schemas and objects and the third covers access issues, space management, database tuning and protection (i.e. backup and recovery: note that the trial version of Oracle Recovery Manager is not fully functional).
This Starter Kit with its strong focus on exercises and the inclusion of trial software is a good starting point for anyone thinking of making the move to Oracle8i on Linux. --Mark Whitehorn
-
-
-
-
-
Although Oracle8i Web Development doesn't include the "Tips & Techniques" label like some of the other Oracle Press instalments do, it falls into that category. Oracle8i Web Development is a collection of diverse overviews, specific techniques, and recommendations for the wide range of interrelated Oracle tools for creating professional Web applications.
This is not a start-to-finish tutorial but rather a tool for developers already familiar with the Oracle architecture and Oracle Application Server (OAS). It is fast moving, with targeted discussions of issues ranging from hardware preparations to HTML/JavaScript/XML coding to miscellaneous development tools. There are plenty of useful titbits in here for experienced Oracle Web coders, but those newer to the technology platform will likely find the presentation a bit choppy.
One of the most useful sections of this book is its coverage of the WebServer Generator and Oracle Designer packages. Here the reader will learn about the generated procedures and the WebServer Generator's key preferences. Other key chapters on Perl and Java are also useful, albeit rather brief.
An appendix of useful reference Web sites does a good job of rounding out this utilitarian guide. While this title is primarily a compendium of key information and not a comprehensive manual for Web site development, it ties together content about various products that isn't usually found in a single source. --Stephen W Plain
-
-
-
-
-
-
-





















