Recommended books

Title : OCA/OCP Oracle Database 11g All-in-One Exam Guide with CD-ROM: Exams 1Z0-051, 1Z0-052, 1Z0-053 (Osborne ORACLE Press Series) (Hardcover)

Author : John Watson , Roopesh Ramklass , Bob Bryla

Publisher : McGraw-Hill Osborne Media; 1 edition (August 17, 2009)

A Fully Integrated Study System for OCA Exams 1Z0-051 and 1Z0-052, and OCP Exam 1Z0-053

Prepare for the Oracle Certified Associate Administration I and SQL Fundamentals I exams and the Oracle Certified Professional Administration II exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, and a two-minute drill to highlight what you've learned. This authoritative guide will help you pass the test and serve as your essential on-the-job reference. Get complete coverage of all objectives for exams 1Z0-051, 1Z0-052, and 1Z0-053, including:

• Instance management
• Networking and storage
• Security
• SQL
• Oracle Recovery Manager and Oracle Flashback
• Oracle Automatic Storage Management
• Resource manager
• Oracle Scheduler
• Automatic workload repository
• Performance tuning
• And more

On the CD-ROM:

1. Three full practice exams
2. Detailed answers and explanations
3. Score report performance assessment tool
4. Complete electronic book
5. Three bonus exams available with free online registration

• Hardcover: 1050 pages
• Publisher: McGraw-Hill Osborne Media; 1 edition (August 17, 2009)
• Language: English
• ISBN-10: 0071629181

Title : Oracle Applications DBA Covers 11i and R12 (Paperback) by Joyjeet Banerjee

Author : Joyjeet Banerjee

Publisher : McGraw-Hill Education (India); 1st edition (August 11, 2008)

Oracle Applications DBA covers all the pertinent aspects of administrating Oracle Applications—from installation to day-to-day maintenance. It covers upgrading, cloning, patching, maintenance and troubleshooting of the application system. Embellished with over 350 screenshots and illustrations, it helps in administrating complex Oracle Database in an easy-to-navigate format. To help readers manage Oracle Applications without much difficulty, a comprehensive discussion on upgrading Oracle Applications in Unix environment has been provided. Further the book includes a balanced coverage of Oracle 11i and R12 – making it a must-have for experienced Oracle Applications DBAs. Professionals who are keen to migrate from DBA to Apps DBA profile would also find the book useful.

• Paperback: 418 pages
• Publisher: McGraw-Hill Education (India); 1st edition (August 11, 2008)
• Language: English
• ISBN-10: 0070077290

Title : Oracle Enterprise Manager 10g Grid Control Implementation Guide (Osborne ORACLE Press Series) (Paperback) by Michael New

Author : Michael New

Publisher : McGraw-Hill Osborne Media; 1 edition (November 21, 2008)

Install and Configure Grid Control to Manage Your Oracle Landscape

Build a robust grid computing infrastructure with guidance from an Oracle expert who developed and taught the Grid Control Deep Dive class to Oracle Consulting. Featuring real-world examples and best practices, Oracle Enterprise Manager 10g Grid Control Implementation Guide explains how to reliably and cost-effectively deploy a dynamic Grid Control environment. Learn how to lay the preinstallation groundwork, configure targets for monitoring, create services, implement security, and fine-tune performance. You'll also get full coverage of backup and recovery strategies and high-availability techniques.

- Prepare infrastructure hosts for Grid Control rollout

- Install the Oracle management repository, service, and agents

- Select the Grid Control installation options that fit your needs

- Discover and manage host, database, and application server targets

- Set target metrics and policies according to best practices

- Optimize performance and availability of your Grid Control framework

- Secure the Grid Control framework to protect data transmitted between components

• Paperback: 768 pages
• Publisher: McGraw-Hill Osborne Media; 1 edition (November 21, 2008)
• Language: English
• ISBN-10: 0071492755

Title : Oracle Database 10g RMAN Backup & Recovery (Paperback) by Matthew Hart

Author : Matthew Hart

Publisher : McGraw-Hill Osborne Media; 1 edition (November 14, 2006)

