Oracle E-Business Suite R12 Applications Database Administrator Certified Professional Training & Certification Courses
 800 Ratings

Oracle Authorized Training Partner Expert Chat

Oracle #1 Training Partner

Official Training

Guarantee to Run the Classes

Overview

Koenig offers a course on Oracle E-Business Suite R12 Applications Database Administrator Certified Professional. This course covers: Oracle Database 11g: SQL Fundamentals I, Oracle Database 11g: Administration Workshop I, Oracle Database 11g: Administration Workshop II, and R12x Install/Patch/Maintain Oracle E-Business Suite.

Course Content / Exam(s)

Schedule for Oracle E-Business Suite R12 Applications Database Administrator Certified Professional

Course Name Exam # Duration (days)
Oracle Database: Introduction to SQL

Course Content

Course : Oracle Database: Introduction to SQL

  • Using the SET Operators
  • Introduction to Data Definition Language
  • Using Conversion Functions and Conditional Expressions
  • Reporting Aggregated Data Using the Group Functions
  • Displaying Data from Multiple Tables Using Joins
  • Using Subqueries to Solve Queries
  • Managing Tables using DML statements
  • Controlling User Access
  • Manipulating Data
  • Managing Data in Different Time Zones
  • Introduction to Data Dictionary Views
  • Creating Sequences, Synonyms, Indexes
  • Creating Views
  • Managing Schema Objects
  • Retrieving Data by Using Subqueries
  • Manipulating Data by Using Subqueries
  • Introduction
  • Retrieving Data using the SQL SELECT Statement
  • Restricting and Sorting Data
  • Using Single-Row Functions to Customize Output
1Z0-0615
Oracle Database 11g: Administration Workshop I

Course Content

Course : Oracle Database 11g: Administration Workshop I

  • Exploring the Oracle Database Architecture
  • Installing your Oracle Software
  • Creating an Oracle Database
  • Managing the Oracle Database Instance
  • Manage the ASM Instance
  • Configuring the Oracle Network Environment
  • Managing Database Storage Structures
  • Administering Usersecurity
  • Managing Data Concurrency
  • Managing Undo Data
  • Implementing Oracle Database Auditing
  • Database Maintenance
  • Performance Management
  • Backup and Recovery Concepts
  • Performing Database Backups
  • Performing Database Recovery
  • Moving Data
  • Working with Support
1Z0-0525
Oracle Database 11g: Administration Workshop II

Course Content

Course : Oracle Database 11g: Administration Workshop II

  • Core Concepts and Tools of the Oracle Database
  • Configuring for Recoverability
  • Using the RMAN Recovery Catalog
  • Configuring Backup Settings
  • Creating Backups with RMAN
  • Restore and Recovery Task
  • Using RMAN to Perform Recovery
  • Monitoring and Tuning RMAN
  • Diagnosing the Database
  • Using Flashback Technology I
  • Using Flashback Technology II
  • Performing Flashback Database
  • Managing Memory
  • Managing Database Performance
  • Managing Performance by SQL Tuning
  • Managing Resources
  • Automating Tasks with the Scheduler
  • Managing Space in Blocks
  • Managing Space in Segments
  • Managing Space for the Database
  • Duplicating a Database
1Z0-0535
R12x Install/Patch/Maintain Oracle E-Business Suite

Course Content

Course : R12x Install/Patch/Maintain Oracle E-Business Suite

  • Oracle E-Business Suite Overview
  • Preparing For Your Installation
  • Performing an Installation
  • Finishing Your Installation
  • Oracle E-Business Suite Components
  • Environment Files, Control Scripts, and Languages
  • Oracle E-Business Suite File System
  • Oracle E-Business Suite Database
  • Advanced Configuration Options
  • Using the AD Utilities
  • Distributed AD
  • AD Administration: Generate Applications Files Tasks
  • AD Administration: Maintain Applications Files Tasks
  • AD Administration: Maintain Database Entities Tasks
  • AD Administration: Compile/Reload Database Entities Tasks
  • AD Administration: Non-Interactive Operation and Maintenance Mode
  • Special Utilities
  • AutoConfig
  • License Manager
  • Reporting Utilities
  • Configuration Utilities
  • Patching and the AutoPatch Process
  • Cloning Oracle E-Business Suite
  • Copy Files to Destinations
  • Convert Character Set
  • Maintain Snapshot Information
  • Checking for Missing Files
  • Relink Applications Programs
  • Performing File System Tasks
1Z0-2385
Total 20

Course Prerequisites

  • Basic understanding of databases.
  • Working knowledge of RDBMS concepts & SQL.
  • Working knowledge of Oracle 9i or 10g.

Oracle E-Business Suite R12 Applications Database Administrator Certified Professional Benefits

Upon Completion of this Course, you will accomplish following:

  • Restrict and Sort Data
  • Comprehend Conversion Functions and Conditional Expressions
  • Aggregate Data Using Group Functions
  • Exploring the Oracle Database Architecture
  • Installing your Oracle Software
  • Creating an Oracle Database
  • Managing the Oracle Database Instance
  • Core Concepts and Tools of the Oracle Database
  • Configuring for Recoverability
  • Using the RMAN Recovery Catalog
  • Configuring Backup Settings
  • Oracle E-Business Suite Overview
  • Preparing For Your Installation
  • Performing an Installation
  • Finishing Your Installation

Give an edge to your career with Oracle certification training courses. Students can join the classes for E-Business Suite R12 Applications Database Administrator Certified Professional Training Course at Koenig Campus located at New Delhi, Bengaluru, Shimla, Goa, Dehradun, Dubai & Instructor-Led Online.

Enquire Now

 


 
Loading...

Processing data, please wait...