OCA/OCP Oracle Database 11g All-in-One Exam Guide with CD-ROM

John Watson (UK) OCP DBA 8.0, 8.i, & 9i, 10g, 11g, Interrnet Application Server Administrator, and certified on Managing Oracle on Unix, is a senior consultant with BLP Management Consultants, and taught for Oracle University in South Africa for four years. John taught the DB10g New Features course, the DB10g Manageability and Performance seminars. He validated hundreds of OCP 10g New Features exam questions and contributed to the course material for all the 10g courses. John is the author of numerous articles on technology. Bob Bryla (Plattville, WI) OCP, is an Oracle 8, 8i, 9i, 10g, and 11g Certified Professional with more than 15 years of experience in database design, database application development, training, and Oracle database administration. He is the primary Internet database designer and an Oracle DBA at Lands End in Dodgeville, Wisconsin. Bob is the co-author of the Oracle Database 11g DBA Handbook from Oracle Press (McGraw-Hill), and the OCA: Oracle 10g Administration I Study Guide (1Z0-042) and OCP: Oracle 10g Administration II Study Guide: Exam 1Z0-043 from Sybex/Wiley. Roopesh Ramklass, OCM, is a technical specialist with 10 years of experience in a wide variety of IT environments, including software development, system administration, systems analysis, software design, systems architecture, courseware development, and lecturing. Ramklass is experienced in managing and executing IT development projects, including infrastructure systems provisioning, software development, and systems integration.

Part I: Oracle Database 11g Administration
Chapter 1. Architectural Overview of Oracle Database 11g
Chapter 2. Installing and Creating a Database
Chapter 3. Instance Management
Chapter 4. Oracle Networking
Chapter 5. Oracle Storage
Chapter 6. Oracle Security
Part II: SQL
Chapter 7. DDL and Schema Objects
Chapter 8. DML and Concurrency
Chapter 9. Retrieving, Restricting, and Sorting Data Using SQL
Chapter 10. Single-Row and Conversion Functions
Chapter 11. Group Functions
Chapter 12. SQL Joins
Chapter 13. Subqueries and Set Operators
Part III: Advanced Database Administration
Chapter 14. Configuring the Database for Backup and Recovery
Chapter 15. Back Up with RMAN
Chapter 16. Restore and Recover with RMAN
Chapter 17. Advanced RMAN Facilities
Chapter 18. User-Managed Backup, Restore, and Recovery
Chapter 19. Flashback
Chapter 20. Automatic Storage Management
Chapter 21. The Resource Manager
Chapter 22. The Scheduler
Chapter 23. Moving and Reorganizing Data
Chapter 24. The AWR and the Alert System
Chapter 25. Performance Tuning
Chapter 26. Globalization
Chapter 27. The Intelligent Infrastructure
Appendix: About the CD
Glossary
Index