Oracle 10g

OCP DBA Certification Program Oracle Database 10g is Oracle’s revolutionary new grid offering for database administrators, which include breakthrough self-management, storage management, and clustering features. It is designed to relieve system administrators from repetitive, low-value administrative work & provide them with an opportunity to increase their value and expand their technical skills. The new Oracle University curriculum tracks for Oracle Database 10g are tailored to the scale and needs of customer’s data centers. These new courses target current & new Oracle Database Administrators and provide training in half the time and half the cost.

Oracle Database 10g : Introduction to SQL(Exam #1Z0-007)

  • Introduction to 10g SQL
  •  Writing SQL select Statements
  • Restricting and Sorting Data
  • Using Single-Row Functions to Customize Output
  • Reporting Aggregated Data using the Group Functions
  •  Displaying Data from Multiple Tables
  •  Using Sub-Queries to Solve Queries
  •  Using the SET Operators
  •  Manipulating Data
  •  Using DDL Statement to Create and Manage Tables
  •  Creating Other Schema Objects
  • Managing Objects with Data Dictionary views
  •  Controlling User Access
  •  Manage Schema Objects
  •  Manipulating Large Data Sets
  • Generating Reports by Grouping Related Data
  •  Managing Data in Different Time Zones
  •  Searching Data Using Advanced Sub Queries
  • Hierarchical Retrieval
  • Regular Expression Support

Oracle Database 10g :Administration Workshop I (Exam #1Z0-042)

  • Introduction (Database Architecture)
  • Installing the Oracle Database Software
  • Creating an Oracle Database
  • Managing the Oracle Instance
  • Managing Database Storage Structures
  • Administering User Security
  • Managing Schema Objects
  • Managing Data and Concurrency
  • Managing Undo Data
  • Implementing Oracle Database Security
  • Configuring the Oracle Network Environment
  • Proactive Maintenance
  • Performance Management
  • Backup and Recovery Concepts
  • Performing Database Backups
  • Performing Database Recovery

Oracle Database 10g: Administration Workshop II(Exam #1Z0-043)

  • Introduction to 10g Administration Workshop II
  • Configuring Recovery Manager
  • Using Recovery Manager
  • Oracle Secure Backup
  • Recovering from Non-Critical Losses
  • Incomplete Recovery
  • Flashback
  • Dealing with Database Corruption
  • Monitoring and Managing Memory
  • Automatic Performance Management
  • Monitoring and Managing Storage I
  • Monitoring and Managing Storage II
  • Automatic Storage Management
  • VLDB Support
  • Managing Resources
  • Automating Tasks with the Scheduler
  • Database Security
  • Data Movement
  • Using Globalization Support
  • Workshop Methodology, requirements & setup