Welcome to Diya Technologies Online Training We Provide Apache Server Administration Online Training|| IBM Websphere Application Server Online Training | |Java J2EE Online Training | |JBoss Application Server Online Training || Linux Admin Training| | Oracle Weblogic Server Online Training | | Oracle Database 10g/11g Online Training| | Solaris Administration Training| | Tomcat Server Admin Online Training || Web Content Manager Online Training || Oracle SOA Suite 11G Administration training || WebSphere MQ Server Online Training | | Websphere Portal Server Administration Online Training





Online Training Institutes in Hyder

Online-oracle-soa-suite-administration11g-trainingOracle SOA Suite 11g Administration Training

Online-oracle-soa-suite-administration11g-trainingOracle Business Inteligence Enterprise Edition (OBIEE) 11g Administration Training

Oracle Fusion Middleware 11g Administration Training

Oracle Weblogic Server Administration 10g/11g/12c Training

Oracle Forms & Reports 11g Administration Training Training

Oracle WebCenter Portal 11g Administration Training(WC) Training

Oracle Enterprise Manager 11g/12c Administration Training(OEM) Training

Oracle Service Bus 11g Administration Training(OSB) Training

Oracle Identity Manager Administration Training(OIM) Training

Oracle Access Manager 11g: Administration Training

Oracle DataBase 10g/11g/12 Administration Training

Oracle GlassFish Server Administration and Deployment

Online-oracle-soa-suite-administration11g-trainingOracle Iplanet Web Server Administration Training

Oracle Weblogic Portal Server 11g Administration









Training Name

Oracle Database 11g /12c Administration





Type of Online Classes
Normal Track
Fast Track
Week-end Track(for Working professionals)




Course Contents


Overview of Oracle Database Administration

  • Relational Databases: Introduction
  • What is SQL?
  • Overview of Oracle Instance and Database
  • Common Tasks of an Oracle Database Administrator (DBA)
  • Tools for Administering an Oracle Database



Installing the Database and Creating the Database

  • Using Oracle Universal Installer
  • Installation Prerequisites
  • Setting Environment Variables
  • Installing the Oracle Database Software: Steps
  • Using the Database Configuration Assistant (DBCA)
  • Using the DBCA to Create a Database
  • Performing Other Actions with the DBCA
  • Using the DBCA to Manage Templates



Using Oracle Enterprise Manager Database Control and SQL-Based Management Tools

  • Oracle Database 11g Release 2 Management Framework: Components
  • Administering the Database by Using Enterprise Manager: Overview
  • Starting the Database Control Console Process
  • Accessing Enterprise Manager Database Control
  • Oracle Enterprise Manager: Navigation
  • Granting Enterprise Manager Administrative Privileges
  • Configuring Enterprise Manager Settings and Preferences
  • Using SQL*Plus and SQL Developer to Access Your Database



Configuring the Oracle Network Environment

  • Tools for Configuring and Managing the Oracle Network
  • Accessing the Enterprise Manager Net Services Administration Page
  • Managing the Oracle Net Listener with Enterprise Manager
  • Using the Listener Control Utility
  • Connecting to an Oracle Database
  • Oracle Net: Naming Methods
  • Using Enterprise Manager to Configure Local Naming
  • Using Oracle Net Manager to Configure Local Naming




Managing the Oracle Instance

  • Oracle Instance Management
  • Oracle Processes
  • Oracle Memory Structures
  • Starting the Instance and Opening the Database
  • Shutting Down an Oracle Database Instance
  • Viewing and Modifying Initialization Parameters
  • Managing Memory Components
  • Viewing the Alert Log




Managing Database Storage Structures

  • Oracle Database Structures
  • Exploring the Storage Structure of the Oracle Database
  • Multiplexing the Redo Log
  • Enlarging the Database
  • Creating, Modifying, and Dropping Tablespaces
  • Reclaiming Space in Your Tablespace
  • Managing Undo Data
  • Using the Undo Advisor to Compute the Minimum Undo Tablespace Size




Administering Users and Security

  • Overview of Users and Security
  • Oracle-Defined Users
  • Creating, Modifying, and Dropping Users
  • Locking and Unlocking Accounts
  • Unlocking a User Account and Resetting the Password
  • Setting the Password Policy
  • Modifying the Default Password Policy
  • Administering Privileges and Roles




Managing Schema Objects

  • Creating, Modifying, and Dropping Tables
  • Understanding Data Integrity and Defining Constraints
  • Viewing the Contents of a Table
  • Creating and Dropping Indexes
  • Managing Views
  • Managing Program Code Stored in the Database
  • Managing Access to Schema Objects
  • Loading Data




Performing Backup and Recovery

  • Backup, Restore, and Recovery Concepts
  • Configuring the Database for Backup and Recovery
  • Configuring Backup Settings
  • Backing Up the Database
  • Using the Oracle-Suggested Backup Strategy
  • Performing Backup Maintenance Tasks
  • Using Oracle Advised Recovery to Recover the Database
  • Performing Flashback Table and Flashback Drop




Monitoring the Database and Using the Advisors

  • Monitoring General Database State, Workload, and Performance
  • Setting Metric Thresholds
  • Setting Up Direct Alert Notification
  • Diagnosing Performance Problems
  • Viewing ADDM Performance Analysis and Responding to Findings
  • Using the SQL Tuning and SQL Access Advisors
  • Configuring the Automatic SQL Tuning Advisor
  • Viewing Automatic SQL Tuning Results




Investigating, Reporting, and Resolving Problems

  • Using the Enterprise Manager Support Workbench
  • Workflow for Investigating, Reporting, and Resolving a Problem
  • Performing the Tasks to Investigate and Report a Critical Error




Managing Oracle Database Software

  • Understanding Software Management and Patch Releases
  • Patching Oracle Database Software
  • Using the Database Upgrade Assistant to Upgrade the Database



Online Training,any individual can take this training from thier place through online.







For Online Training Enquiry Please call to:


Mr.Sham/Reena -0091-9618118809




Email to:









on Course Contents






Apache Server Administration Online Training
Apache Tomcat Server Administration Online Training
Java J2EE Online Training
JBoss Application Server Online Training
Linux Admin Training
Online-oracle-soa-suite-administration11g-trainingSolaris Administration Training
IBM WebSphere Application Server Administration
IBM Web Content Manager Administration Training
IBM WebSphere Portal Server Administration Training
IBM WebSphere MQ Server Administration Training



Other Training Courses
Oracle 10g SQL Training
Oracle PL SQL Training
SQL Server 2008 Training
Andriod Training
Sun Solaris Administration Training
Veritas Volume Manager for Solaris Training
Online-oracle-soa-suite-administration11g-trainingVeritas Cluster Server Training