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 AdministrationChapter 1. Architectural Overview of Oracle Database 11gChapter 2. Installing and Creating a DatabaseChapter 3. Instance ManagementChapter 4. Oracle NetworkingChapter 5. Oracle StorageChapter 6. Oracle SecurityPart II: SQLChapter 7. DDL and Schema ObjectsChapter 8. DML and ConcurrencyChapter 9. Retrieving, Restricting, and Sorting Data Using SQLChapter 10. Single-Row and Conversion FunctionsChapter 11. Group FunctionsChapter 12. SQL JoinsChapter 13. Subqueries and Set OperatorsPart III: Advanced Database AdministrationChapter 14. Configuring the Database for Backup and RecoveryChapter 15. Back Up with RMANChapter 16. Restore and Recover with RMANChapter 17. Advanced RMAN FacilitiesChapter 18. User-Managed Backup, Restore, and RecoveryChapter 19. FlashbackChapter 20. Automatic Storage ManagementChapter 21. The Resource ManagerChapter 22. The SchedulerChapter 23. Moving and Reorganizing DataChapter 24. The AWR and the Alert SystemChapter 25. Performance TuningChapter 26. GlobalizationChapter 27. The Intelligent InfrastructureAppendix: About the CDGlossaryIndex