Our Oracle Database 11g :Administrator training course for Professional Certification is designed to provide database administrators the skills and knowledge to install, configure, and maintain the database.
Our training tutorials for Oracle Database 11g are created to meet today's DBA challenges. Choose your preferred path and review the certification requirements for the credential you would like to pursue. Certification requirements vary by path. Candidates should thoroughly examine and understand the requirements for their chosen certification path, as the certification requirements will vary depending upon which path you select.
Additionally, to achieve the Oracle's OCP certification you must also complete a training course from Oracle University
Our Training Includes
24 x 7 Unlimited Online Access
Full Multi Media Lessons
Simulated Exercises to test ones understanding.
Review Questions to test ones retention
Printable Transcripts of Lessons
Certification Exam Path
- 1Z0-047 Oracle Database SQL Expert
or
- 1Z0-051 Oracle Database 11g: SQL Fundamentals I
- 1Z0-052 Oracle Database 11g: Administration Workshop I Release 2
- 1Z0-053 Oracle Database 11g: Administration Workshop II Release 2
Training 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
To earn a certification from Oracle you must also complete a hands-on class from Oracle. Please check Oracle's website for any changes |