Introduction to Oracle
Identify the oracle product - Describe the basic concept of a relational database

Installing oracle database 10g software:
System requirements. - Use Oracle Optimal Flexible Architecture (OFA) - Install software with the Oracle Universal Installer

Create an oracle database:
Oracle Database Architecture. - Oracle instance architecture. - Use the management framework. - Use the Database Creation Assistant.

Controlling the database:
Start and stop the agent - Start and stop the enterprise manager database console - Start and stop the listener - Startup and shutdown the database

Storage Structures
Defining the tablespaces and data files - Create tablespaces - Manage tablespaces - Obtain tablespace information - Create and manage tablespace using oracle enterprises manager.

Administering users:
Create and manage database user accounts - Create and manage roles - Grant and revoke privileges - Control resource usage by users.

Managing schema objects
Create and modify tables - Define constraints - View the attributes of a table - View the contents of a table - Create indexes and views

Managing Data
Manipulating data through SQL - Using Import - Using Export - Using SQL Loader

PL/SQL
Identify PL/SQL objects - Understand triggers and triggering events - Identify configuration options that affect PL/SQL performance

Oracle Database Security
Apply the principal of least privilege - Manage default user accounts - Implement standard password security features - Audit database activity

Oracle Net Services
Understand Oracle Net concepts - Use Oracle Net Manager to create and configure listeners - Use the listener control utility to control the Oracle Net Listener - Use the Oracle Net Manager to configure client and middle-tier connection - Use TNSPING to test Oracle Net connectivity

Oracle Shared Server
Understand when to use Oracle Shared Servers - Configure Oracle Shared Servers - Monitoring Shared Servers

Performance Monitoring
Troubleshoot invalid and unusable objects - Gather optimizer statistics - View performance metrics - React to performance issues

Proactive Maintenance: Objectives
Set warning and critical alert thresholds - Collect and use baseline metrics - Use tuning and diagnostic advisors - Use the Automatic Database Diagnostic Monitor (ADDM) - Manage the Automatic Workload Repository

Undo Management
Monitor and administer undo - Configure undo retention - Guarantee undo retention - Use the undo advisor

Monitoring and Resolving Lock Conflicts
Detect and resolve lock conflicts - Manage deadlocks

Backup and Recovery
Describe the basics of database backup, restore and recovery - List the types of failure that may occur in an Oracle Database - Describe ways to tune instance recovery -Identify the importance of checkpoints, redo log files, and archived log file -Configure ARCHIVELOG mode

Database backups
Create consistent database backups - Back your database up without shutting it down - Create incremental backups - Automate database backups - Monitor the flash recovery area

Database Recovery
Recover from loss of a control file - Recover from loss of a redo log file - Recover from loss of a data file

Using Globalization Support
Datetimes with Timezones - Specifying Language-Dependent Behavior -Locale Variants - Linguistic Sorting - Case and Accent Insensitive Sorts - Linguistic Comparisons - Obtaining Information about the Current NLS Configuration

Diagnostic Sources
The Alert Log - Viewing Alerts with EM - Alerts Notification - Editing Thresholds - Trace Files

Recovering from non-critical losses
Creating New Temporary Tablespace - Recreating Redo Log Files - Recovering an Index Tablespace - Read-Only Tablespace Recovery - Loss of Password - Authentication File

Monitoring and Managing Memory
Oracle Memory Structures - Automatic PGA Memory Management - Using the Memory Advisor - Using Automatic Shared Memory Management to avoid long running query issues