Contents

ACKNOWLEDGMENTS

INTRODUCTION

1 Database Fundamentals

Critical Skill 1.1 Define a Database

Critical Skill 1.2 Learn the Oracle Database 10g Architecture

The Control Files

The Online Redo Logs

The SYSTEM Tablespace

The SYSAUX Tablespace

Default Temporary Tablespace

Undo Tablespace

The System Parameter File

Background Processes

Project 1-1 Reviewing the Oracle Database 10g Architecture

The Database Administrator

Critical Skill 1.3 Learn the Basic Oracle Database 10g Data Types

varchar2

number

date

timestamp

clob

blob

Critical Skill 1.4 Work with Tables

Tables Related to part_master

Critical Skill 1.5 Work with Stored Objects

Views

Triggers

Procedures

Functions

Packages

Critical Skill 1.6 Become Familiar with Other Important Items in the ...

Get Oracle Database 10g: A Beginner's Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.

Start your free trial