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
|