Experience Digitally Assisted Learning at it's Best

Oracle8 Series

Total Time: 30 hours

 

Oracle8: Installing Oracle Time: 4 hours ORCC01

Oracle8: Installing Oracle introduces users to Oracle administration and shows how to install Oracle8.

  • Introduction to Oracle Administration
  • How Oracle Operates
  • Oracle Performance
    		•
  • Preparing for Installation
  • Installing Oracle
  • The Oracle Components
    		•


     

    Oracle8: Database Management Time: 5 hours ORCC02

    Oracle8: Database Management shows users how to manage the Oracle8 databases and servers.

  • Planning for Capacity and Sizing
  • Calculating the System Requirements
  • Calculating the Disk Requirements
  • Managing the Database
    		•
  • Server Manager and NT Bootstraps
  • Starting and Shutting Down Instances
  • Connecting to and Modifying an Instance
    		•


     

    Oracle8: Building Databases Time: 4 hours ORCC03

    Oracle8: Building Databases shows users how to create and set up new Oracle databases.

  • Database Planning and Design
  • Creating a New Database and Catalogs
  • Modifying Databases
    		•
  • Creating Tablespaces
  • Modifying Tablespaces
  • Managing Tablespaces
    		•


     

    Oracle8: Files, Data, and Users Time: 4 hours ORCC04

    Oracle8: Files, Data, and Users shows users how to manage files, import and export data, and manage user accounts.

  • Redo Log Files
  • Control Files and Rollback Segments
  • Managing Rollback Segments
  • Creating User Accounts
    		•
  • Modifying User Accounts
  • Managing User Profiles
  • Managing User Roles
    		•


     

    Oracle8: Database Schema Objects Time: 4 hours ORCC05

    Oracle8: Database Schema Objects shows users how to manage tables and indexes.

  • Understanding Tables
  • Creating Tables
  • Special Tables and Table Views
  • Indexes
    		•
  • Creating Indexes
  • Special Indexes
  • Synonyms and Table Sequences
    		•


     

    Oracle8: Processes and Security Time: 4 hours ORCC06

    Oracle8: Processes and Security explains server processes to students and how to use Oracle security features.

  • Understanding Processes
  • The Parallel Query Option
  • Monitoring Processes
    		•
  • Managing Job Queues
  • Using Oracle Auditing
    		•


     

    Oracle8: Backup and Recovery Time: 5 hours ORCC07

    Oracle8: Backup and Recovery shows students how to protect Oracle database data by creating and using backups.

  • Oracle Backups
  • Configuring Disks for Protection
  • Backup and Recovery strategies
  • Backing Up the Database
    		•
  • Recovering the Database
  • Replicating Databases
  • Configuring Replication
  • Other Replication Options
    		•

     

     


    © 2003 Bridgeway Cyber Academy
     334 Second Street
    Catasauqua PA 18032

    Designed & Administered by PolyWeb Development