Oracle DBA
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
    		•