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 qDatabase Conceptsq gives necessary background in relational database theory and Oracle Database concepts, Part 2 qDatabase Implementationq teaches how to implement an Oracle database correctly, Part 3 qDatabase Supportq exposes you to the daily routine of a database administrator, and Part 4 qDatabase Tuningq 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 qThe Big Picture and the Ten Deliverables.q (It is the editoras 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: ac Install and configure an Oracle database, and ensure that itas properly licensed; ac Execute common management tasks in a Linux environment; ac Defend against data loss by implementing sound backup and recovery practices; and ac Improve database and query performance. What youall 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 Administration 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 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 TuningComplete instructions for testing the examples can be found in the comments section of each control file; they are also discussed in ... A Sample SQL*Loader Session C:\app\IGNATIUS\product\11.1.0\db_1\RDBMS\demoagt;sqlldr USERID= scottanbsp;...
|Title||:||Beginning Oracle Database 12c Administration|
|Publisher||:||Apress - 2015-07-07|