Oracle 10G Certification Training Course for DBA OCA
Our certification training for Oracle 10g DBA OCA proves one's expertise to perform all basic Oracle tasks for database administration. When you acheive this associate level credential, it shows that you have the skills to install, implement, administer and troubleshoot an Oracle 10g database.
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 Path
- 1Z0-047 Oracle Database SQL Expert
or
- 1Z0-051 Oracle Database 11g: SQL Fundamentals I
and
- 1Z0-042 Oracle Database 10g: Administration I
Course Outline
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-047 Oracle Database SQL Expert
- Using SQL to Query
- 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-042 Oracle Database 10g: Administration I
- Installing
- Creating Databases
- Database Interfaces
- Database Control and Storage Structures
- Users and Security
- Managing Schema Objects and Data
- The SQL*Loader and PL/SQL
- Oracle Net Services and Shared Servers
- Monitoring and Maintenance
- Managing Undo Data and Lock Conflicts
- Managing Backup and Recovery
To earn a certification from Oracle you must also complete a hands-on class from Oracle. Please check Oracle's website for any changes
|