Oracle DBA
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. This course also prepares you for the following Oracle Database Administration exams.
Exams Covered
  • 1Z0-031 Oracle9i DBA Fundamentals I
  • 1Z0-032 Oracle9i DBA Fundamentals II
  • 1Z0-033 Oracle9i Performance Tuning
    • 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
    		•