Login 
Password
  
 


Free Exams!
Test your skills with one of our certification exams and see how you stack up right now.

Homepage
Visit our homepage and find out more about what NCSA can do for you.

Learn More About Us
Find out more about how our certifications can benefit you.

Course Descriptions
View a complete listing of certifications available through NCSA.

Access 2000
Excel 2000
Word 2000
PowerPoint 2000
Access 2002
Excel 2002
Word 2002
PowerPoint 2002
Office 2000
Office XP
Windows 2000 Pro
Windows 2000 Server
Visual C++
JavaScript
Computer Hardware
ColdFusion 4.5
HTML 4.0

HTML Tag Library
Visit our HTML tag library, a free reference we provide to our visitors.

Certificate Database
Lookup a certification in our online database.

Affiliate Program
Make money by helping people get the computer training and certification they need. Sign-up Here!

Support Center
If you have questions or concerns feel free to visit our online support center.


 


In addition to our training courses we also offer free online certification exams on several topics including Microsoft Office, Computer Hardware, HTML, PC Basics and more.

Click here for online certification exams.


This complete training course for the Oracle 8iR2 includes 5 CD-ROM's and contains over 7 hours of professional quality instructor led training. Multimedia content allows you to quickly learn key concepts and the CD format lets you quickly pause and review important areas. A detailed outline of the course as well as a short introduction to the trainer are included below.

   Oracle 8 set of 5 (CD) $649.95
   Oracle 8 set of 5 (VHS) $649.95
   Shipping (US only)
FREE

About The Trainer:

George J. Trujillo Jr. is the President and CEO of Trubix Inc., which specializes in delivering leading edge technical training and courseware in Oracle8i and Java. Trubix has been delivering training in Oracle8 and Java since the first beta releases. George has been a technical software consultant for over 17 years and has been a senior technical lead on numerous, Oracle, Unix, Java, C++ and C software development projects. In addition, George has also been a major presenter at numerous International Oracle and Java Users Group conferences. He has strong experience as a senior technical consultant and instructor in Oracle8i, Object Oriented technology, Java, J2EE, Oracle Developer, C, C++, Client/Server, Open Systems and UNIX.

 Level 1 (2 Hrs. 22 Min.)

  Oracle8i Architecture (1 Hr. 20 Min.)

  • DBA Environment
  • Server Architectural Overview
  • Database Comps
  • Logical Storage Structure
  • Data Blocks
  • Tablespaces
  • Oracle8i JVM
  • Multithread Server
  • Optimal Flexible Architecture
  • DBA Products
  • Summary
  Oracle Memory Structures & Processes (1 Hr. 2 Min.)

  • Setting up Environment
  • DB Buffer Cache
  • Multiple Buffer Cache Pools
  • Storage Clause
  • Hit Ratios
  • Caching Tables
  • Redo Log Buffer Cache
  • Large Pool & Java Pool

 Level 2 (2 Hrs. 9 Min.)

  Oracle Memory Structures & Processes (47 Min.)

  • Sorting
  • Checkpoints
  • Server Processes
  • Background Processes
  • SQL Statement Parsing
  • Optimizers
  • Parallel Operations
  • Summary
  Data Dictionary (39 Min.)

  • Metadata
  • Static Views
  • Dynamic Views
  DBA Utilities (43 Min.)

  • Administration Utilities
  • Installation Features

 Level 3 (2 Hrs. 15 Min.)

  Creating an Oracle Instance & Database (1 Hr. 25 Min.)

  • Starting & Shutting down a Database
  • Shutdown Options
  • Alter Database Commands
  • Preparing the Setup
  • Creating a Database Process
  • Create Database Command
  • What CREATE Database Creates
  • Database Creation Wrapup
  • Alert & Trace Files
  • Dynamic Views
  Managing Tablespaces & Data Files (50 Min.)

  • Create Tablespace Overview
  • Create Tablespace Command
  • Creating a Tablespace
  • Types of Tablespaces
  • Alter Tablespace Command
  • Temporary Tablespaces
  • Read-only Tablespaces
  • Coalescing Tablespaces
  • Alter Tablespaces Examples
  • Tablespace Offline Options
  • Renaming a Data File
  • Adding Sspace to a Database
  • Dropping Tablespaces
  • Dat

 Level 4 (1 Hr. 53 Min.)

  Managing Rollback & Temporary Segments (43 Min.)

  • Data Blocks
  • Data Dictionary Views
  • Rollback Segments
  • Laying out Rollback Segments
  • The Optional Parameter
  • Create Rollback Segment Command
  • Alter & Drop Commands
  • Set Transaction Command
  • Using Data Dictionary Views
  • Recommendations
  • Temporary Segments
  Control & Redo Log Files (1 Hr. 10 Min.)

  • Control File Contents
  • Data Dictionary Views
  • Multiplexing Control Files
  • Review of Redo Log Files
  • Writing to Redo Log Files
  • Log Sequence Numbers & Checkpoints
  • Adding Redo Log Files
  • Clearing Redo Log Files
  • Dropping Redo Log Files
  • Renaming Redo Log Files
  • Archive Log List Command
  • Data Dictionary Views

 Level 5 (1 Hr. 49 Min.)

  Managing Users & Profiles (48 Min.)

  • Managing Users
  • Creating User Account
  • Alter User Command
  • Creating Profiles
  • Database Resource Limits
  • Create Profile Command
  • Password Managing
  • Password Complexity
  • Password Resource Limits
  • Resource-Limit Parameter
  • Defining Password Management
  • Assigning Profiles
  • Data Dictionary Views
  • Data Encryption
  Managing Privileges (61 Min.)

  • System Privileges
  • Object Privileges
  • Working with Roles
  • Grant Command
  • Viewing System Privileges
  • Granting Objects Privileges
  • Viewing Privileges & Roles
  • Revote Command
  • Database Authentication & Access
  • Standard Predefined Roles
  • Setting Up a Role
  • Working with Roles
  • Enabling & Disabling Roles
  • Guidelines for Role
  • Oracle8i Enhanced Security

Please visit our special offers page to view some superb offers from our partners on the web. To view our special offers click here.

Or continue browsing our courses below.


3D Studio Max
A+ 2003
Microsoft Access 2007
Acrobat 4
ActiveX and OLE
Adobe Illustrator
Adobe InDesign CS
Adobe PhotoShop CS
ASP .NET
AutoCAD 2000
C Programming
C# Programming
Cisco CCNA
CompTIA Security+
CorelDRAW 10
Crystal Reports 8
Delphi 6

Exchange Server 2000
Flash 5
Frontpage 2000
ICDL/ECDL
IIS 5
Java 2
Linux 101
Linux 102
Lotus Notes 5
MicroSoft .NET
Network+ 2002
Oracle 8iR2
Outlook 2000
Outlook XP
PageMaker 6.5
Paradox 8

Perl 5
PhotoDraw 2000
PhotoPaint 8
SQL Server 2000
TCP/IP 4
Unix
Visio 2002
VB .NET
VBScript 5
Visual FoxPro 6
MCSE 2000
Windows XP User
WordPerfect 9
WordPerfect 11
XML
ZenWorks 3.0

     

     


Typing Speed Test
Test your typing speed with our certified typing speed test today.

  
HOME      EMPLOYERS    TESTING CENTERS    CERTIFICATION LIST    INSURANCE QUOTES    AFFILIATES    CONTACT US

© 2002-2010 National Computer Science Academy, All Rights Reserved.