OCA Database 11g Administrator

COURSE OVERVIEW

Learn about creating and maintaining an Oracle database

Become the expert of your company’s database and benefit from a lucrative role as a database manager with the OCA Database 11g 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

Amazing opportunities exist for IT professionals that prove their database skills with a certification from the industry leader in database technology.

2

LEARN IN-DEMAND SKILLS

Storing and protecting data is in high demand for many organizations around the world. Achieve the OCA Database 11g Administrator and watch your demand grow.

3

GLOBALLY RECOGNIZED

Oracle certifications are recognized all over the globe and provide a multitude of opportunities for IT professionals who train and meet the demand.

Course guide

Qualification:  OCA 11g Certified Associate

Study time: Full time – 21 days | Part time – two to four months

Vendor: Oracle

Student support: Success Advisors

Prerequisites: Familiarity with data processing techniques and ability to use a GUI

Assessment: Exam based – 1Z0-047 or 1Z0-051 + 1Z0-052

Resources: Internet access and email

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

Modules

1Z0-047 Oracle Database SQL Expert

  • Using SQL to query your database
  • Conversion functions, group functions and joins
  • Sub queries, set operators and data manipulation
  • Using Ddl, views, sequences, indexes and synonyms
  • Controlling user access and managing schema objects
  • Managing data in different time zones
  • Using sub queries 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 release 2: Administration Workshop I

  • Database architecture and installation
  • Database creation and instance management
  • 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
  • Oracle support

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