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
• 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 databases with clusters and bitmap indexes
Prerequisites
• Oracle Database 10g: Introduction to SQL Part I • Oracle Database 10g: Introduction to SQL Part II
Course Benefits
At Course Completion:
• 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 databases with clusters and bitmap indexes
