back to Course Categories | back | print
Oracle9i DBA for DB2, Sybase and SQL Server DBAs          

Duration: 5 days

Description 
This accelerated Oracle database administration class is designed for experienced DB2, Sybase or SQL Server DBAs that need to understand how to manage an Oracle database. Students will learn database administration skills by designing, setting up, configuring and managing their own Oracle9i server. Topics include understanding the Oracle9i architecture, storage management, configuring an instance, security and data management. By the end of the class each student will have gone through the main tasks necessary to administer an Oracle9i database. This class will prepare you for the Oracle 9i Database: Fundamentals I certification test (#1Z0-031). Throughout the class differences and similarities between different database platforms will be emphasized.

Topics

  • The Oracle9i architecture
  • Oracle9i instance memory management
  • Similarities between Oracle, DB2, Sybase and SQL Server
  • Differences between Oracle, DB2, Sybase and SQL Server
  • Dynamic SGA
  • Oracle background processes
  • Managing the Oracle database: datafiles, control files and redo log files
  • Oracle Managed files
  • Management of schema objects
  • Dictionary and local tablespace management
  • Automatic undo
  • Undo segment management
  • Temporary tablespaces
  • Multiple block sizes
  • Initialization file and parameters
  • Parameter file persistence
  • Block, extent, segment and tablespace configuration
  • Automatic segment space management
  • Managing Oracle storage
  • Using the DBMS_STATS package to generate statistics
  • Execution plan cache
  • Oracle9i resumable space allocation
  • Security using roles, privileges and fine-grained access control
  • Using the Oracle Enterprise Manager (OEM)
  • Leveraging the OEM console
  • Database triggers

Prerequisites

  • This is an accelerated Oracle database administration class designed for experienced DBAs from non-Oracle platforms.


 
 
 

Trubix Inc. P.O. Box 2235 Littleton, CO 80161 | 1.866.4-TRUBIX • 303.730.6800
email: info@trubix.com
....................................................................................................................................................................

Training Service | Consulting / Mentoring | Public Schedule | Course Listings | Tru iLearning | About Us | Contact Us
Oracle DBA Classes | Oracle Dev Classes | Oracle App Server Classes | Linux / Unix Classes
SQL Server / .NET / Tools / DB2 Classes / Public Classes

 

 
all content property © 2006, 2007Trubix Inc.| site design by Art Z design