Oracle DBA
Pre-Requisite: This course requires you to be familiar with DBMS & RDBMS concepts. Working knowledge of any RDBMS package and SQL will be helpful.

Course Description:
This course teaches you Oracle Database Administration and also prepares you for the Oracle certification exam.
You Will Learn How To  
  • Configure and manage Oracle databases
  • Understand the Oracle architecture
  • Manage users and accounts by specifying
        privileges and roles
  • Perform effective storage management to
        maximize space usage and performance
  • Implement Oracle partitions to manage large
        tables
  • Select appropriate Oracle backup and recovery
        options
    • Course Benefits
    This hands-on course prepares you to set up and configure Oracle databases, control and administer user accounts, monitor and optimize database storage, and protect the database with appropriate backup and recovery strategies.
    Who Should Attend
    This course is valuable for those who want to become Oracle Database Administrator. It is designed for those who are looking for insight into the Oracle server architecture.
    Topics Covered
  • 1Z0-031 Oracle9i DBA Fundamentals I
  • Oracle9i new features for administrators
  • Oracle overview and architecture
  • Installing and managing Oracle Database
  • Creating a Database and Data dictionary
  • Control and redo log files
  • Logical and physical database structures
  • Segments and storage structures
  • Managing tables, indexes, and constraints
  • Managing users, security, and globalization
        support
  • 1Z0-032 Oracle9i DBA Fundamentals II
  • Introduction to network administration
  • Configuring Oracle Net on the server
  • Configuring Oracle Net for the client
  • Configuring the shared server option
  • Backup and recovery overview
  • Instance and media recovery structures
  • Configuring the database archiving mode
  • Oracle recovery manager overview and
        configuration
  • User-Managed and RMAN-based backups
  • User-Managed complete recovery and RMAN
        complete recovery
  • User-Managed and RMAN-Based Incomplete
        Recovery
  • RMAN maintenance
  • Recovery catalog creation and maintenance
  • Transporting data between databases
  • Using SQL *Loader to load data
  • 1Z0-033 Oracle9i Performance Tuning
  • Introduction to Performance Tuning
  • Sources of tuning Information
  • SQL application tuning and design
  • Tuning the shared pool
  • Tuning the database buffer cache
  • Tuning other SGA areas
  • Tuning redo mechanisms
  • Tuning disk I/O
  • Tuning contention
  • Operating system tuning
    		•