# # # #

Service Center

Oracle 11g Performance Tuning Certification Training Course

This certification course is for database administrators, support engineers, and technical consultants. The training covers the skills required for Oracle Database 11g automatic tuning features, including SQL Tuning Advisor, SQL Access Advisor, Automatic Workload Repository and Automatic Database Diagnostic Monitor.

When you have achieved the Oracle Database 11g Performance Tuning Certified Expert credential, you will have validated your skills in management, troubleshooting, and performance tuning the Oracle 11g implementation. This includes the configuration of alerts and metrics; tuning I/O, space usage, buffering, and shared pools; troubleshooting SQL statements; and monitoring applications.

Our Training Includes
unlimiited access  24 x 7 Unlimited Online Access
multi media lessons Full Multi Media Lessons
exercises  Simulated Exercises to test ones understanding.
review questions Review Questions to test ones retention
http://www.netwind.com/assets/images/greencheck.jpg Printable Transcripts of Lessons

Certification Exam Path

  • 1Z0-047 Oracle Database SQL Expert 
    or
  • 1Z0-051 Oracle Database 11g: SQL Fundamentals I
    and
  • 1Z0-052 Oracle Database 11g: Administration Workshop I Release 2
    and
  • 1Z0-053 Oracle Database 11g: Administration Workshop II Release 2
    and
  • 1Z0-054 Oracle Database 11g: Performance Tuning

Course Outline
1Z0-047 Oracle Database SQL Expert 

  • Using SQL to Query Your Database
  • Conversion Functions, Group Functions, and Joins
  • Subqueries, Set Operators, and Data Manipulation
  • Using DDL, Views, Sequences, Indexes, and Synonyms
  • Controlling User Access and Managing Schema Objects
  • Data Dictionary Views and Large Data Sets
  • Managing Data in Different Time Zones
  • Using Subqueries and Regular Expressions

1Z0-051 Oracle Database 11g: SQL Fundamentals I 

  • Using SQL to Query Your Database
  • Conversion Functions, Group Functions, and Joins
  • Subqueries, Set Operators, and Data Manipulation
  • Using DDL, Views, Sequences, Indexes, and Synonyms

1Z0-052 Oracle Database 11g: Administration Workshop I Release 2

  • Database Architecture and Installation
  • Database Creation and Instance Management
  • The ASM Instance and Network Connectivity
  • Storage Structures and User Security
  • Managing Concurrency, Undo, and Auditing
  • Managing Database Maintenance and Performance
  • Backup and Recovery
  • Moving Data and Oracle Support

1Z0-053 Oracle Database 11g: Administration Workshop II Release 2

  • Database Architecture and Recovery Operations
  • The RMAN Catalog and Creating Backups
  • Performing Restore and Recovery Tasks
  • Using, Monitoring and Tuning RMAN
  • Database Diagnostics and Flashback Technologies
  • Managing Database Memory and Performance
  • Managing Database Resources and the Scheduler
  • Managing Database Space and Duplication

1Z0-054 Oracle Database 11g Performance Tuning Certified Expert

  • Performance Tuning Methodology and Tools
  • Using AWR and Defining Problems
  • Metrics, Alerts, Baselines, AWR Tools, and Services
  • Problem SQL Statements and Oracle Optimizer
  • SQL Performance Management and Database Replay
  • Shared Pool and Buffer Cache Tuning
  • Tuning PGA, Temporary Space, and AMM
  • Segment Space, I/O, and Performance Tuning

To earn a certification from Oracle you must also complete a hands-on class from Oracle. Please check Oracle's website for any changes