# # # #

Service Center

Oracle 10G Certification Training Course for DBA OCA

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
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 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