Features

• Lesson 1
  Installing an Oracle Database
  - The Oracle Universal Installer
  - Oracle10g Standard Edition
  - Following Best Practices
  - Optimal Flexible Architecture (OFA)
  - Installation Options
  - Steps for Creating an Oracle Database
  - The Database Creation Assistant (DBCA)
  - Defining Installation Options
  - The Installation Process
  - Creating the Oracle Database
  - Validating the Installation
• Level 2
  Understanding the Oracle Environment
  - Introduction to Oracle Enterprise Manager (OEM)
  - Using OEM to Manage Your Oracle Environment
  - Features of OEM
  - Main Components of OEM
  - The OEM Central Console
  - The Main Components of an Oracle Instance
  - Managing Oracle Memory
  - Oracle Database Files
  - Different Database Files
  - Oracle Storage Options
  - Understanding How Oracle Works
  - Oracle Concepts & Terminology
  - Oracle Networking Software
  - Overview of Oracle Products & Tools
  - SQL *Plus
  - SQL Worksheet
  - SQL Scratchpad
  - The OEM Web Site
• Level 3
  Using OEM for Database Management
  - Starting Up an Oracle Instance & Database
  - Shutting Down an Oracle Instance & Database
  - Creating Database User Accounts
  - Managing Database User Accounts
  - Managing Default User Accounts
  - Implementing Password Management
  - Understanding Oracle Security
  - System and Object Privileges
  - Granting & Revoking Privileges
  - Working With Roles
  - Creating a Simple Backup
• Lesson 4
  Managing Memory & the Oracle Instance
  - Using OEM to Manage Oracle Memory
  - Initialization Files
  - Using an SPFILE
  - Using an init.ora File
  - SPFILE or init.ora File
  - Oracle Network Services
  - Changing Oracle Memory & Configurations
  - Using an Oracle Dedicated Server
  - Using an Oracle Shared Server
  - Performing Normal Maintenance on an Oracle Instance
  - Oracle Network Services
  - Setting up Oracle Networking
  - Using Oracle Net Manager to Manage Listeners
  - Testing Oracle Networks
  - Customizing the Library
• Lesson 5
  Managing & Configuring the Oracle Database
  - Understanding an Oracle Database
  - Database Configuration Options
  - Setting Up Data Files
  - Setting Up Control Files
  - Creating Redo Log Groups
  - Managing Redo Log Groups
  - Creating Redo Log Members
  - Managing Redo Log Members
  - Mirroring Redo Log Members
  - Setting Up Control Files
  - Mirroring Control Files
  - Adding Data Files
  - Modifying Data Files
  - Moving Database Files
  - Removing Control Files
  - Removing Redo Log Groups
  - Removing Redo Log Files
• Lesson 6
  Managing Storage & Schemas
  - Data Fuiles Versus Tablespaces
  - Setting Up Storage for Applications
  - The System Tablespace
  - Data Tablespaces
  - Index Tablespaces
  - Undo Tablespaces
  - Temporary Tablespaces
  - Additional Tablespaces
  - Adding Database Storage
  - Modifying Database Storage
  - Adding Data Files
  - Modifying Data Files
  - Adding/Removing Control Files
  - Adding/Removing Redo Log Groups
  - Adding/Removing Redo Log Files
  - Working With Tables
  - Table Maintenance
  - Working With Indexes
  - Index Maintenance
  - Managing Schema Objects