| Instructor Introduction |
| Database Architecture |
| Architectural Components of the Oracle Database |
| Memory Structures |
| Server Processes and Background Processes |
| Logical and Physical Storage Structures |
| Module Summary |
| Review Quiz |
| Installing the Oracle Software |
| Database Administrator Tasks and Tools |
| Planning a Oracle Database Installation |
| Using Optimal Flexible Architecture |
| Installing the Oracle Software using OUI |
| Module Summary |
| Review Quiz |
| Creating an Oracle Database |
| Planning for Database Creation |
| Configuring the Listener |
| Creating a Database |
| Module Summary |
| Review Quiz |
| The Oracle Instance |
| Starting and Stopping the Oracle Database |
| Using the Oracle Enterprise Manager |
| Access a Database with SQL*Plus |
| Modify Database Initialization Parameters |
| Database Startup |
| Database Shutdown |
| Viewing the Alert Log and Dynamic Performance Views |
| Module Summary |
| Review Quiz |
| Oracle Network Environment |
| Creating and Configuring Additional Listeners |
| Creating Oracle Net Service Aliases |
| When to Use Shared and Dedicated Servers |
| Module Summary |
| Review Quiz |
| Database Storage Structures |
| Describe Table Row Data and Define Tablespaces |
| Creating and Managing Tablespaces |
| Automatic Storage Management |
| Module Summary |
| Review Quiz |
| User Security |
| Create and Manage User Accounts |
| Grant and Revoke Privileges |
| Create and Manage Roles |
| Create and Manage Profiles |
| Module Summary |
| Review Quiz |
| Schema Objects |
| Defining Schema Objects and Data Types |
| Creating and Modifying Tables |
| Defining Constraints |
| Viewing Columns and Contents of a Table |
| Creating Indexes |
| Creating Views |
| Creating Sequences |
| Using Temporary Tables |
| Module Summary |
| Review Quiz |
| Data and Concurrency |
| Managing data Using SQL |
| Identifying and Administering PL/SQL Objects |
| Monitoring and Resolving Locking Conflicts |
| Module Summary |
| Review Quiz |
| Undo Data |
| Implementing Undo Data |
| Working with Undo Data |
| Module Summary |
| Review Quiz |
| Security |
| DBA Security and Privileges |
| Enabling Auditing |
| Audit Options and Information |
| Fine Grained Auditing |
| Auditing the DBA and Maintaining the Audit Trail |
| Module Summary |
| Review Quiz |
| Maintenance |
| Managing Optimizer Statistics |
| Managing Automatic Workload Repository |
| Using the Automatic Database Diagnostic Monitor |
| Setting Alerts and Thresholds |
| Module Summary |
| Review Quiz |
| Oracle Performance |
| Performance Monitoring with the Enterprise Manager |
| Using Automatic Memory Management |
| Viewing Performance Related Dynamic Views |
| Troubleshooting invalid and Unusable Objects |
| Module Summary |
| Review Quiz |
| Backup and Recovery |
| Types of Database Failure |
| Checkpoints, Redo Log Files, and Archive Log Files |
| Instance Recovery |
| Configuring for Recoverability |
| Configuring Archive Log Mode |
| Module Summary |
| Review Quiz |
| Database Backups |
| Backup Solutions Overview |
| Configuring Backup Settings |
| Scheduling Backups |
| Backing up Control Files to a Trace File |
| Managing Backups and the Flash Recovery Area |
| Using the RMAN Command Line |
| Module Summary |
| Review Quiz |
| Recovery |
| Recovering From a Lost Control File |
| Recovering Redo Log Files |
| Recovering Non Critical and Critical Data Files |
| Using the Data Recovery Advisor |
| Module Summary |
| Review Quiz |
| Moving Data |
| Moving Data and Creating Directory Objects |
| Loading Data with the SQL Loader |
| Creating and Reading External Tables |
| Using Oracle Data Pump Export and Import |
| Data Pump Performance and Monitoring |
| Module Summary |
| Review Quiz |
| Database Maintenance |
| Using the Enterprise Manager Support Workbench |
| Metalink Integration and Managing Patches |
| Module Summary |
| Review Quiz |
| Course Review |
