Overview of Oracle Database Administration

• Structure of a Relational Database
• SQL
• Components of an Oracle Instance and Database
• Basic Tasks of an Oracle DBA
• Tools Used to Administer an Oracle Database

Installing Oracle Database and Creating the Database

• Using the Oracle Universal Installer to Install the Oracle Database Software
• Using DBCA to Create a Database
• Using DBCA to Manage Templates

Using Oracle Enterprise Manager Database Control and SQL*Plus

• Overview of Administering the Database Using Enterprise Manager
• Starting the Enterprise Manager Console Process
• Granting Enterprise Manager Administrative Privileges
• Setting Enterprise Manager Preferred Credentials
• Using SQL*Plus to Access Your Database

Configuring the Oracle Network Environment

• Tools for Configuring and Managing the Oracle Network
• Using the Enterprise Manager Net Services Administration Page
• Managing the Oracle Net Listener with Enterprise Manager
• Using the Listener Control Utility
• Oracle Net Naming Methods
• Using Enterprise Manager to Configure Local Naming
• Using Oracle Net Manager to Configure Local Naming

Managing the Oracle Instance

• Oracle Instance Management
• Starting the Instance and Opening the Database
• Viewing and Modifying Initialization Parameters
• Managing Memory Components
• Viewing the Alert Log

Managing Database Storage Structures

• Oracle Database Structures
• Multiplexing the Redo Log
• Enlarging the Database
• Creating, Modifying, and Dropping Tablespaces
• Reclaiming Space in Your Tablespace
• Managing Undo Data
• Using the Undo Advisor to Compute the Minimum Undo Tablespace Size

Administering Users and Security

• Overview of Users and Security
• Creating, Modifying, and Dropping Users
• Unlocking a User Account and Resetting the Password
• Setting the Password Policy
• Administering Privileges and Roles

Managing Schema Objects

• Creating, Modifying, and Dropping Tables
• Understanding Data Integrity and Defining Constraints
• Viewing the Contents of a Table
• Creating and Dropping Indexes
• Managing Views
• Managing Program Code Stored in the Database
• Managing Access to Schema Objects
• Loading Data

Performing Backup and Recovery

• Backup, Restore, and Recovery Concepts
• Configuring the Database for Backup and Recovery
• Configuring Backup Settings
• Backing Up the Database
• Using the Oracle-Suggested Backup Strategy
• Performing Backup Maintenance Tasks
• Using Oracle Advised Recovery to Recover the Database
• Performing Flashback Table and Flashback Drop

Monitoring the Database and Using the Advisors

• Monitoring General Database State, Workload, and Performance
• Setting Metric Thresholds
• Setting Up Direct Alert Notification
• Viewing ADDM Performance Analysis and Responding to Findings
• Using the SQL Tuning and SQL Access Advisors
• Configuring the Automatic SQL Tuning Advisor
• Viewing Automatic SQL Tuning Results

Investigating, Reporting, and Resolving Problems

• Using the Enterprise Manager Support Workbench
• Workflow for Investigating, Reporting, and Resolving a Problem
• Performing the Tasks to Investigate and Report a Critical Error

Managing Oracle Database Software

• Understanding Software Management and Patch Releases
• Patching Oracle Database Software
• Using the Database Upgrade Assistant to Upgrade the Database