Oracle DBA Training On Unix/Oracle 10G

Other Links
Oracle DBA Training, Oracle Database Administration Classes, Linux Training Certification IBM AIX Consulting, .Net Training,
Oracle DBA Training on Unix

We would like to take an honor in announcing and declaring Cympac as one of the best Oracle DBA trainers all over Pune and across India.

Modules Covered:




If you are looking for other types of training, check out the training-classes.com directory of business and management skills training seminars

Oracle 10g Administrator
Installing the Oracle Database Software
  • Installation: System Requirements
  • Checking the System Requirements
  • Optimal Flexible Architecture (OFA)
  • Setting Environment Variables
  • Installing the Oracle Software
Creating an Oracle Database
  • Database Configuration Assistant (DBCA)
  • Using the DBCA to Create a Database
Managing the Oracle Instance
  • Starting and Stopping Database Control
  • Oracle Enterprise Manager
Managing Database Storage Structures
  • How Table Data Is Stored
  • Tablespaces and Data Files
  • Space Management in Tablespaces
  • What Is Automatic Storage Management?
  • ASM: Key Features and Benefits
  • ASM: Concepts
Administering User Security
  • Database User Accounts
  • Authenticating Users
  • Administrator Authentication
  • Unlocking a User Account and Resetting the Password
  • Creating a Password Profile
Managing Schema Objects
  • What Is a Schema?
  • Accessing Schema Objects
  • Naming Database Objects
  • Types of Indexes
  • B-Tree Index
  • Bitmap Indexes
  • What Is a View?
  • Creating Views
  • Sequences
  • Creating a Sequence
  • Data Dictionary:
  • Data Dictionary Views
Managing Data and Concurrency
  • Manipulating Data Through SQL
Managing Undo Data
  • Data Manipulation
  • Undo Data
  • Undo Data Versus Redo Data
  • Configuring Undo Retention
  • Guaranteeing Undo Retention
Implementing Oracle Database Security
  • Database Security
  • Standard Database Auditing
  • Uniform Audit Trails
  • Value-Based Auditing
  • Fine-Grained Auditing
  • DBA Auditing
Configuring the Oracle Network Environment
  • Oracle Net Services
  • Oracle Net Listener
  • Establishing Net Connections
  • Establishing a Connection
  • Naming Methods
Proactive Maintenance
  • Optimizer Statistics
  • Using the Manage Optimizer Statistics
  • Automatic Workload Repository (AWR)
  • Automatic Database Diagnostic Monitor (ADDM)
  • Enterprise Manager and Advisors
Performance Management
  • Performance Monitoring
  • SQL Tuning Advisor:
  • Enabling Automatic Shared Memory Management (ASMM)
  • Using the Memory Advisor
{ Top }

Oracle 10g Administrator I
Oracle 10g Administrator II

Backup and Recovery Concepts

Performing Database Backups
  • Oracle Secure Backup
  • User-Managed Backup
  • Recovery Manager (RMAN)
  • Managing Backups
Performing Database Recovery

Performing Flashback
  • When to Use the Flashback Technology
Moving Data
  • Loading Methods
  • Data Pump:
  • Data Pump Export and Import:
  • Data Pump Utility
  • External Table Population with ORACLE_DATAPUMP
  • External Table Population with ORACLE_LOADER
Configuring Recovery Manager

Using Recovery Manager

Database Recovery

Flashback

Dealing With Database Curruption

Monitoring and Managing Memory

  • Memory Management
  • How ASMM Works and how to Configure
Autumatic Performance Management
  • Tuening Activity
  • Performance Planning
  • Statics collection
  • Troubleshooting and Tuening
  • Database Control and Advisor
Managing Storage
  • Space Management
  • Extends Typs
  • Row Chaning and Migretion
  • Monitoring Tablespace
  • Transporting Tablespace
  • Transporting Database
Automatic Storage Management
  • ASM Architecture
  • Creating ASM Instance
  • ASM Storage
  • Disk Group Mirroring
  • ASM files
  • Migreting Database to ASM instance


{ Top}