The Most Complete Guide to Maximizing Oracle Recovery Manager

Deploy a rock-solid data backup and disaster recovery strategy with the in-depth guidance of this authoritative volume. From the exclusive publishers of Oracle Press books, Oracle Database 10g RMAN Backup & Recovery shows you, step by step, how to set up RMAN-ready databases, create reliable backup tapes and discs, and perform accurate Oracle system restores. Find out how to use RMAN from the command line and from Enterprise Manager, generate meaningful lists and reports, and automate administrative tasks using third-party media management tools. Plus, you'll learn to perform incremental backups, Flashback recoveries, and database cloning.

- Set up, configure, and maintain Oracle Database 10g RMAN

- Use RMAN recovery catalogs, target database packages, and control files

- Centralize backup tape management using Oracle Secure Backup

- Perform online, offline, and incremental system backups

- Monitor and tune performance with Enterprise Manager Grid Control and Database Control

- Accomplish complete and partial RMAN database restores

- Improve functionality using VERITAS NetBackup, EMC NetWorker Module, and Tivoli Storage Manager

- Overcome human errors using Flashback Versions Query and Transaction Query

- Create clone and standby databases from tape and disc backups

-Work with Real Application Cluster (RAC) databases and sync-and-split hardware technologies

• Paperback: 666 pages
• Publisher: McGraw-Hill Osborne Media; 1 edition (November 14, 2006)
• Language: English
• ISBN-10: 0072263172

Title :Oracle Database 10g Performance Tuning Tips & Techniques (Osborne ORACLE Press Series) (Paperback) by Richard Niemiec

Author : Richard Niemiec

Publisher : McGraw-Hill Osborne Media; 1 edition (July 30, 2007)

Monitor, analyze, and optimize Oracle Database 10g using the tested methods and insider advice contained in this definitive volume. Written by Oracle Certified Master Richard Niemiec, Oracle Database 10g Performance Tuning Tips & Techniques is packed with detailed case studies, best practices, and code samples illustrating Oracle's new tuning features. Find out how to select optimal indexing options, effectively manage drives and disk arrays, troubleshoot queries, and reliably predict future performance. You'll also get detailed coverage of PL/SQL performance enhancements, initialization file tweaks, and the latest database surveying and reporting utilities.

• Paperback: 967 pages
• Publisher: McGraw-Hill Osborne Media; 1 edition (July 30, 2007)
• Language: English
• ISBN-10: 0072263059

Title :OCP Oracle Database 11g Administration II Exam Guide: Exam 1Z0-053 (Osborne ORACLE Press Series) (Paperback) by Bob Bryla

Author : Bob Bryla

Publisher : McGraw-Hill Osborne Media; 2 edition (December 19, 2008)

A Fully Integrated Study System for OCP Exam 1Z0-053

Prepare for the Oracle Certified Professional Oracle Database 11g: Administration II exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary to highlight what you've learned. This authoritative guide will help you pass the test and serve as your essential on-the-job reference. Get complete coverage of all OCP objectives for exam 1Z0-053, including:

• Database structure and Oracle Automatic Storage Management
• Configuring database recoverability
• Oracle Recovery Manager (RMAN)
• Oracle Flashback
• Memory management techniques
• Database tuning advisors
• Disk space and resource management
• Configuring database diagnostics
• Administering the Oracle Scheduler
• Database globalization

On the CD-ROM:

- One full practice exam that simulates the actual OCP exam

- Detailed answers and explanations

- Score report performance assessment tool

- Complete electronic book

- Bonus exam available free with online registration

• Paperback: 752 pages
• Publisher: McGraw-Hill Osborne Media; 2 edition (December 19, 2008)
• Language: English
• ISBN-10: 0071597093

Title :OCA Oracle Database 11g: Administration I Exam Guide (Exam 1Z0-052)(Paperback) by John Watson

Author : John Watson

Publisher : McGraw-Hill Osborne Media; 1 edition (May 2, 2008)

A Fully Integrated Study System for OCA Exam 1Z0-052

