Email
Home Training Clients Careers contact Us

Training

OOAC offers training online and onsite. Our consulting professionals conduct these classes giving a real world experience to our students. OOAC is in the process of bringing training DVDs to our students.

Currently OOAC offers following trainings. Call us today to schedule a training.



» Oracle Database Performance Tuning – Advanced » Oracle RAC DBA – Basic
» Oracle RAC DBA – Advanced » Oracle SQL Programming
» Oracle PL/SQL Programming – Advanced » Oracle Database Administration – Basic
» Oracle Database Administration – Advanced » Oracle Data Guard
» Oracle EBusiness – APPS DBA Track. » Technical Project Management
» Database Backup and Recovery  











Oracle Database Performance Tuning – Advanced


Course objectives:

  • Tuning tips on initialization parameters.
  • RAID configuration
  • Application code tuning
  • Instance memory tuning
  • Database read and writes operation tuning. 
Oracle RAC DBA – Basic

Course objectives:

  • Oracle RAC Concepts
  • Oracle RAC Installation
  • Database Backup and Recovery

Oracle RAC DBA – Advanced

Course objectives:

  • Install Oracle Clusterware and Real Application Clusters
  • Administer a RAC Database
  • Administer Database Services in a RAC environment
  • Administer Oracle Clusterware
  • Add/Remove a node to/from a cluster
  • Patch Oracle Clusterware and RAC software

Oracle SQL Programming


Course objectives:

  • Concepts of SQL Programming
  • Create reports of sorted and restricted data
  • Run data manipulation statements (DML) to update data
  • Control database access to specific objects
  • Manage schema objects
  • Manage objects with data dictionary views
  • Retrieve row and column data from tables

Oracle PL/SQL Programming – Advanced


Course objectives:

  • Describe the Oracle database environment
  • Use various features of SQL Developer
  • Describe and work with the basic elements of Oracle SQL
  • Combine tables using joins and subqueries
  • Create and manage tables, synonyms, sequences, indexes, and views
  • Implement database security by granting privileges and creating roles

Oracle Database Administration – Basic

Course objectives:

  • Install Oracle Grid Infrastructure
  • Create and manage users
  • Install and Configure Oracle Database
  • Create and manage storage structures
  • Administer the Oracle Database
  • Backup and Recovery

Oracle Database Administration – Advanced

Course objectives:

  • Back up and recover a database
  • Configure Oracle Database for optimal recovery
  • Administer ASM disk groups
  • Use an RMAN backup to duplicate a database
  • Automating Tasks with the Scheduler

Oracle Data Guard

Course objectives:

  • Create a physical standby database
  • Evaluate benefits of using the Data Guard Broker
  • Monitoring the Data Guard Configuration
  • Configure fast-start failover
  • Identify the factors that affect planned and unplanned downtime


Oracle EBusiness – APPS DBA Track.

Course objectives:

  • Understand and implement function security
  • Manage the Oracle E-Business Suite using Oracle Applications Manager
  • Understand Oracle Workflow concepts, components, and implementation
  • Personalize an Oracle E-Business Suite Form using Form Personalization
  • Personalize an Oracle Applications Framework page
  • Define and administer concurrent managers
  • Manage concurrent programs
  • Understand and implement Oracle User Management
  • Manage printers and printing
  • Understand auditing functionality
  • Understand selected DBA duties with the Oracle E-Business Suite
  • Manage profile options
  • Describe data security
  • Administer folders
  • Incorporate custom help files
  • Manage document sequences

Technical Project Management

Course objectives:

  • Project Management Framework
  • Standard of Project Management for Project.
  • Project Management Knowledge Areas.
  • Technical Project Management scope and deliverables.

Database Backup and Recovery

Course objectives:

  • Plan effective backup and recovery procedures
  • Use Recovery Manager to create backups and perform recovery operations
  • Use Oracle Flashback technologies to recover from human error
  • Install Oracle Secure Backup
  • Perform an Oracle-suggested backup to tape
  • Use Oracle Secure Backup to perform a file system backup
  • Use Oracle Secure Backup to perform a file system restoration
  • Perform an encrypted database backup and restore
  • Manage the Oracle Secure Backup environment
  • Monitor and tune Recovery Manager
  • Perform tablespace point-in-time recovery
  • Create a duplicate database
  • Create and manage a recovery catalog database

Professional Support
Remote DBA
Retainer Services
Accounts & HR
Web Design
Latest News

 

Microsoft Partner

OOAC partnered with Microsoft Corporation. 

OOAC believes industry certificatied professional can deliver quality solution to our customers.

 


Oracle 11g shatters performance benchmarks records.

Read on Oracle 11g RAC features.


OOAC Certifications

OOAC believes in industry certified professionals.   We are proud to say all our clients are referential clients!!!

List of our current industry certifications:-

Cisco Certified Network Associate (CCNA)
Microsoft Certified Professional (MCP)
Oracle Certified Professional (OCP)
Project Management Professional (PMP)

 

 

 


Content copyright © 2009. Outsource Online and Consulting LLC. All rights reserved.    |   Sitemap   |   Contact Us