OCP Database 10g Administrator

COURSE OVERVIEW

Gain expertise relational databases designed for grid computing

Train to become the expert of your organization’s database and reap the rewards of a lucrative career as a database manager with the OCP Database 10g Administrator certification.

On-Demand, Bootcamp or Virtual Classroom options

Access online course content, videos, exercises, discussions and chats

Pre and post course assessments

Virtual labs for hands-on experience

Live lab add-ons available

Develop real-life skills you can apply in the workplace with Live Labs

Access to over 25,000 e-books and 30,000 downloadable video tutorials

Expert mentoring and coaching to answer questions and guide your learning

Course completion certificates

Request Information

*
*
*
*
*
Enter Question *

1

GREAT OPPORTUNITY

Outstanding opportunities are available for those who prove their database skills with an Oracle certification in database technology.

2

LEARN IN-DEMAND SKILLS

Database administration is a much needed skill set for many organizations around the world. Train and certify on the OCP Database 10g Administrator and watch your demand grow.

3

GLOBALLY RECOGNIZED

Oracle certifications are recognized globally and create a multitude of career opportunities for those who train.

Course guide

Qualification: OCP 10g Administrator Certified Professional

Study time: Full time – 12 days | Part time – one month

Vendor: Oracle

Student support: Success Advisors

Prerequisites: OCA 10g certification

Assessment: Exam based – 1Z0-043 – please note, the Oracle 10g exam retires 1 March 2015, training will still be available but students will no longer be able to sit the exam after this date

Resources: Internet access and email

Ideal for: Database administrators, database designers, developer, support engineers or technical administrators

Modules

1Z0-042 Oracle Database 10g release 2: Administration 1

  • Installing Oracle database 10g
  • 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
  • Managing undo data and lock conflicts
  • Monitoring and maintenance
  • Managing backup and recovery

1Z0-043 Oracle Database 10g: Administration 2   

  • Using flashback technology
  • Performing and managing backups
  • Advanced database recovery and repair
  • Controlling the Oracle listener and enabling distributed transactions
  • Using globalisation support

1Z0-047 Oracle Database 11g 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

  • Optimising database performance in Oracle 10g
  • Managing storage and system resources in Oracle 10g
  • Using the sheduler to automate tasks in Oracle 10g
  • Using advanced features in Oracle 10g

Get certified the KnowledgeNet way

Professional development that works around you

  • World’s #1 eLearning portal
  • Global community of peers
  • Expert mentors
  • 12 months unlimited access
  • Test prep
  • Training mapped to Java exam curriculum
  • Award winning training used globally by leading corporate clients