Beginning Oracle Database 12c Administration: From Novice to Professional / Edition 2

by Ignatius Fernandez

Overview

Beginning Oracle Database 12c Administration is your entry point into a successful and satisfying career as an Oracle Database Administrator.

The chapters of this book are logically organized into four parts closely tracking the way your database administration career will naturally evolve. Part 1 "Database Concepts" gives necessary background in relational database theory and Oracle Database concepts, Part 2 "Database Implementation" teaches how to implement an Oracle database correctly, Part 3 "Database Support" exposes you to the daily routine of a database administrator, and Part 4 "Database Tuning" introduces the fine art of performance tuning.

Beginning Oracle Database 12c Administration provides information that you won't find in other books on Oracle Database. You'll discover not only technical information, but also guidance on work practices that are as vital to your success as are your technical skills. The author's favorite chapter is "The Big Picture and the Ten Deliverables." (It is the editor’s favorite chapter too!) 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.

You will grasp the key aspects of theory behind relational database management systems and learn how to:

• Install and configure an Oracle database, and ensure that it’s properly licensed;

• Execute common management tasks in a Linux environment;

• Defend against data loss by implementing sound backup and recovery practices; and

• Improve database and query performance.

Product Details

ISBN-13:	9781484201947
Publisher:	Apress
Publication date:	07/09/2015
Edition description:	2nd ed.
Pages:	384
Product dimensions:	6.90(w) x 9.90(h) x 0.90(d)

About the Author

Iggy Fernandez has a rich history of working with Oracle Database in many capacities. He is the author of Beginning Oracle Database 11g Administration (Apress, 2009) and teaches Oracle database administration at University of Washington Professional & Continuing Education. He was the president of the Northern California Oracle Users Group (NoCOUG), the longest running and most active Oracle users group in the world. He writes regularly for the NoCOUG Journal and has been its editor for many years. Iggy's favorite topics are database performance and SQL performance, and he regularly speaks on these topics at Oracle conferences. He has a lot of opinions but is willing to change them when confronted with fresh facts. His favorite quote is "A foolish consistency is the hobgoblin of little minds, adored by little statesmen and philosophers and divines - Speak what you think now in hard words, and to-morrow speak what to-morrow thinks in hard words again, though it contradict every thing yousaid to-day." - Ralph Waldo Emerson. You can follow him online at http://iggyfernandez.wordpress.com/.

Table of Contents

Part I: Database Concepts

1. Relational Database Management Systems

2. SQL and PL/SQL

3. Oracle Architecture

Part II: Database Implementation

4. Planning

5. Software Installation

6. Database Creation

7. Physical Database Design

8. User Management and Data Loading

Part III: Database Support

9. Taking Control

10. Monitoring

11. Fixing Problems

12. Backups

13. Recovery

14. Database Maintenance

15. The Big Picture and the Ten Deliverables

Part IV: Database Tuning

16. Instance Tuning

17. SQL Tuning