- Full Description
Beginning Oracle Database 12c is your entry point into a successful and satisfying career as an Oracle Database Administrator. Veteran Oracle database administrator Iggy Fernandez, frequent speaker and the editor of NoCOUG Journal, provides one of the best introductions you’ll find to key Oracle database administration topics, including planning, installation, cloud and consolidation, monitoring, troubleshooting, maintenance, and backups, to name just a few. 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 closely tracking the way your database administration career will naturally evolve. Part 1 gives necessary background in relational database theory and Oracle Database concepts, Part 2 teaches 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 includes a list of reference works that contain more information on the topic of the chapter.
Beginning Oracle Database 12c 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.
What youll learn
- Execute common management tasks in a Linux environment.
- Take advantage of pluggable database features for cloud and consolidation.
- Install and configure an Oracle database, and see that it's properly licensed.
- Defend against data loss by implementing sound backup and recovery practices.
- Properly size a database, and create indexes to improve its query performance.
- Grasp the key aspects of theory behind relational database management systems.
Who this book is for
Beginning Oracle Database 12c is the perfect book for those wanting to jumpstart a career in database administration. If you're making the move into that role, or if the role has been thrust upon you by circumstances, you can hardly do better than to have author Iggy Fernandez at your side as you learn the ropes and lay down the foundation of your future success.
- Table of Contents
Table of Contents
Part I: Database Concepts
1. Relational Database Management
2. SQL and PL/SQL by Example
3. Oracle Architecture
Part II: Database Implementation
5. Software Installation
6. Database Creation
Part III: Database Support
7. Physical Database Design
8. User Management and Data Loading
Part IV: Database Support
9. Taking Control
11. Fixing Problems
14. Database Maintenance
15. The Big Picture and the Ten Deliverables
Part V: Advanced Topics
16. Instance Tuning
17. SQL Tuning
Please Login to submit errata.No errata are currently published