O'Reilly logo

Oracle Database 10g: A Beginner's Guide by Michael Corey, Michael Abbey, Ian Abramson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required