|
ACKNOWLEDGMENTS |
xv |
|
INTRODUCTION |
xvi |
|
1 Database Fundamentals |
1 |
|
Critical Skill 1.1 Define a Database |
2 |
|
Critical Skill 1.2 Learn the Oracle Database 10g Architecture |
3 |
|
The Control Files |
4 |
|
The Online Redo Logs |
4 |
|
The SYSTEM Tablespace |
5 |
|
The SYSAUX Tablespace |
5 |
|
Default Temporary Tablespace |
5 |
|
Undo Tablespace |
5 |
|
The System Parameter File |
6 |
|
Background Processes |
6 |
|
Project 1-1 Reviewing the Oracle Database 10g Architecture |
8 |
|
The Database Administrator |
9 |
|
Critical Skill 1.3 Learn the Basic Oracle Database 10g Data Types |
10 |
|
varchar2 |
10 |
|
number |
10 |
|
date |
11 |
|
timestamp |
11 |
|
clob |
12 |
|
blob |
12 |
|
Critical Skill 1.4 Work with Tables |
12 |
|
Tables Related to part_master |
13 |
|
Critical Skill 1.5 Work with Stored Objects |
14 |
|
Views |
15 |
|
Triggers |
16 |
|
Procedures |
16 |
|
Functions |
16 |
|
Packages |
17 |
|
