Oracle 9i Administration Course Book

About this Course Book

This book provides the foundation skills necessary to create, maintain and manage an Oracle 9i database. We focus on techniques and skills for day-to-day DBA tasks such as security, creating users, creating objects (tables, tablespaces) and backup and recovery. An in-depth discussion of database architecture is included. This course can help prepare you for Oracle Certified Professional exam "Oracle 9i Database: Fundamentals I Exam #1Z0-031" and also covers some of the material required for the next test, "Oracle 9i Database: Fundamentals II Exam #1Z0-032".

These course books are made available by SkillBuilders, a leading provider of Oracle and IT training, Oracle database consulting and Oracle software since 1985. These course books are produced by experienced Oracle and IT professionals, and are the same high-quality materials used in SkillBuilders' classes.

Feel free to use this online-only material for educational purposes, for self-study or as part of classroom or guided e-learning. You can purchase professionally-bound copies of any course book, complete with scripts and solutions, at SkillBuilders.com. Training vendors can also order printed copies bound in their own company-supplied covers.

Content on this site remains © Skillbuilders and may not be printed, reproduced, redistributed or resold.

Oracle 9i Administration Preface

Lesson 1: Introduction to the Data Dictionary

Lesson 2: Oracle Architecture Part 1 — Files

Lesson 3: Oracle Architecture Part 2 — Processes

Lesson 4: Oracle Architecture Part 3 — Memory

Lesson 5: Creating Administrative Users

Lesson 6: Starting and Stopping an Instance

Lesson 7: Initialization Parameter Files

Lesson 8: Creating and Managing Users

Lesson 9: Password Management

Lesson 10: Introduction to Auditing