Beginning Oracle Database 11g Administration: From Novice to Professional (Beginning from Novice to Professional) (Paperback)

~ (Author)
Key Phrases: listener configuration, release management, database specialists, Oracle Corporation, Enterprise Manager, Enterprise Edition Release (more...)

Editorial Reviews

Product Description

This book, written by veteran Oracle database administrator Iggy Fernandez, a regular on the Oracle conference circuit and the editor of NoCOUG Journal, is a manageable introduction to key Oracle database administration topics including planning, installation, monitoring, troubleshooting, maintenance, and backups, to name just a few. As is clear from the table of contents, this book is not simply a recitation of Oracle Database features such as what you find in the reference guides available for free download on the Oracle web site. For example, the chapter on database monitoring explains how to monitor database availability, database changes, database security, database backups, database growth, database workload, database performance, and database capacity.

The chapters of this book are logically organized into four parts that closely track the way your database administration career will naturally evolve. Part 1 gives you necessary background in relational database theory and Oracle Database concepts, Part 2 teaches you how to implement an Oracle database correctly, Part 3 exposes you to the daily routine of a database administrator, and Part 4 introduces you to the fine art of performance tuning. Each chapter has exercises designed to help you apply the lessons of the chapter. Each chapter also includes a list of reference works that contain more information on the topic of the chapter.

In this book, you'll find information that you won't find in other books on Oracle Database. Here you'll discover not only technical information, but also guidance on work practices that are as vital to your success as technical skills. The author's favorite chapter is "The Big Picture and the Ten Deliverables." If you take the lessons in that chapter to heart, you can quickly become a much better Oracle database administrator than you ever thought possible.

What you’ll learn

• Theory of relational database management systems
• Oracle Database internals
• Licensing, architecture, and sizing
• Software installation and database creation
• Using indexes to improve performance
• User management and data loading
• How to monitor all aspects of your database
• How to solve and fix problems
• Database backups and database recovery
• Database maintenance
• Database tuning
• SQL tuning

Who is this book for?

If you are an IT professional who has been thrust into an Oracle database administration role without the benefit of formal training, or you just want to understand how Oracle Database works, this book is for you. It's the book the author wishes he'd had when he first started using Oracle Database many years ago. It's the book that he would have liked to have given to the many IT colleagues and friends who, over the years, have asked him to teach them the basics of Oracle Database.

About the Apress Beginning Series

The Beginning series from Apress is the right choice to get the information you need to land that crucial entry–level job. These books will teach you a standard and important technology from the ground up because they are explicitly designed to take you from “novice to professional.” You’ll start your journey by seeing what you need to know—but without needless theory and filler. You’ll build your skill set by learning how to put together real–world projects step by step. So whether your goal is your next career challenge or a new learning opportunity, the Beginning series from Apress will take you there—it is your trusted guide through unfamiliar territory!

About the Author

Iggy Fernandez is a veteran Oracle database administrator with more than a dozen years of experience. After being forced, literally overnight, from the world of C programming into a junior database administrator position, Iggy has gone on to make a solid career out of working with Oracle Database. Iggy likes to share his knowledge; he is a regular on the Oracle conference circuit and the editor of NoCOUG Journal.

Product Details

• Paperback: 464 pages
• Publisher: Apress; 1 edition (February 20, 2009)
• Language: English
• ISBN-10: 1590599683
• ISBN-13: 978-1590599686
• Product Dimensions: 9.1 x 6.9 x 1.1 inches
• Shipping Weight: 1.3 pounds (View shipping rates and policies)
• Average Customer Review: 4.7 out of 5 stars  See all reviews (6 customer reviews)
• Amazon.com Sales Rank: #29,033 in Books (See Bestsellers in Books)

  Popular in these categories: (What's this?)

  #1 in	Books > Computers & Internet > Databases > Oracle > DBA
  #3 in	Books > Computers & Internet > Databases > Relational Databases
  #3 in	Books > Computers & Internet > Databases > Beginning & Introductory

Customer Reviews

Most Helpful Customer Reviews

6 of 6 people found the following review helpful:

5.0 out of 5 stars Very Well Writtern!, March 6, 2009

By	C. W. Lawson "OracleMagician" (SF East Bay, California: United States) - See all my reviews (REAL NAME)

Iggy Fernandez is a VERY good writer. I think you'll really appreciate the many insights on the process of being a good Oracle DBA.

This book is unique in that it covers many aspects of the PROCESS of Oracle database administration. It's not really a book of scripts. As Iggy says, this book is an introduction to key concepts, such as monitoring, backups, etc. Each chapter is well organized, with plenty of graphics to make it interesting.

Iggy has also provided many good references, so that the reader can continue researching.

A really fine book!

2 of 2 people found the following review helpful:

5.0 out of 5 stars Excellent book for a new Oracle DBA, May 17, 2009

By	Sumit Sengupta (Avon, OH, USA) - See all my reviews (REAL NAME)

Having worked for a Fortune 50 company as an Oracle DBA for more than ten years, I have read many Oracle books. Apress usually publishes good quality books but where this one stands out is that it teaches a beginning Oracle DBA the tasks of Oracle database administration in a very orderly and precise manner. Go through the chapter list and you will realize that the book covers precisely what a beginning Oracle DBA does.

As a new Oracle DBA you have a choice: read the relevant portions of over 100 Oracle manuals or buy this book, get started on the job, and plan on further reading as you progress in your Oracle career.

The book is written in a platform-agnostic manner but provides instructions to install Oracle on your laptop and follow along. Every chapter ends with exercises and suggestions for further reading which are very helpful.

Part I Database Concepts

Chapter 1 Relational Database Management Systems
Chapter 2 SQL and PL/SQL
Chapter 3 Oracle Architecture

Part II Database Implementation

Chapter 4 Planning
Chapter 5 Software Installation
Chapter 6 Database Creation
Chapter 7 Physical Database Design
Chapter 8 User Management and Data Loading

Part III Database Support

Chapter 9 Taking Control
Chapter 10 Monitoring
Chapter 11 Fixing Problems
Chapter 12 Backups
Chapter 13 Recovery
Chapter 14 Database Maintenance
Chapter 15 The Big Picture and the Ten Deliverables

Part IV Database Tuning

Chapter 16 Instance Tuning
Chapter 17 SQL Tuning

1 of 1 people found the following review helpful:

5.0 out of 5 stars If you read one Oracle book, read this one..., May 21, 2009

By	oracleschmoracle (CA) - See all my reviews

I've worked with relational databases--including Oracle--for most of my career and managed teams of database administrators for many years.

If you're new to Oracle, this is the one book for you. Chock full of real life tips and advice borne from a DBA who has clearly learned the hard way, you will benefit from his successes and failures. Well written and easy to understand, this book will jump start anyone who is new to Oracle or wants to brush up on DBA fundamentals.