Prepare for the Oracle Certified Associate Oracle Database 11g Administration I exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary to highlight what you've learned. This authoritative guide will help you pass the test and serve as your essential on-the-job reference. Get complete coverage of all OCA objectives for exam 1Z0-052, including:

• Database architecture
• Creating an Oracle Database
• Managing the Oracle instance
• Configuring and managing the Oracle network
• Managing database storage structures
• Administering user security
• Managing schema objects, data and concurrency, and undo data
• Implementing Oracle Database security
• Database maintenance and performance management
• Backup and recovery
• Moving data
• Intelligent infrastructure enhancements

On the CD-ROM:

- One full practice exam that simulates the actual OCA exam

- Detailed answers and explanations

- Score report performance assessment tool

- Complete electronic book

- Bonus exam available free with online registration

• Paperback: 733 pages
• Publisher: McGraw-Hill Osborne Media; 1 edition (May 2, 2008)
• Language: English
• ISBN-10: 0071591028

Title :OCA Oracle Database 11g SQL Fundamentals I Exam Guide: Exam 1Z0-051 (Osborne ORACLE Press Series) (Paperback) by John Watson

Author : John Watson

Publisher : McGraw-Hill Osborne Media; 1 edition (May 29, 2008)

A Fully Integrated Study System for OCA Exam 1Z0-051

Prepare for the Oracle Certified Associate Oracle Database 11g: SQL Fundamentals I exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary to highlight what you've learned. This authoritative guide will help you pass the test and serve as your essential on-the-job reference. Get complete coverage of all OCA objectives for exam 1Z0-051, including:

• SQL SELECT statements
• Restricting and sorting data
• Single-row functions
• Conversion functions and conditional expressions
• Group functions
• Displaying data from multiple tables
• Subqueries
• Set operators
• DML and DDL statements
• Schema objects

On the CD-ROM:

- One full practice exam that simulates the actual OCA exam
- Detailed answers and explanations
- Score report performance assessment tool
- Complete electronic book
- Bonus exam available free with online registration

• Paperback: 581 pages
• Publisher: McGraw-Hill Osborne Media; 1 edition (May 29, 2008)
• Language: English
• ISBN-10: 0071597867

Title :OCP: Oracle Database 11g Administrator Certified Professional Certification Kit: (1Z0-051, 1Z0-052, and 1Z0-053) (Paperback) by Biju Thomas

Author : Biju Thomas

Publisher : Sybex; Pap/Cdr edition (April 13, 2009)

Prepare for your OCP in Oracle Database 11g with this all-in-one study kit

Study, practice, and review for certification as an Oracle Database 11g Administrator Certified Professional with this complete study kit that prepares you for three required exams: 1Z0-051, 1Z0-052, and 1Z0-053.

OCA: Oracle Database 11g Administrator Certified Associate Study Guide

This book covers two required OCA certification exams

• Full coverage of all exam objectives for two of the required OCA exams: Oracle Database 11g: SQL Fundamentals I (Exam 1Z0-051) and Oracle Database 11g: Administration I (Exam 1Z0-052)
• Covers essential topics such as SQL SELECT statements, group functions, creating schema objects, and much more
• Reinforces learning through practical, hands-on exercises
• Real-world scenarios put what you've learned in the context of actual job roles
• Challenging review questions in each chapter prepare you for exam day
• Exam Essentials, a key feature in each chapter, identifies critical areas you must become proficient in before taking the exam
• An interactive CD includes the Sybex test engine, electronic flashcards, practice exams, and a searchable PDF of the book

OCP: Oracle Database 11g Administrator Certified Professional Study Guide

Here's the prep guide for OCP exam 1Z0-053

- Full coverage of all exam objectives for Oracle Database 11g: Administration II (Exam 1Z0-053) in a systematic approach, so you can be confident you're getting the instruction you need for the exam

- Practical hands-on exercises reinforce critical skills

- Real-world scenarios put what you've learned in the context of actual job roles

- Challenging review questions in each chapter prepare you for exam day

- Extra exam practice is available with a bonus exercise workbook in the Appendix

