Boston Computer School

Introduction

• 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 Database Creation Assistant

Controlling the database

• Manually configure the Oracle 10g EM dbconsole
• 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

Oracle Database Security --- Only Theory

• Apply the principal of least privilege
• Manage default user accounts
• Implement standard password security features

Oracle Net Services

• Understand Oracle Net concepts
• Use Oracle Net Manager to create and configure listeners
• Use the Oracle Net Manager to configure client and middle-tier connection
• Use TNSPING to test Oracle Net connectivity

Performance Monitoring

• Gather optimizer statistics
• View performance metrics

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

Monitoring and Resolving Lock Conflicts

• Detect and resolve lock conflicts
• Manage deadlocks

Diagnostic Sources

• The Alert Log
• Viewing Alerts with EM
• Alerts Notification ----- Only Theory
• Editing Thresholds ----- Only Theory
• Trace Files

Proactive Maintenance: Objectives --- Only Theory

• Set warning and critical alert thresholds
• Collect and use baseline metrics
• Use tuning and diagnostic advisors
• Use the Automatic Database Diagnostic Monitor (ADDM)

Automatic Storage Management ---- Only Theory

• ASM Concepts
• ASM General Architecture
• Creating an ASM instance
• Creating tablespaces that use ASM storage
• Viewing ASM information
• Migrating a tablespace to use ASM storage.

Undo Management --- Only Theory

• Monitor and administer undo
• Configure undo retention
• Guarantee undo retention
• Use the undo advisor

Backup and Recovery --- Only Theory

• 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

Managing Data

• Manipulating data through SQL
• Using Import
• Using Export

Database backups

• Configure ARCHIVELOG mode
• Create consistent database backups
• Back your database up without shutting it down
• Create incremental backups
• Automate database backups
• Monitor the flash recovery area

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

Database Recovery

• Recover from loss of a control file
• Recover from loss of a redo log file
• Recover from loss of a data file