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

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!

這本書是由資深的 Oracle 資料庫管理員 Iggy Fernandez 撰寫的，他是 Oracle 會議圈的常客，也是 NoCOUG Journal 的編輯。這本書是對 Oracle 資料庫管理的重要主題，包括規劃、安裝、監控、故障排除、維護和備份等等的可管理介紹。從目錄中可以清楚看出，這本書不僅僅是 Oracle 資料庫功能的重述，就像你在 Oracle 網站上免費下載的參考指南一樣。例如，關於資料庫監控的章節解釋了如何監控資料庫的可用性、變更、安全性、備份、增長、工作負載、性能和容量等等。

這本書的章節按照你的資料庫管理職業生涯自然發展的方式進行了邏輯組織。第一部分為你提供了關於關聯式資料庫理論和 Oracle 資料庫概念的必要背景知識，第二部分教你如何正確實施 Oracle 資料庫，第三部分讓你熟悉資料庫管理員的日常工作，第四部分介紹了性能調優的精妙藝術。每個章節都有設計用於幫助你應用該章節教訓的練習題。每個章節還包括一個參考文獻清單，其中包含更多關於該章節主題的資訊。

在這本書中，你會找到其他關於 Oracle 資料庫的書籍中找不到的資訊。在這裡，你不僅會發現技術資訊，還會得到關於工作實踐的指導，這對你的成功和技術技能一樣重要。作者最喜歡的章節是「整體架構和十個交付成果」。如果你認真學習了該章節的教訓，你可以比你想像的更快成為一個更好的 Oracle 資料庫管理員。

你將學到什麼:
- 關聯式資料庫管理系統的理論
- Oracle 資料庫內部結構
- 授權、架構和規模
- 軟體安裝和資料庫建立
- 使用索引提高性能
- 使用者管理和資料載入
- 如何監控資料庫的各個方面
- 如何解決和修復問題
- 資料庫備份和恢復
- 資料庫維護
- 資料庫調優
- SQL 調優

這本書適合誰閱讀:
如果你是一位 IT 專業人士，被迫擔任 Oracle 資料庫管理員角色，卻沒有接受正式培訓，或者你只是想了解 Oracle 資料庫的運作方式，那麼這本書就是為你而寫的。這是作者在很多年前開始使用 Oracle 資料庫時希望自己擁有的書籍。這是他希望能夠給予許多 IT 同事和朋友的基礎 Oracle 資料庫知識的書籍。

關於 Apress Beginning 系列:
Apress 的 Beginning 系列是獲得關鍵入門級工作所需資訊的正確選擇。這些書籍將從基礎開始教你一個標準且重要的技術，因為它們明確設計為帶你從「新手到專業人士」。你將從了解你需要知道的開始你的旅程，但不會有不必要的理論和填充。你將通過逐步學習如何逐步組建真實世界的專案來建立你的技能。因此，無論你的目標是迎接下一個職業挑戰還是尋找新的學習機會，Apress Beginning 系列將引導你前進，它是你在陌生領域中的可靠指南！