Oracle Database 10g Administration I

This course provides a starting point for administration of the Oracle database. It considers an in-depth discussion of the database architecture, including the Oracle instance, background processes, the SGA, and memory structures, data files, tablespaces, extents, blocks, and rows. Common administration tasks are also considered such as security, backup & recovery, physical storage of indexes and tables and many others.

Course Objectives

The course will cover the following elements:

  • Install, startup and shutdown an Oracle database
  • Explain the internal architecture of data, memory and process structures
  • Administer a security policy for the database
  • Configure a basic backup & recovery strategy
  • Control physical storage of tables and indexes
  • Build efficient database with clusters and bitmap indexes

Prerequisites

To ensure your success the following course is required:

  • Oracle database 10g: Introduction SQL part l
  • Oracle database 10g: Introduction SQL part ll

Course Benefits

Upon successful completion of this course students will be able to:

  • Install, startup and shutdown an Oracle database
  • Explain the internal architecture of data, memory and process structures
  • Administer a security policy for the database
  • Configure a basic backup & recovery strategy
  • Control physical storage of tables and indexes
  • Build efficient database with clusters and bitmap indexes

Course Duration: 40 Hours

×