Oracle DBA 10g Course

• Introduction to Oracle 10g DBA

• Understanding Oracle working environment

• Managing Oracle server & instance

• Oracle Architectural components

• Installation of Oracle server(on Unix/Linux & Windows)

• Creating Oracle Database

• Using Data Dictionary and Dynamic performance views

• Maintaining control Files

• Maintaining Redo Log Files

• Managing Tablespaces and Datafiles

• Storage structure and Relationship

• Managing undo Data

• Managing Tables

• Managing indexes

• Maintaining Data Integrity

• Managing users

• Managing privileges

• Managing roles

• Managing Password Security and Resources

• Auditing

• Loading Data into Database

• Using globalization support

• Networking overview

• Oracle Net Architecture

• Basic Oracle Net server side configuration

• Naming Method Confirmation

• Usage and Configuration of the Oracle shared Server

• Backup and Recovery overview

• Instance and Media Recovery Structures

• Configuring the Database Archiving Mode

• Oracle Recovery Manager(RMAN) overview and configuration

• User Managed Backups

• RMAN Backups

• Scheduling Backups

• User-Managed complete Recovery

• Recovering from Non Critical Loses

• RMAN complete Recovery

• Incomplete Recovery(User Managed and RMAN)

• RMAN Maintenance

• Recovery Catalog Creation and Configuration

• Transporting Data Between Databases(Logical Backups)

• Data pump & other issues

• Controlling Access to the Oracle Listener

• Flashback database

• Recovering from user Errors

• Dealing with Database Corruption

• Performance Monitoring

• Automatic Management & Proactive Maintenance

• Monitoring and Managing Storage & Application Tunung

• Automatic Storage Management(ASM)

• Monitoring and Managing Memory

• Managing Resources

• Automatic Tasks with the scheduler

• Lock contention

• Diagnosing contention for Latches

• Tuning Rollback Segments

• Optimizing Sort operations

• Database Configuration and I/O Issues

• Using Oracle Block Efficiency

• SQL Statement Tuning

• Tuning Operating system

• Tuning Oracle shared server

• Oracle Data Guard

• Log Miner

• Oracle Enterprise Manager(OEM)

• Up gradation of Oracle Database

• Apply Patches

• Database cloning

• Database Refreshers

• Oracle 11g DBA Features