Beginning Oracle Database 11g Administration

From Novice to Professional

By Ignatius Fernandez

Beginning Oracle Database 11g  Administration Cover Image

Open the door to a career as an Oracle database administrator as you learn to plan for and install the Oracle Database software and then learn the rudiments of database administration from longtime Oracle expert Iggy Fernandez.

Full Description

  • ISBN13: 978-1-59059-968-6
  • 464 Pages
  • User Level: Beginner to Advanced
  • Publication Date: February 17, 2009
  • Available eBook Formats: EPUB, MOBI, PDF
  • Print Book Price: $42.99
  • eBook Price: $30.99
Buy eBook Buy Print Book Add to Wishlist

Related Titles

Full 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 this book is 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.

Source Code/Downloads

Downloads are available to accompany this book.

Your operating system can likely extract zipped downloads automatically, but you may require software such as WinZip for PC, or StuffIt on a Mac.

Errata

Please Login to submit errata.

No errata are currently published