Book Review: Oracle 10g/11g Data and Database Management Utilities

From Technologies to Solutions:
Oracle 10g/11g Data and Database Management Utilities
by Hector R. Madrid
PACKT Publishing


The book is well within its perimeters. It discusses in detail nearly all database management utilities that an administrator uses in his day-to-day activities. The book will prove to be helpful for DBAs in a junior role as well as for those who are preparing for database administration certification examinations. The language used in this book helps the reader understand the complex tools offered by Oracle even though he may not be aware of all the tools discussed.

The authenticity of the topics discussed and extensive examples/screen shots used are a real added advantage in understanding the utilities better. This book can also prove to be a good reference material for those involved in routine tasks not worrying about what all Oracle offers.

It deals with normal DBA tools like Data Pump, External tables, SQL Loader, Recovery Manager, Oracle Scheduler, Security Management, Database Configuration Assistant (DBCA) and much more. These are a must to be understood for a database administrator as well as a database developer/enthusiast. For a long time, there has been a demand for technical details of what a database administrator deals in his day-to-day life and this book addresses to this need. The book explains in detail the various tools the DBAs would use and then discusses the feature enhancements done in 11g. Also examples constitute a sizable portion of the book which are nice to have in a book of this magnitude.

In short this book deserves its place in your custody and will prove to be best in times of database administration activities.


Packt Publishing | English | ISBN: 1847196284 | 432 pages


PACKT Publishing

Buy Book from Amazon

Oracle SQL Developer Data Modeler

Oracle SQL Developer Data Modeler is the latest product offering from the Oracle Database Tools group. SQL Developer Data Modeler is an independent, standalone product with a full spectrum of data and database modeling tools and utilities, including modeling for Entity Relationship Diagrams (ERD), Relational (database design), Data Type and Multi-dimensional modeling, full forward and reverse engineering and DDL code generation. The Data Modeler imports from and exports to a variety of sources and targets, provides a variety of formatting options and validates the models through a predefined set of design rules.

Oracle SQL Developer Data Modeler can connect to any supported Oracle Database and is platform independent. A read-only SQL Developer Data Modeler Viewer is also available for download. The viewer allows users to open models created in the Data Modeler.

Click here for Oracle® SQL Developer Data Modeler User's Guide



Oracle® SQL Developer Data Modeler



Note: For download you require free OTN account. If you do not have one, read this for creating one account for you.


For more information visit Oracle website.

Search

Ask your query

Note: Anantha is on a Vacation till November 24th 2009, for his Wedding. Please do expect a late but reply for your queries.
Click here to Ask Anantha your Oracle Query