Oracle Apps DBA Online Training in Hyderabad

FEATURES OF SRYIT:

Course Duration: 60 Hours
Access: With 2 months server access
Trainer Details: 6+ Years Real Time Consultant
Prerequisites: Any Programming Language knowledge will be helpful. It is not compulsory Fresher’s also can learn this course.

Material: Soft Copy of Training Materials (sap abap material), Session Video Recordings will be provided of sessions provided.

After Training: Resume preparation, Interview Questions Career Support will be provided.

Support: 24/7 Customer Support

Contact us for more details and Session Schedules at

USA: +1-319-804-4998  India:+91-9948030675

Email: sryitsolutions@gmail.com

Web: http://www.sryitsolutions.com/

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

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 table spaces and data files
•   Create table spaces
•   Manage table spaces
•   Obtain table space information
•   Create and manage table space using oracle enterprises manager

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

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

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 table spaces that use ASM storage
•   Viewing ASM information
•   Migrating a table space to use ASM storage.

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

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

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