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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial