ORACLE DATABASE ADMINISTRATION
Course is designed to:
Prepare the candidates in getting prepared for the changing trends in Technology and be able to face the real world situations, using our company's hands on experience in maintaining the databases. Bringing the onsite practical experiences to the classrooms.
 
Course duration options:

Oracle DBA Training Fast Track - 32 Days

Oracle DBA Training Normal Track - 64 Days

Oracle DBA Training Weekend Track - 16 Days

 
Oracle9i Database Administration Training-Fast Track

Course duration(in hrs): 120
 
Course Topics
 
Architecture and Administration
Network Administration
Backup and Recovery
Performance Tuning
   
  User Management and Security
 

  1. Creating and Managing Users

  2. Creating and Managing Roles

  3. Creating and Managing Profiles

  4. User Authentication

  5. Passwordfile Management

  6. Database Auditing
 
  Integrity Constraints
 

  1. Globalization Parameter

  2. Loading Methods

  3. SQL*Loader

  4. Direct Load
 
  Oracle Network Administration
 

  1. Oracle Networking Overview

  2. Oracle Net Stack Communication Architecture

  3. Oracle Net Services Server Side Configuration
 
  Oracle Network Administration
 

  1. Oracle Net Services Client Side Configuration

  2. Usage and Configuration of Oracle Names Method
 
  Oracle Network Administration
 

  1. Usage and Configuration of the Shared Servers

  2. Usage and Configuration of Connection Manager

  3. Troubleshoot the Network Environment

  4. Security in Network Environment
 
  Backup and Recovery
 

  1. Backup and Recovery Considerations

  2. Logical Backup using Export Utility

  3. Logical Recovery using Import Utility

  4. Transportable Tablespaces
 
  Backup and Recovery
 

  1. Physical Backup without Recovery Manager

  2. Cold or Offline Backup

  3. Hot or Online Backup
 
  Backup and Recovery
 

  1. Types of Failures and Troubleshooting

  2. Physical Recovery without Recovery Manager

  3. Complete Recovery with Archiving

  4. Incomplete Recovery with Archiving
 
  Oracle Recovery Manager (RMAN)
 

  1. Oracle Recovery Manager Overview

  2. Creating and Maintaining Recovery Catalog

  3. Recovery Manager Commands
 
  Oracle Recovery Manager (RMAN)
 

  1. Physical Backup using Oracle

  2. Recovery Manager

  3. Restoring and Recovering using Oracle Recovery Manager
 
  Oracle Performance Tuning
 

  1. Database Planning

  2. Oracle Alert Files and Trace Files

  3. Dynamic Performance Views

  4. Oracle Utilities
 
  Oracle Performance Tuning
 

  1. Tuning Shared Pool

  2. Tuning Database Cache

  3. Tuning Redo Log Buffer
 
  Oracle Performance Tuning
 

  1. Using the ANALYZE Statement

  2. Using the DBMS_STATS Package

  3. SQL Trace and TKPROF

  4. Using EXPLAIN PLAN

  5. Using Auto trace
 
  Oracle Performance Tuning
 

  1. Using Oracle Blocks Efficiently

  2. Optimize Sort Operations

  3. Tuning Rollback Segments

  4. Monitoring and Detecting Lock Contention

  5. Contention Issues
   
  Application Tuning
 
  Oracle Performance Tuning
 

  1. Resource Manager

  2. Resource Manager Overview

  3. Configuring Resource Manager

  4. Monitoring Resource Manager

  5. I/O Contention

  6. UNIX Tools or Commands

  7. dbverify
   
 
   
 
     
 
Training Portfolio
 
 
Courses
Course material designed by experts
Tutorial
Certification Guidance
 
     
     
     
     
 
 
     
© 2009, qsoftindia.com, All Rights Reserved
`