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