Oracle APPS DBA Online Training at Xcelresources.com - PowerPoint PPT Presentation

View by Category
About This Presentation
Title:

Oracle APPS DBA Online Training at Xcelresources.com

Description:

Xcelresources.com is one of the leading top IT Training and Consulting Company in US, with a good placement track record. We have certified trainers. We will provide Online Training, Fast Track online training, with job assistance. Courses: SAP Technologies, Datawhare housing Tools, Oracle Technologies, SAS, JAVA, .NET, BA... Etc. ATTEND DEMO CLASS Xcelresources Inc., USA: +1- 347-618-9235 E-mail: info@xcelresources.com Visit: – PowerPoint PPT presentation

Number of Views:79

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: Oracle APPS DBA Online Training at Xcelresources.com


1
ORACLE APPS DBA Online Training and Placements in
US
www.xcelresources.com
2
ORACLE APPS DBA Online Training
  • Oracle Apps DBA Online Course Content
  • Introduction
  • Identify the oracle product
  • Describe the basic concept of a relational
    database
  • Installing oracle database 10g software
  • System requirements
  • Use Oracle Optimal Flexible Architecture (OFA) 
  • Install software with the Oracle Universal
    Installer
  • Create an oracle database
  • Oracle Database Architecture
  • Oracle instance architecture
  • Use the Database Creation Assistant

www.xcelresources.com
3
ORACLE APPS DBA Online Training
  • Controlling the database
  • Manually configure the Oracle 10g EM dbconsole
  • Start and stop the agent 
  • Start and stop the enterprise manager database
    console 
  • Start and stop the listener 
  • Startup and shutdown the database
  • Storage Structures 
  • Defining the tablespaces and data files
  • Create tablespaces
  • Manage tablespaces
  • Obtain tablespace information
  • Create and manage tablespace using oracle
    enterprises manager

www.xcelresources.com
4
ORACLE APPS DBA Online Training
  • Administering users
  • Create and manage database user accounts 
  • Create and manage roles 
  • Grant and revoke privileges 
  • Oracle Database Security  ---  Only Theory
  • Apply the principal of least privilege
  • Manage default user accounts
  • Implement standard password security features
  • Oracle Net Services
  • Understand Oracle Net concepts
  • Use Oracle Net Manager to create and configure
    listeners
  • Use the Oracle Net Manager to configure client
    and middle-tier connection
  • Use TNSPING to test Oracle Net connectivity

www.xcelresources.com
5
ORACLE APPS DBA Online Training
  • Performance Monitoring
  • Gather optimizer statistics
  • View performance metrics
  • Monitoring and Managing Memory
  • Oracle Memory Structures
  • Automatic PGA Memory Management
  • Using the Memory Advisor
  • Using Automatic Shared Memory Management to avoid
    long running query issues
  • Monitoring and Resolving Lock Conflicts
  • Detect and resolve lock conflicts
  • Manage deadlocks
  • Diagnostic Sources
  • The Alert Log
  • Viewing Alerts with EM
  • Alerts Notification   ----- Only Theory
  • Editing Thresholds ----- Only Theory
  • Trace Files

www.xcelresources.com
6
ORACLE APPS DBA Online Training
  • Proactive Maintenance Objectives   ---  Only
    Theory
  • Set warning and critical alert thresholds
  • Collect and use baseline metrics
  • Use tuning and diagnostic advisors
  • Use the Automatic Database Diagnostic Monitor
    (ADDM)
  • Automatic Storage Management  ---- Only Theory
  • ASM Concepts
  • ASM General Architecture
  • Creating an ASM instance
  • Creating tablespaces that use ASM storage
  • Viewing ASM information
  • Migrating a tablespace to use ASM storage.

www.xcelresources.com
7
ORACLE APPS DBA Online Training
  • Undo Management  ---  Only Theory
  • Monitor and administer undo
  • Configure undo retention
  • Guarantee undo retention
  • Use the undo advisor
  • Backup and Recovery    ---  Only Theory
  • Describe the basics of database backup, restore
    and recovery
  • List the types of failure that may occur in an
    Oracle Database
  • Describe ways to tune instance recovery
  • Identify the importance of checkpoints, redo log
    files, and archived log file

www.xcelresources.com
8
ORACLE APPS DBA Online Training
  • Managing Data
  • Manipulating data through SQL
  • Using Import
  • Using Export
  • Database backups
  • Configure ARCHIVELOG mode
  • Create consistent database backups
  • Back your database up without shutting it down
  • Create incremental backups
  • Automate database backups
  • Monitor the flash recovery area

www.xcelresources.com
9
ORACLE APPS DBA Online Training
  • Managing schema objects
  • Create and modify tables
  • Define constraints
  • View the attributes of a table
  • View the contents of a table
  • Create indexes and views
  • Database Recovery
  • Recover from loss of a control file
  • Recover from loss of a redo log file
  • Recover from loss of a data file

www.xcelresources.com
10
Contact-us
  • Xcel Resources Inc.
  • 777 S. Post Oak Lane
  • One Riverway
  • Suite 1700
  • Houston
  • TEXAS, 77056
  • United States of America
  • Visit http//www.xcelresources.com/
  • E-mail  training_at_xcelresources.com

www.xcelresources.com
About PowerShow.com