- Exam Essentials, a key feature in each chapter, identifies critical areas you must become proficient in before taking the exam

- An interactive CD includes the Sybex test engine, electronic flashcards, practice exams, and a searchable PDF of the book

• Paperback: 2040 pages
• Publisher: Sybex; Pap/Cdr edition (April 13, 2009)
• Language: English
• ISBN-10: 0470395141

Title :Oracle Database 11g DBA Handbook (Osborne ORACLE Press Series) (Paperback) by Bob Bryla

Author : Bob Bryla

Publisher : McGraw-Hill Osborne Media; 1 edition (December 6, 2007)

The Essential Resource for Oracle DBAs--Fully Updated and Expanded

Manage a flexible, highly available Oracle database with help from the expert information contained in this exclusive Oracle Press guide. Fully revised to cover every new feature and utility, Oracle Database 11g DBA Handbook shows how to perform a new installation, upgrade from previous versions, configure hardware and software for maximum efficiency, and employ bulletproof security. You will learn to automate the backup and recovery process, provide transparent failover capability, audit and tune performance, and distribute your enterprise databases with Oracle Net.

- Plan and deploy permanent, temporary, and bigfile tablespaces

- Optimize disk allocation, CPU usage, I/O throughput, and SQL queries

- Develop powerful database management applications

- Guard against human errors using Oracle Flashback and Oracle Automatic Undo Management

- Diagnose and tune system performance using Oracle Automatic Workload Repository and SQL Tuning Sets

- Implement robust security using authentication, authorization, fine-grained auditing, and fine-grained access control

- Maintain high availability using Oracle Real Application Clusters and Oracle Active Data Guard

- Respond more efficiently to failure scenarios by leveraging the Oracle Automatic Diagnostic Repository and the Oracle Repair Advisor

- Back up and restore tables, tablespaces, and databases with Oracle Recovery Manager and Oracle Data Pump Export and Import

- Work with networked databases, data warehouses, and VLDBs

- Put the latest Oracle Database 11g tools to work--Oracle Total Recall, Oracle Flashback Data Archive, and more

• Paperback: 670 pages
• Publisher: Sybex; Pap/Cdr St edition (April 6, 2009)
• Language: English
• ISBN-10: 0071496637

Title :OCA: Oracle Database 11g Administrator Certified Associate Study Guide: (Exams1Z0-051 and 1Z0-052) (Paperback) by Biju Thomas

Author : Biju Thomas

Publisher : McGraw-Hill Osborne Media; 1 edition (December 6, 2007)

Prepare for two OCA certification exams with this one book

Study, practice, and review for OCA certification in Oracle 11g, Oracle's new release of its top-selling database software. Inside this in-depth guide, you'll find full coverage of essential topics for two required OCA certification exams: SQL Fundamentals I (1Z0-051) and Administration I (1Z0-052). Explore topics such as basic SQL SELECT statements, group functions, creating schema objects, restricting and sorting data, and much more with this essential two-in-one guide. Inside, you'll find:

• Full coverage of all exam objectives in a systematic approach, so you can be confident you're getting the instruction you need for the exam
• Practical hands-on exercises to reinforce critical skills
• Real-world scenarios that put what you've learned in the context of actual job roles
• Challenging review questions in each chapter to prepare you for exam day
• Exam Essentials, a key feature in each chapter that identifies critical areas you must become proficient in before taking the exam
• A handy tear card that maps every official exam objective to the corresponding chapter in the book, so you can track your exam prep objective by objective

Look inside for complete coverage of all exam objectives.

Featured on the CD

SYBEX TEST ENGINE: Test your knowledge with advanced testing software. Includes all chapter review questions and bonus exams.

ELECTRONIC FLASHCARDS: Reinforce your understanding with flashcards that can run on your PC, Pocket PC, or Palm handheld.

Also on CD, you'll find the entire book in searchable and printable PDF. Study anywhere, any time, and approach the exam with confidence.

• Paperback: 1152 pages
• Publisher: Sybex; Pap/Cdr St edition (April 6, 2009)
• Language: English
• ISBN-10: 0470395125